| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a sheet in a workbook as .csv but not changing workbook name
If the workbook is a CSV, then savecopyAs saves a copy as CSV.
-- Regards, Tom Ogilvy "gloryofbach" wrote in message ... Hello Kaak, Thank you very much for your considered reply - funny enough your method is the exact same way I am doing it. My issue is that I am saving the data.csv every 20 seconds for 8 hours a day (the process runs on a timer to ensure data.csv is always up to date). In this sense the method seems rather inelegant, as you are having to create a new workbook each time etc and the temporary workbook number is Book1 etc... by the end of the day it will be book1500 etc... This isnt a big deal but I am surprised you cannot use savecopyas function to save a sheet as a csv file! Is my understanding correct? Alex -- gloryofbach ------------------------------------------------------------------------ gloryofbach's Profile: http://www.excelforum.com/member.php...o&userid=28322 View this thread: http://www.excelforum.com/showthread...hreadid=480090 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| specify each sheet name when saving workbook as html | Excel Discussion (Misc queries) | |||
| Changing the name of a workbook without saving it | Excel Programming | |||
| Saving one sheet within a workbook | Excel Discussion (Misc queries) | |||
| saving sheet as new workbook | Excel Programming | |||
| Saving only 1 sheet of a workbook | Excel Programming | |||
Threaded Mode
