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.

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

-----Original Message-----
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 made a typo!.. line should read:

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


keepITcool




"Frank Kabel" wrote:

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

-----Original Message-----
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.

.

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.

On Wed, 22 Sep 2004 03:04:23 -0700, "Haim"
wrote:

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.