Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
message box | Excel Discussion (Misc queries) | |||
#N/A Message | Excel Discussion (Misc queries) | |||
#N/A Message | Excel Discussion (Misc queries) | |||
changing the message in an error message | Excel Worksheet Functions | |||
Displaying a message in a message box without requiring user to click anything to proceed | Excel Programming |