Hi Everyone - Need some help after a very tedious attempt with no luck -
Am a novice :-(

I have attached the .xls worksheet.

I am having problems trying to write code that will automate the
selection of a path selection for saving the file when the user click
on step 2 in the file.

the code at the moment, when you run the macro will ask the user to
enter their choice of where they want the file saved, but I don’t want
the user to choose. I just want the file saved to a path name that is a
combination of certain cells i.e. cell A1 = QLD, D3 = 3636125, H3 =
Promo851, so the file will be saved to c:/3636125QLDPromo851.txt.

Every time the user uses the worksheet different data is input, so each
time the user saves it, it will save to a different file name.

Any help on this would be great!! The file I have so far is some that I
source from the web.

cheers
Gavin


+-------------------------------------------------------------------+
|Filename: NEW NEW Template.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3834 |
+-------------------------------------------------------------------+

--
gavsta
------------------------------------------------------------------------
gavsta's Profile: http://www.excelforum.com/member.php...o&userid=23390
View this thread: http://www.excelforum.com/showthread...hreadid=468463