Exporting Workbook with new name

[joehjas]

I'm currently working on a macro that export several rows and cells to a new workbook which then is saved as a txt-file with the same name as the original workbook.
I have written and worked out everything except the saving-part. I can't work out how to save the new file with a different name everytime.

Here's what i got so far:

Please Login or Register  to view this content.

[wamp]

not quite sure what you mean by "different name every time" you couled forinstance date-stamp the file: if that's what you're thinking about?

Please Login or Register  to view this content.

[joehjas]

What other operator can i use instead of Date, filename of the original workbook?

[royUK]

You are exporting a worksheet not a workbook.

something like

Please Login or Register  to view this content.

[joehjas]

Okay, maybe I am, but still; what are my options in naming the new file? Is there some way I can insert a different text each time(not date), maybe a increasing number for each time the file is saved?

[wamp]

to put it simple: you can achieve what ever you need; question is: what is it exactly that you want to achieve?
eg. if you had to do it manually, what would you do, how would you name the files; and why would you name them the way you would?

(the more info you give, the easier it is for us to understand what you want/need, thus easier to help)

[joehjas]

to put it simple: you can achieve what ever you need; question is: what is it exactly that you want to achieve?
eg. if you had to do it manually, what would you do, how would you name the files; and why would you name them the way you would?

(the more info you give, the easier it is for us to understand what you want/need, thus easier to help)

The original document, the excel-file, is a template for calculating sales quotes.
The document is upon creation saved automatically with a number(increasing by 1 each time).
What I want is the new file to have the same number.

[wamp]

Please Login or Register  to view this content.

in your example; it would be something like :

Please Login or Register  to view this content.

[joehjas]

Nice, that works
Any idea how to remove the .xlsm?
So I'll have 10001.txt instead of 10001.xlsm.txt

[wamp]

alter saveName to:

Please Login or Register  to view this content.

[royUK]

Okay, maybe I am,

It makes a big difference