Using SendKeys with Notepad

[JonesZoid]

Hi All,
I have the following code which works a treat....

Please Login or Register  to view this content.

What i would like to do now - in cell D2 of the spreadsheet i have a site name. I would like to add this at the end of the "ATN950_Standard_Config_EVEN1_"

This would then give the save as dialog the correct filename - allowing the user just to navigate to their favourite save place.

Hopefully

Craig

[shg]

Why not instead just prompt the user to select a folder, and write to a text file in that directory?

[JonesZoid]

This wouldn't be possible as each text file being generated is different and has the site name at the end for identification.

Craig

[shg]

I'm missing why that is a limitation in any way.