MACRO Help, how to prompt for printer?

J

Jason

Hello,
Ok, I'm playing w/ Macros's. I need to figure out how
to prompt for which printer to use. I tried replicating
the code for prompting for filename, but no dice. Does
anyone know how? TIA

Code I am using to prompt for filename if it helps:

Do
fName = Application.GetSaveAsFilename
Loop Until fName <> False
ActiveSheet.SaveAs Filename:=fName
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

xltm saveas xlsm 6
Save all sheets in a new workbook 7
Need help modifying code 0
Troubleshooting macro to save in Compatability Mode 2
Macro to select and delete levels of a document 2
VBA word change keys 0
Code does as instructed, but creates and saves a Book1 2
getsaveasfilename loop... <> false and not already exists 2

Top