How to separately save spreedsheets from the same workbook
 

Hello

How can I save spreedsheets from the same .xls workbook maintaining the tab
name on my desktop in .txt format?

Txs

How to separately save spreedsheets from the same workbook
 

You can change the save line in this example
http://www.rondebruin.nl/copy6.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"anaipa" wrote in message ...
Hello

How can I save spreedsheets from the same .xls workbook maintaining the tab
name on my desktop in .txt format?

Txs

How to separately save spreedsheets from the same workbook
 

Below the macro you can see how you must change it for TXT files

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
You can change the save line in this example
http://www.rondebruin.nl/copy6.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"anaipa" wrote in message ...
Hello

How can I save spreedsheets from the same .xls workbook maintaining the tab
name on my desktop in .txt format?

Txs

How to separately save spreedsheets from the same workbook
 

Try this macro:

Sub Macro1()
s1 = "C:\Documents and Settings\Owner\Desktop\"
For Each sh In Sheets
sh.Activate
s2 = sh.Name & ".txt"
ActiveWorkbook.SaveAs Filename:=s1 & s2, FileFormat:=xlText
Next
End Sub

--
Gary''s Student - gsnu200791


"anaipa" wrote:

Hello

How can I save spreedsheets from the same .xls workbook maintaining the tab
name on my desktop in .txt format?

Txs