Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Automation

Status
Not open for further replies.
BRADLEY21

BRADLEY21

Programmer
Sep 19, 2002
35
US
From VFP 8.0 I have opened an excel spreadsheet insert data and formated the sheet, all which I have done effortlessly by copying the VBA macro code in VFP and tweaking it here and there.

Now I want to save the spreadsheet with a name but can not do it I tried XLApp.WorkBooks.saveas() but I failed.

Any help would be appreciated.
 
Sort by date Sort by votes
.DisplayAlerts = .f. &&optional
.ActiveSheet.saveas("c:\MyPath\MyName")

Brian
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ravicoder
  • Locked
  • Question
excel automation printing to pdf error
Replies
8
Views
889
combo
combo
sdocker
  • Locked
  • Question
Email automation with OUTLOOKNEW
Replies
10
Views
1K
Mike Lewis
Mike Lewis
ravicoder
  • Locked
  • Question
Generating graphs using excel automation
Replies
1
Views
395
TamarGranor
TamarGranor
ravicoder
  • Locked
  • Question
Using the Union Method of excel automation
Replies
3
Views
432
Mike Lewis
Mike Lewis
igorsandler
  • Locked
  • Question
Excel automation in FoxPro 7
Replies
1
Views
460
TamarGranor
TamarGranor

Part and Inventory Search

Sponsor

Back
Top