Forum Discussion
googleid_104060
13 years agoOccasional Contributor
Hi Helen,
Thanks for your reply.
Yes I have installed Excel in my system.
I will tell you the whole procedure...
My script will generate the excel report in my application.. and should save that report in specified path.
once excel report is generated..
Here is the script...
Thanks for your reply.
Yes I have installed Excel in my system.
I will tell you the whole procedure...
My script will generate the excel report in my application.. and should save that report in specified path.
once excel report is generated..
Here is the script...
Set objFSO = CreateObject("Scripting.FileSystemObject")
If objFSO.FileExists(NewReport) Then
objFSO.DeleteFile(NewReport)
End If
Set msExcel_Report = GetObject(,"Excel.Application")
msExcel_Report.Visible = "True"
msExcel_Report.ActiveWorkBook.SaveAs(NewReport)
For the last line I am getting error. After msExcel_Report.Visible = "True"a closed excel(excel without even empty sheet) sheet is opening, this is the one I am getting difference from other OSs.
Regards,
Rama