Excel 2007 VBA Save As .. File Format
Posted on 2012-03-20
I hope you can help me with this.
I have various bits of VBA that manipulate data from different sources ready for upload into Access. The user needs to be able to pick up the upload file, but whatever format I save it as, Excel won't recognise it to reopen it. I've dredged the web and have tried more versions of "FileFormat:=" than you can imagine!
The code button above won't don't anything, so here's the relevant bit of code:
uploadName = Application.GetSaveAsFilename
ActiveWorkbook.SaveAs Filename:= _
uploadName, FileFormat:=56, Password:="", WriteResPassword:="", _
I'm awarding 500 points for a quick answer that works.