Hello,
I have a VBA macro in my excel file that is opening up a file on a shared drive, making some daily changes, and then saving it and closing. Later, a perl script picks up these changes and makes a table in an email and sends it to some people.
This all used to work fine until I upgraded to Excel 2010. Now, for some reason, the table is having trouble being created correctly in the perl script. I went back to my 2003 version of excel and it works fine but whenever 2010 makes the changes and saves, it doesn't work. I'm saving as a .csv.
I thought it was a file version issue and tried the FileFormat:=56 and even tried :=6 (saw that csv might be that) but both don't work. Does anyone know of anything that could be causing the issue? Or maybe I have the wrong addition to the save? Here is how I'm writing it:
ActiveWorkbook.SaveAs , FileFormatNum:=56
I also tried writing it out long ways as a save as.
Any help would be appreciated. Thanks!
I have a VBA macro in my excel file that is opening up a file on a shared drive, making some daily changes, and then saving it and closing. Later, a perl script picks up these changes and makes a table in an email and sends it to some people.
This all used to work fine until I upgraded to Excel 2010. Now, for some reason, the table is having trouble being created correctly in the perl script. I went back to my 2003 version of excel and it works fine but whenever 2010 makes the changes and saves, it doesn't work. I'm saving as a .csv.
I thought it was a file version issue and tried the FileFormat:=56 and even tried :=6 (saw that csv might be that) but both don't work. Does anyone know of anything that could be causing the issue? Or maybe I have the wrong addition to the save? Here is how I'm writing it:
ActiveWorkbook.SaveAs , FileFormatNum:=56
I also tried writing it out long ways as a save as.
Any help would be appreciated. Thanks!
