Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
to close a workbook via VBA
I need to know the code to close a workbook which was opened on XL2003 with
the code line below Workbooks.Open(strFileName1, Editable:=True).RunAutoMacros Which:=xlAutoOpen TIA J_J |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
to close a workbook via VBA
Hopefully, XL will give you the necessary code with the procedure
below... Open a workbook. Create a new workbook. Turn on the macro recorder (Tools | Macro Record new macro...). Switch to the first workbook. Close it. Turn off the macro recorder. Switch to the VBE. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I need to know the code to close a workbook which was opened on XL2003 with the code line below Workbooks.Open(strFileName1, Editable:=True).RunAutoMacros Which:=xlAutoOpen TIA J_J |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
to close a workbook via VBA
Thanks Tushar,
Now why didn't I think of that !. Sincerely J_J "Tushar Mehta" wrote in message ... Hopefully, XL will give you the necessary code with the procedure below... Open a workbook. Create a new workbook. Turn on the macro recorder (Tools | Macro Record new macro...). Switch to the first workbook. Close it. Turn off the macro recorder. Switch to the VBE. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I need to know the code to close a workbook which was opened on XL2003 with the code line below Workbooks.Open(strFileName1, Editable:=True).RunAutoMacros Which:=xlAutoOpen TIA J_J |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
to close a workbook via VBA
You are welcome and, hey, we all have those days! :)
-- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Thanks Tushar, Now why didn't I think of that !. Sincerely J_J {snip} |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
workbook before close | Excel Discussion (Misc queries) | |||
close only one workbook | New Users to Excel | |||
Close a the current workbook and load another specified workbook | Excel Programming | |||
How can I close a workbook using VBA? | Excel Programming | |||
cannot close workbook | Excel Programming |