Morning All,
This is my first post so please go gently with me :blush1:.
We’re using open edge version 10.2b and I have a machine running vista.
The problem I have is as follows: -
I’m running a report via a background process that we developed in house. This report generates a load of data outputs it to excel, saves the file and then attaches to email and sends the email to the required people. Using Excel 2007 this works fine but the minute I try on it a machine using excel 2010 I have problems saving the file. I’m using the following line of code in an attempt to save the file where chrPathFile = “..\tmp\afile.xlsx”.
chWorkbook:SaveAs(chrPathFile,,,,,,).
I’ve read about the need to specify the file format in excel versions 2007 and above so have tried a combination of the following with no joy....
chWorkbook:SaveAs(chrPathFile,51,,,,,).
chWorkbook:SaveAs(chrPathFile,56,,,,,).
chWorkbook:SaveAs(chrPathFile,-4146,,,,,).
I’ve also tried naming the file “..\tmp\aFile.xls” with no joy either.
Please can somebody help me before I tear all of my hair out!!
Thanks in Advance
This is my first post so please go gently with me :blush1:.
We’re using open edge version 10.2b and I have a machine running vista.
The problem I have is as follows: -
I’m running a report via a background process that we developed in house. This report generates a load of data outputs it to excel, saves the file and then attaches to email and sends the email to the required people. Using Excel 2007 this works fine but the minute I try on it a machine using excel 2010 I have problems saving the file. I’m using the following line of code in an attempt to save the file where chrPathFile = “..\tmp\afile.xlsx”.
chWorkbook:SaveAs(chrPathFile,,,,,,).
I’ve read about the need to specify the file format in excel versions 2007 and above so have tried a combination of the following with no joy....
chWorkbook:SaveAs(chrPathFile,51,,,,,).
chWorkbook:SaveAs(chrPathFile,56,,,,,).
chWorkbook:SaveAs(chrPathFile,-4146,,,,,).
I’ve also tried naming the file “..\tmp\aFile.xls” with no joy either.
Please can somebody help me before I tear all of my hair out!!
Thanks in Advance