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

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" <gavsta.1vi2ia_1126955125.8382@excelforum-nospam.com> wrote
in message news:gavsta.1vi2ia_1126955125.8382@excelforum-nospam.com...
>
> 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
>