What does this message mean?
When user clicks button new file is created using
Do
fname = Application.GetSaveAsFilename
Loop Until fname < False
newbook.SaveAs Filename:=fname & "xls",
FileFormat:=xlNormal
Then top sheet of users file is copied to the new file
Sheets("Status Change").Copy Befo=Workbooks(fname
& "xls").Sheets(1)
this works fine.
But the I use
Workbooks(myfile & "xls").Save
and I get this message:
Save 'MyFile.xls'with references to unsaved documents?
what does this mean?
Thanks
|