Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: Anil S
  Where is Anil S?
 delhi
 India
 Anil S
 Tags
Subject: RE: Excel SaveAs Issue
Thread ID: 394078 Message ID: 394086 # Views: 45 # Ratings: 2
Version: Visual FoxPro 8 Category: Microsoft Office Automation
Date: Monday, December 30, 2013 3:27:24 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

The default extensions for Excel 2010 (v 14) are

xlsx – Excel workbook
xlsm – Excel macro-enabled workbook; same as xlsx but may contain macros and scripts
xltx – Excel template
xltm – Excel macro-enabled template; same as xltx but may contain macros and scripts

-Anders

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