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

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


.