Outlook's Item.SaveAs path,olMsg requires a fully qualified path.
How can I let the user choose the folder path?
I'll take any solution, but the ideal solution would allow the user to suggest a folder and filename, but allow the vba program to enforce certain file naming conventions.
Something like Excel's GetSaveAsFileName would be ideal the problem.
I thought this would be simple, but a half hour of googling convinced me otherwise.
P.S. I even tried
set xls = createobject("Excel.Applic
targetname = xls.getsaveasfilename
But, the xls navigation dialog seems to get "buried" under Outlook where noone can see it. I could problably make it pop to the top with various tricks but I think I would end up regretting that.
Also, I found 'BrowseFolder' code at http://www.cpearson.com/excel/browsefolder.aspx
but I really want to have an initalfolder option which that subroutine does not seem to have.