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
 
Top