Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel workbooks.
Message
From
25/05/2005 07:47:53
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01017440
Message ID:
01017452
Views:
30
>>>>How does one give a meaningful name to a workbook via automation?
>>>
>>>
oSheet.Name = "New Sheet Name"
>>
>>The workbook, Sergey - not the individual sheets. I've got that one done ;-)
>
>Sorry, I wasn't sure
oWorkbook.SaveAs("H:\temp\New Workbook Name")
Okeedokee, that saves it. But I ain't ready yet!

Intellisense gives me an ActiveWorkbook.Name property that all attempts by me to use result in errors. Yet in all my bungling, the property does get set somehow, and the WB name is displayed. Just looking for the correct syntax to set that property?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform