Excel VBA : Managing Invoices - Save as PDF, Open, Edit, and Overwrite Invoice Data Dynamically

[@RhianAutumn]

This is a great video. Thank you! As someone learning excel a little deeper this is super helpful.

[@zsmentor]

Ma kafi month sa ya kr ny ki try kr rha th but yt pr sb time zaya kr rha th... but your vedio is superb 😘😘

[@sweetychannels7330]

How to create table name ?

[@MichaelWong2000]

How do I take out the "Logo Name"

[@martinargimon730]

hi there. i wonder if you could help me with one issue, as follows: I cannot get the PDF writer to accept my syntax when trying to add to the file path name the date of the invoice.
In other words i want to add to my file name as an example the Invoice Number, plus the date,. I've tried to save the date in a variable and then replace this variable tin the file name but the PDF writer doe not like.
example: Dim filePath As String
filePath = "C:\Users\martin argimon\CMA\CMA Realty - Documents\Administration\ICT\Database Program\Remittances Owners\" & _
"Remittance Lease No." & leaseno & " " & Format(WS2.Range("J14"), "yyyymmdd")
I would want to save the date in a variable and then call on the variable in the file path name. As you can see i have used the 'Format' range function, but when i insert my variable :
'invoicedate = Format(WS2.Range("J14"), "yyymmdd")

' Combine the file path with lease number and invoice date
Dim filePath As String
filePath = "C:\Users\martin argimon\CMA\CMA Realty - Documents\Administration\ICT\Database Program\Remittances Owners\" & _
"Remittance Lease No." & leaseno & " " & Format(WS2.Range("J14"), "yyyymmdd")
it does not like it?? any tips perhaps ?
Thanks
Martin

[@muhammadghafoor1982]

I need this file

[@rehanaashfaq5017]

already you have written all formulas so its difficult to understand

[@janimani813]

Brother need your helpt

[@AllAbout_Excel]

Please contact at [e-mail] i will help you out

[@muhammadghafoor1982]

Can you provide me

[@muhammadghafoor1982]

Hi