| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem saving a file
Using Excel 2003, I issue the following command from a macro
ActiveWorkbook.SaveAs Filename = vNaam Active drive = G: which is a USB Drive vNaam contains a legitimate name, such as March or April Excel saves the file as FALSE.xls If I save the file to the same drive using the same name, it saves without problems, using the correct name. The name is not that of an existing file. What is wrong here? -- Hth Kassie Kasselman Change xxx to hotmail |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem saving a file
Hi Kassie
Could you please paste the code so as to recreate the issue. Jacob "Kassie" wrote: Using Excel 2003, I issue the following command from a macro ActiveWorkbook.SaveAs Filename = vNaam Active drive = G: which is a USB Drive vNaam contains a legitimate name, such as March or April Excel saves the file as FALSE.xls If I save the file to the same drive using the same name, it saves without problems, using the correct name. The name is not that of an existing file. What is wrong here? -- Hth Kassie Kasselman Change xxx to hotmail |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem saving a file
Hi,
change Filename = vNaam to Filename:= VNaam -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Kassie" wrote: Using Excel 2003, I issue the following command from a macro ActiveWorkbook.SaveAs Filename = vNaam Active drive = G: which is a USB Drive vNaam contains a legitimate name, such as March or April Excel saves the file as FALSE.xls If I save the file to the same drive using the same name, it saves without problems, using the correct name. The name is not that of an existing file. What is wrong here? -- Hth Kassie Kasselman Change xxx to hotmail |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem saving a file
How stupid can you get hey! I have been struggling with this all afternoon,
and could just not see my own mistake! I thank you my friend! -- Hth Kassie Kasselman Change xxx to hotmail "Shane Devenshire" wrote: Hi, change Filename = vNaam to Filename:= VNaam -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Kassie" wrote: Using Excel 2003, I issue the following command from a macro ActiveWorkbook.SaveAs Filename = vNaam Active drive = G: which is a USB Drive vNaam contains a legitimate name, such as March or April Excel saves the file as FALSE.xls If I save the file to the same drive using the same name, it saves without problems, using the correct name. The name is not that of an existing file. What is wrong here? -- Hth Kassie Kasselman Change xxx to hotmail |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem saving xlsx file | Excel Discussion (Misc queries) | |||
| problem saving as txt file | Excel Discussion (Misc queries) | |||
| File saving problem | Excel Discussion (Misc queries) | |||
| problem saving csv file | Excel Discussion (Misc queries) | |||
| problem when saving CSV file | Excel Worksheet Functions | |||
Linear Mode
