I used the idea from Nigel

ActiveWorkbook.SaveAs FileName:=vFileName, FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False,
_
CreateBackup:=False

and it worked GREAT -
I think it will help me alot in other worksheets as well - but now it
has brought on another issue - I worked through what I thought would
work, but it doesn't
the code actually looks like this (this is a macro I used after saving
the file with vFileName)

Workbooks.Open FileName:="C:\Temp\misc_log.xls"
Windows("Misc Shipper_43.xls").Activate
Application.Goto Reference:="R1C3"
Selection.Copy
Windows("misc_log.xls").Activate
Rows("5:5").Select
Application.CutCopyMode = False

Where the
Windows("Misc Shipper_43.xls").Activate
line is in the macro - i tried to use
Windows vFileName.Activate
vFileName in place of ("Misc Shipper_43.xls")
and I get an error Invalid qualifer
I am still looking on how to fix this - but if you have an answer I
would appricate it

Thanks again


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!