View Single Post
 
Old 07-16-2011, 08:24 AM
xscotsmanx xscotsmanx is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Jul 2011
Posts: 1
xscotsmanx is on a distinguished road
Default Default Save AS File Name from Bookmark

Hi all,

I am fairly new to VBA but have made some userform letter precedents etc.

I save all my letters with a specific number, so for example L1234. My userform already fills a bookmark with the required letter number.

My question is can I have that letter number be the default file name when I open the save as dialogue to save the document?

If so can anyone help as to how I go about it? I have spent hours trying to figure it out.
Reply With Quote