Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: rose cruz
  Where is rose cruz?
 navotas
 Philippines
 rose cruz
 Tags
Subject: RE: Save Excel format using Foxpro.
Thread ID: 154501 Message ID: 154634 # Views: 2 # Ratings: 0
Version: Visual FoxPro 7 Category: Microsoft Office Automation
Date: Tuesday, December 18, 2007 1:32:00 PM         
   


> How can i convert this macro code using foxpro. Thanks...
>
> ActiveWorkbook.SaveAs Filename:= _
> "X:\DATAWAREHOUSE\DEVELOPMENT\Pos_Report\Sales_Per_Tender_20071101_to_20071130.xls" _
> , FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
> ReadOnlyRecommended:=False, CreateBackup:=False

#define xlNormal -4143
oExcel.ActiveWorkbook.SaveAs( ;
 "X:\DATAWAREHOUSE\DEVELOPMENT\Pos_Report\Sales_Per_Tender_20071101_to_20071130.xls", ;
 xlNormal )


PS: Other parameters could be omitted because they're at their default values. xlNormal is required if current format is not xlNormal.

Cetin Basoz

ENTIRE THREAD

Save Excel format using Foxpro. Posted by rose cruz @ 12/17/2007 11:23:19 AM
RE: Save Excel format using Foxpro. Posted by Marcia Akins @ 12/17/2007 12:42:49 PM
RE: Save Excel format using Foxpro. Posted by Cetin Basoz @ 12/18/2007 1:32:00 PM