Recent content by maryenc

Wow! :eek: To make it open a new .doc from a .dot would take all of that & than some?!? Well, I'm not much of a programmer so, if it's that complicated, I'll just have to save an extra copy of the .doc the user is currently opening in case she hoses it again. Going from 1 line in a macro to...

Hello, Currently, I am mail merging data from Access into a Word .doc via a macro line: RunApp -> Command Line = "Winword.exe "i:\GIA\MergeLetter.doc"" This works fine for the merging, however, my user somehow unknowingly (evidently) changed the base MergeLetter.doc so that it no longer had...

Wow, thanks! I've added the reference as you indicate. I'll check into trying to get the rest of it to run for me in the morning. Pretty much looks like a foreign language to me, though, so I may have some additional questions for you. :)

That's similar to the same code I tried to copy/paste/edit today to make my own files work -- without success. Sub OpenTextFileTest() Const ForReading = 1, ForWriting = 2, ForAppending = 3 Dim fs, f, fa Set fs = CreateObject("Scripting.FileSystemObject") Set f =...

Ah, good question. The 3 files don't have the same fields. All 3 files must go into one transaction file for upload to our mainframe. Example... $$$NCF1CWS006100105CWS PAY PERI 06NFA NSA910A 80E111111111F106187100 0055556+0055556+ 0...

Hello, I need to take 3 text files that I am exporting from an Access db and append all 3 files together. Through my searching today, it appears that I need some code using OpenTextFile. I'm no good at VBA and my attempt at copying, pasting, and editing some prewritten code to do this has not...