LinkBack URL
About LinkBacks
When you are useing the SaveAS dialog box, you are just getting a string for the name to save as, you would still require a saveas command
ActiveWorkbook.SaveAs Filename:=fname, FileFormat:= _ xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
When you are useing the SaveAS dialog box, you are just getting a string for the name to save as, you would still require a saveas command
ActiveWorkbook.SaveAs Filename:=fname, FileFormat:= _ xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
HI, thanks for the quick response. At the risk of looking daft I have another question, where does your code sit within the code I already have.? Thanks again.
It's OK - I've worked it out .... Works great - thanks :-D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
,
Register To Reply
Bookmarks