VB6: Closing a single workbook while leaving the rest open
The following code:
Set SourceData = Workbooks.Open(FileName:="source.xls", UpdateLinks:=0)
Set Quarterly = Workbooks.Open(FileName:="Triangles.xls", UpdateLinks:=0)
' operations
SourceData.close
Closes both workbooks and excel itself. Doing
workbooks("source.xls").close
has the same effect. How can I close the source.xls while leaving the other
workbook open?
Thanks
--
Erik Bause/Bause Associates
Check out THE THREE 4 TENS at http://www.*-*-*.com/
