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
.