hi guys
i dont know if this is possible but here goes.
id like a macro button to open the save as dialogue box
i would like the filename to be generated as cell B2 ( in this case Q01202 ) then "costing sheet" and then cell b4 in this case (smith)
so it would open the save as dialogue box and already have "Q01202 costing sheet - Smith" in the file name box
on top of that i would also like the destination folder to be set directly to dropbox rather than desktop or any other folder.
would appreciate your help
Bookmarks