I had done copy sheet content to word, after paste, I would like "save as" is prompted, so I can enter doc name and save it. I tried:
- Application.GetSaveAsFilename, it pop up, enter a file name, eventually doesn't save anything, and I don't know it save excel file or word file.
- ActiveDocument.SaveAs2 ("D:\Users\ushlia\Desktop\doc1"): I don't want create a file name in VBA, I just want "save as" pops up, so I can enter a name
Any suggestion? Thanks!
Bookmarks