What are ....

[Haim]

Hi,

What are the Visual Basic commands for:

1. Open Excel file called "abc"

2. Save the "abc" Excel file

3. Exit from the "abc" Excel file


Thank you,

Haim.

 

[Frank Kabel]

Hi
try:
dim wbk as workbook
set wbk = workbooks.open "C:\temp\abc.xls"
'do something with wbk
wbk.save
wbk.close

 

[keepITcool]

frank made a typo!.. line should read:

set wkb = workbooks.open("C:\temp\abc.xls")


keepITcool

 

[Myrna Larson]

A quicker way to find out is to turn on the macro recorder and do it manually,
then look at the code the recorder produced.