Create Word Document from VBA Routine

[strorg]

I have just started experimenting with this. I am able to launch the application and create a new file. Copy data from the spreadsheet to the new document. I need help checking for an existing .doc file. If the file exists, I want to overwrite it with the newly created version.

Any advice appreciated...as always.

Regards...Tom

 

[Damon Ostrander]

Hi Tom,

Check out the VBA Dir() function. It will return a zero-length string if the file doesn't exist.