Missing printer details when recording macro

[jimfx]

Hi there,
I tried google with many different words, but I couldn't find an anwser.

I used to work with Excel 2003, and when I wanted to create a macro which will select a different printer instead of the default printer, I could easily do that by recording a macro, making a print, stop the macro and copy the details from the recorded macro (printer name, port number, etc.)

I tried the same with Excel 2010, but there are no details shown about the different printer. I only see a print command .

I hope anyone can help me. Thanks in advance.

Jim

[Kyle123]

Hi jim, not sure if 2010 is the same, but I wrote this for 2003

http://www.excelforum.com/tips-and-t...excel-vba.html

[jimfx]

Hi jim, not sure if 2010 is the same, but I wrote this for 2003

http://www.excelforum.com/tips-and-t...excel-vba.html

Thanks Kyle,
But I wonder if there is an option setting in Excel 2010 which enables recording details again when recording a macro.

Jim