View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lulu[_2_] Lulu[_2_] is offline
external usenet poster
 
Posts: 2
Default 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