Exporting to a .txt file - VBA Code
 

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

Exporting to a .txt file - VBA Code
 

If you post attachments then most people will not (for obvious
reasons) open them to take a look at your code.

Instead, you should copy/paste the *relevant* code into your message.

Tim


"gavsta" wrote
in message ...

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