Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anil S
  Where is Anil S?
 delhi
 India
 Anil S
 Tags
Subject: Excel SaveAs Issue
Thread ID: 394078 Message ID: 394078 # Views: 34 # Ratings: 0
Version: Visual FoxPro 8 Category: Microsoft Office Automation
Date: Monday, December 30, 2013 2:26:45 PM         
   


Good day to all :-)

oXL = CREATEOBJECT("Excel.Application")
oXL.WorkBooks.Add
oXL.ActiveWorkBook.saveas("c:\temp.xls")
oXL.quit

In my project, The above code works fine but when I go to open temp.xls it gives following message.


But if I give file format with saveas like this
oXL = CREATEOBJECT("Excel.Application")
oXL.WorkBooks.Add
oXL.ActiveWorkBook.saveas("c:\temp.xls",56)
oXL.quit


My project stuck at saveas and do not saves file and also dont show any error. I dont know why this is happening.
The code
oXL.ActiveWorkBook.saveas("c:\temp.xls",56)

is working fine in command window.


I am using MS-Office 2010.

Thanks and Regards,
Anil

ENTIRE THREAD

Excel SaveAs Issue Posted by Anil S @ 12/30/2013 2:26:45 PM
RE: Excel SaveAs Issue Posted by Anders Altberg @ 12/30/2013 3:27:24 PM