Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File save as produces corrupt file
Using XL2007. In code I open a text file (csv) and format it as I want it, then the program saves the file using: ActiveWorkbook.SaveAs MyFullFileName All runs fine. But, when I try to open the file, I get an error that says the file is corrupt or has an unrecognizable file extension...what the? This is using code I've used for years in 2003 without problem. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File save as produces corrupt file
Specify the extension in that filename and make sure you include the
fileformat:= parm in the .saveas line. And they have to be consistent, too! xp wrote: Using XL2007. In code I open a text file (csv) and format it as I want it, then the program saves the file using: ActiveWorkbook.SaveAs MyFullFileName All runs fine. But, when I try to open the file, I get an error that says the file is corrupt or has an unrecognizable file extension...what the? This is using code I've used for years in 2003 without problem. Any help would be appreciated. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File save as produces corrupt file
I do specify a file format so that is not the issue; however, "fileformat" is a new spec to me, I will check that out and see if it does the trick... Thanks Dave. "Dave Peterson" wrote: Specify the extension in that filename and make sure you include the fileformat:= parm in the .saveas line. And they have to be consistent, too! xp wrote: Using XL2007. In code I open a text file (csv) and format it as I want it, then the program saves the file using: ActiveWorkbook.SaveAs MyFullFileName All runs fine. But, when I try to open the file, I get an error that says the file is corrupt or has an unrecognizable file extension...what the? This is using code I've used for years in 2003 without problem. Any help would be appreciated. -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
File save as produces corrupt file
Dave,
FYI, you were right, the "FileFormat" spec is required now in order for this command to work correctly (at least in my case); thanks! "Dave Peterson" wrote: Specify the extension in that filename and make sure you include the fileformat:= parm in the .saveas line. And they have to be consistent, too! xp wrote: Using XL2007. In code I open a text file (csv) and format it as I want it, then the program saves the file using: ActiveWorkbook.SaveAs MyFullFileName All runs fine. But, when I try to open the file, I get an error that says the file is corrupt or has an unrecognizable file extension...what the? This is using code I've used for years in 2003 without problem. Any help would be appreciated. -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
File save as produces corrupt file
See also this page for more info
http://www.rondebruin.nl/saveas.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "xp" wrote in message ... Dave, FYI, you were right, the "FileFormat" spec is required now in order for this command to work correctly (at least in my case); thanks! "Dave Peterson" wrote: Specify the extension in that filename and make sure you include the fileformat:= parm in the .saveas line. And they have to be consistent, too! xp wrote: Using XL2007. In code I open a text file (csv) and format it as I want it, then the program saves the file using: ActiveWorkbook.SaveAs MyFullFileName All runs fine. But, when I try to open the file, I get an error that says the file is corrupt or has an unrecognizable file extension...what the? This is using code I've used for years in 2003 without problem. Any help would be appreciated. -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
File save as produces corrupt file
Great explanations, thanks Ron! "Ron de Bruin" wrote: See also this page for more info http://www.rondebruin.nl/saveas.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "xp" wrote in message ... Dave, FYI, you were right, the "FileFormat" spec is required now in order for this command to work correctly (at least in my case); thanks! "Dave Peterson" wrote: Specify the extension in that filename and make sure you include the fileformat:= parm in the .saveas line. And they have to be consistent, too! xp wrote: Using XL2007. In code I open a text file (csv) and format it as I want it, then the program saves the file using: ActiveWorkbook.SaveAs MyFullFileName All runs fine. But, when I try to open the file, I get an error that says the file is corrupt or has an unrecognizable file extension...what the? This is using code I've used for years in 2003 without problem. Any help would be appreciated. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Corrupt file | Excel Discussion (Misc queries) | |||
Corrupt file | Excel Discussion (Misc queries) | |||
Formula produces picture file...? | Excel Worksheet Functions | |||
Corrupt file, please help ?? | Excel Programming | |||
Corrupt File | Excel Programming |