Damn! Just realised I'm still in the Access forum, not the Excel forum. I wish I knew how to move it!!!
I do hope so, and that some kind person will help me out here.
I've got a VBA sub-routine that gathers up a number of worksheets in the current workbook, opens a new workbook and chucks those worksheets into it, and I'm happy up to this point... so I now have an open workbook (called book1 by Excel until told otherwise) I want to save this new workbook under a filename made up of the contents of two cells in the original workbook and then pop up a SaveAs browse window with that new filename appearing as the filename allowing me to browse to where I'd like to place this nice newly named workbook.
Now I have this:
sNewfilenameFirst = Worksheets("LinkOut").Range("B1")
sNewfilenameSecond = Worksheets("LinkOut").Range("B3")
.
.
.
.
sNewWorkbook = Application.DefaultFilePath & "\" & sNewfilenameFirst & "-" & sNewfilenameSecond & ".xls"
ThisWorkbook.SaveCopyAs Filename:=sNewWorkbook
But I've decidied I don't want to use the default pathname now, I'd like to leave that decision to the user. My problem is, I don't know how to bring up a browse window with the filename filled in LOL.
Help
Thanks
Bookmarks