| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving Excel Workbook in VB6
Hi!
My Workbook is referenced in my VB program as MyWB. I save it with MyWB.SaveAs FileName:NewName Now I want to work with NewName. The following does not work : Set MyWB = Excel.ActiveWorkbook (for some reason ActiveWorkbook is empty...) Anyone know how to reference the new Workbook ? Pat |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving Excel Workbook in VB6
This should work for u.
ActiveWorkbook.Activate MyWB = ActiveWorkbook.Name -----Original Message----- Hi! My Workbook is referenced in my VB program as MyWB. I save it with MyWB.SaveAs FileName:NewName Now I want to work with NewName. The following does not work : Set MyWB = Excel.ActiveWorkbook (for some reason ActiveWorkbook is empty...) Anyone know how to reference the new Workbook ? Pat . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving Excel workbook | Excel Discussion (Misc queries) | |||
| Saving an Excel Workbook | Excel Discussion (Misc queries) | |||
| Saving a workbook in Excel 2003 | Excel Discussion (Misc queries) | |||
| In Excel saving just a tab of a workbook | Excel Discussion (Misc queries) | |||
| Saving a Workbook: Forcing User to Rename before Saving | Excel Programming | |||
Linear Mode
