| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving a workbook separately to its macros | Excel Discussion (Misc queries) | |||
| How do i add multi-spreedsheets together | Excel Worksheet Functions | |||
| DIFFERNCE BETWEEN EXCELL AND WORKS SPREEDSHEETS | Excel Discussion (Misc queries) | |||
| DIFFERNCE BETWEEN EXCELL AND WORKS SPREEDSHEETS | Excel Discussion (Misc queries) | |||
| how do i open spreedsheets created in works, with excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
