Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File name being changed
In 2003 Excel VBA, this code saved the name correctly:
Application.Calculation = xlCalculationAutomatic ChDir "K:" wNFileName = "k:Safety\" & Left(wFileName, Len(wFileName) - 4) & " " & Format(Now(), "mmddyy") & ".xls" ActiveWorkbook.SaveAs FileName:=wNFileName ActiveWorkbook.Close ChDir ".." ActiveWorkbook.SaveAs FileName:="k:" & wFileName So a file name of "Quota File MW 201003.xls" would save with exactly that filename. Just upgraded to 2007 and same code now saves "Quota%20File%20MW%20201003.xls" which I assume is URL encoding. How can I turn that off, or have Excel 2007 revert back to 2003 behavior?? Thanks!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File name being changed
Hi Bbotz,
I would replace all spaces " " with an underscore "_". So you would get "Quota_File_MW_201003.xls", using ActiveWorkbook.SaveAs FileName:=Replace(wNFileName, " ", "_") Besides I see something strange in this part: "k:Safety\" TMHO it should be "k:\Safety\" HTH, Wouter |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File name being changed
Can anyone please help with this???
"bbotz" wrote: In 2003 Excel VBA, this code saved the name correctly: Application.Calculation = xlCalculationAutomatic ChDir "K:" wNFileName = "k:Safety\" & Left(wFileName, Len(wFileName) - 4) & " " & Format(Now(), "mmddyy") & ".xls" ActiveWorkbook.SaveAs FileName:=wNFileName ActiveWorkbook.Close ChDir ".." ActiveWorkbook.SaveAs FileName:="k:" & wFileName So a file name of "Quota File MW 201003.xls" would save with exactly that filename. Just upgraded to 2007 and same code now saves "Quota%20File%20MW%20201003.xls" which I assume is URL encoding. How can I turn that off, or have Excel 2007 revert back to 2003 behavior?? Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File References have changed | Excel Discussion (Misc queries) | |||
why is absolute hyperlink in XLS file changed when file is saved | Excel Discussion (Misc queries) | |||
How to make a routine that will automatically print a word file after it has been changed via an ole link to an excel file? | Excel Programming | |||
Excel is not asking to save a changed file when the file is closed | Excel Discussion (Misc queries) | |||
Event for a file being changed? | Excel Programming |