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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Newbie : How to rename Sheet1 to Myname

Status
Not open for further replies.
omr1119

omr1119

Programmer
Oct 7, 2003
34
0
0
PH
Hi,

How to Rename Sheet1 in Xls, change or re-name to NewSheet using Vfp6. What is the Syntax?

thanks in advance,
OMR:)
 
Sort by date Sort by votes
I think this what you are looking for.


local oExcel, oSheet
oExcel = CreateObject("Excel.Application")
oExcel.Visible = .T.
oExcel.Workbooks.Add()

oExcel.Sheets("Sheet1").Select
oExcel.Sheets("Sheet1").Name = "MySheet"

Jim Osieczonek
Delta Business Group, LLC
 
Upvote 0 Downvote
Hi Jim,

It works.....
Thanks a lot :)

OMR:)

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Mandy_crw
  • Locked
  • Question
How to get contents of notepad file? 8
2
Replies
26
Views
316
Mandy_crw
Mandy_crw
german12
  • Locked
  • Question
How to sent a search term from VFP to Foxit-Reader 5
Replies
9
Views
185
german12
german12
Mandy_crw
  • Locked
  • Question
how to pass value to first form? 5
2
Replies
34
Views
345
Mandy_crw
Mandy_crw
A_Radiolog_inFoxPro
  • Locked
  • Question
TYPE prints the output on screen how to stop that ? 2
Replies
19
Views
399
Piotr Czekalski
Piotr Czekalski
Dronner
  • Locked
  • Question
How to display photos from Visual Foxpro 6? 2
2
Replies
23
Views
366
sedenter
sedenter

Part and Inventory Search

Sponsor

Back
Top