<font size=2 face="Courier New">Anyone who knows how do i open a existingexcel file in VEE without create
a empty excel file by using CreateObject function first?
Thanks!
Rgs,
James Zhang </font>
---You are currently subscribed to vrf as: rsb@soco.agilent.comTo subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".To send messages to this mailing list, email "vrf@agilent.com". If you need help with the mailing list send a message to"owner-vrf@it.lists.it.agilent.com".Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
> current file.
Save() is a method of the Workbook class. If you haven't given a file name (i.e., if you didn't open the file in the first place), use SaveAs(filename) to avoid the Excel SaveAs filename dialog.
Set wbk = CreateObject("Excel.Sheet");
//Write some data.
wbk.SaveAs("MyFile.xls");
-SHAWN-
---
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".