View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.misc
Samrcat
 
Posts: n/a
Default Excel Macro - change printer

Thank you JMB. I may end up going that route!

keepITcool,
I went to that link and saw your code. I copied it into a module and
Tried it and got hung up when I tried to run the demo. Compile error.
Sub or Function not defined. This line is highlighted yellow in
debugger
Function PrinterList(Optional PrinterNr As Integer = -1)

and GetProfileString on this line is highlighted blue:
lRet = GetProfileString(sKey, vbNullString, vbNullString, sBuf,
lSize)

I was surprised to find my topic appeared under Google Groups!

My Excel skills are quite advanced and am comfortable with macros, but
these macros are way beyond my understanding for debugging and for
modifying to get the results I need. Before investigating this I
thought that I could just use wild card letters (like **, etc) in the
printer name to replace the Ne02, Ne03, etc. But that concept was
wrong. I have a reference book at home for Excel Macros that I have
used for reference many times, but this situtation is not covered that
I saw.

I have spent so much time chasing printer settings on several
computers. Having the ability to avoid all of that would be wonderful.