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 Rhinorhino 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
Joined
Oct 7, 2003
Messages
34
Location
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

dylim
  • Locked
  • Question Question
How to supply filename when doing SET PRINTER TO NAME "Microsoft Print to PDF"
Replies
16
Views
1K
dylim
dylim
Filip Brnic
  • Question Question
Any idea how to deal with blank spaces?
Replies
9
Views
302
Chriss Miller
C
R
  • Question Question
How to interactively change control source of a grid at runtime?
Replies
14
Views
597
Chriss Miller
C
Steve Yu
  • Locked
  • Question Question
how to send Esc code to Epson LQ-590II for draft, courier, etc.
2
Replies
21
Views
2K
Steve Yu
Steve Yu
C
  • Locked
  • Question Question
foxpro to pdf
Replies
6
Views
1K
Chriss Miller
C

Part and Inventory Search

Sponsor

Back
Top