Thanks So much, Tom!

HI Marko, Hi Tom, I like to key in the date in DD/MM/YYYY format in 2 cells of an excel worksheet. Here's my code. Inputbox, inputpath,, FPfile:,,200,120 Inputbox, inputpath2,, PHfile:,,200,120 Path := inputpath Path2 := inputpath2 PHfile :=ComObjcreate("Excel.Application") PHfile.visible ...

I will try it! Thanks Marko !

Hi guys, need some help here with parsing through a FDF file, which is essentially a txt file that contains fields information of a pdf file which I will use later (the fdf file) to populate fields of the target pdf file. The quick summary is that it is a plain text file consisting of key-value pair...

Thank you

New update. Anything new ?

Wow, thanks, I didn't know these variables can be run on start up. That's heartening Anyway, you've been clear in your previous replies, and I understood.it's just I wanted a way to use those text expander strings since they were already imported and present anyway. Thanks Marko. As usual thanks for...

Hi Marko, I have an excel file which my client populate on their end, and email to me. It consist of his bio info,residence, contact info, etc. There is a total of 20 fields or so. I doubt the user variables has that much entries to spare, but that's beside the point. I then import the excel into te...

Hi Folks, i wish to use a text expander abbrev "addr1" which contains an address, to fill into one of cell (b1)of file "statement.xlsx" Here's the code. Path := "C:\Users\master\Desktop\Statement.xlsx" ahmen :=ComObjcreate("Excel.Application") ahmen.visible :=...

Hi Marko, thank you. I've reached out and you've replied. I tried your solution and it works. Thanks.