Search found 15 matches

by Marty123
Jul 23rd, ’22, 08:15
Forum: General Discussion
Topic: Date in DD/MM/YYYY format to input into excel's cells
Replies: 2
Views: 122

Date in DD/MM/YYYY format to input into excel's cells

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 := true PH...
by Marty123
Jun 29th, ’22, 05:57
Forum: General Discussion
Topic: Parse through a FDF file.
Replies: 2
Views: 125

Re: Parse through a FDF file.

I will try it! Thanks Marko !
by Marty123
Jun 25th, ’22, 15:25
Forum: General Discussion
Topic: Parse through a FDF file.
Replies: 2
Views: 125

Parse through a FDF file.

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...
by Marty123
Jun 14th, ’22, 01:24
Forum: General Discussion
Topic: What's new in FastKeys 5.08?
Replies: 2
Views: 142

Re: What's new in FastKeys 5.08?

Thank you
by Marty123
Jun 13th, ’22, 09:16
Forum: General Discussion
Topic: What's new in FastKeys 5.08?
Replies: 2
Views: 142

What's new in FastKeys 5.08?

New update. Anything new ?
by Marty123
Jun 13th, ’22, 04:25
Forum: General Discussion
Topic: Using textexpander string "addr1"
Replies: 4
Views: 161

Re: Using textexpander string "addr1"

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...
by Marty123
Jun 12th, ’22, 09:41
Forum: General Discussion
Topic: Using textexpander string "addr1"
Replies: 4
Views: 161

Re: Using textexpander string "addr1"

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...
by Marty123
Jun 12th, ’22, 08:57
Forum: General Discussion
Topic: Using textexpander string "addr1"
Replies: 4
Views: 161

Using textexpander string "addr1"

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 := True ahmen.Workbooks.Open(Path) ;you ca...
by Marty123
Jun 4th, ’22, 12:59
Forum: General Discussion
Topic: Excel Import
Replies: 2
Views: 149

Re: Excel Import

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