Closing a workbook using VBA programatically (1 Viewer)

[fulltime]

I am using VBA to open an excel spreadsheet with the comand below,

Set objBook = objExcel.Workbooks.Open(tbFile)

to close the workbook, i use

objExcel.Workbooks.Close

however, if i have 3 active windows for MS excel, it will close all 3 windows after the statement above. I onli wan MS excel to close onli the "tbFile" tat i opened. how can tat be done?

thks

FT

 

[Sergeant]

Did you try objBook.Close ???

 

[fulltime]

Did you try objBook.Close ???

thks, i found the solution.. to close onli the active work book, use activeworkbook.close..


thks