Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs problem
Okay, that didn't work. In addition to changing the file type, I want
to change the location of the file. "Tom Ogilvy" wrote in message ... Dim sName as String sName = Thisworkbook.Name sName = left(sName,len(sName)-4) Thisworkbook.SaveAs sName & ".xls", xlWorkbookNormal -- Regards, Tom Ogilvy "Jessi" wrote in message om... I'm working with a bunch of different files. I want to save the file once the macro is run, but I want it to save with the same file name, but a different file type. The files start out as .csv files and I want them to be regular excel files. The problem I have it getting it to keep the same file name. Thanks! Jessi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs problem
I want it to save with the same file name,
but a different file type. -- Regards, Tom Ogilvy Jessi wrote in message om... Okay, that didn't work. In addition to changing the file type, I want to change the location of the file. "Tom Ogilvy" wrote in message ... Dim sName as String sName = Thisworkbook.Name sName = left(sName,len(sName)-4) Thisworkbook.SaveAs sName & ".xls", xlWorkbookNormal -- Regards, Tom Ogilvy "Jessi" wrote in message om... I'm working with a bunch of different files. I want to save the file once the macro is run, but I want it to save with the same file name, but a different file type. The files start out as .csv files and I want them to be regular excel files. The problem I have it getting it to keep the same file name. Thanks! Jessi |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs problem
Thank you! It's works now. :]
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using SaveAs | Excel Discussion (Misc queries) | |||
Problem using SaveAs method | Excel Discussion (Misc queries) | |||
SaveAs - VBA | Excel Discussion (Misc queries) | |||
SaveAs problem, renames Worksheet too | Excel Programming |