Code To Adjust With Changing Printer Location

[swordswinger710]

My code contains a line in where the name of a specified printer that needs to be used is located on Ne03. However, I've come across this several times where the Ne number will change for some reason unknown to me - in my case, it has now changed to Ne01, meaning all the workbooks that have been saved with Ne03 in the code are no longer working.

I'm looking for a workaround for this problem where the code would just take the name of the printer (which won't be changing as far as I can tell) regardless of it's ending and just print, but I'm not sure how to go about this in my case. Here is my code:

Please Login or Register  to view this content.

Any ideas here would be greatly appreciated. Thanks in advance!

[Kyle123]

This is one of my pet peeves, you don't need the printer port in Word, but you do in Excel. This is the most efficient way of doing it, put the below in a module somewhere:

Please Login or Register  to view this content.

This is then called like this:

Please Login or Register  to view this content.

[swordswinger710]

Thank you Kyle123 - I'm having a few issues getting this to work with my code - where do I put that second code in mine?

[Kyle123]

Something like this:

Please Login or Register  to view this content.

To see what the function returns without running all the code, in the immediate window type:

Please Login or Register  to view this content.

[swordswinger710]

I'm getting an error - do you have any idea what I'm doing wrong here?

Please Login or Register  to view this content.

[Kyle123]

missed the on out, try this :

Please Login or Register  to view this content.

What do you get when you run ?GetPrinterPort("Brother QL-1060N") in the imediate window?

[swordswinger710]

Hey! That seems to be doing it. And this may sound like a really dumb question - but how do I run ?GetPrinterPort("Brother QL-1060N") in the immediate window?

[Kyle123]

have you tried typing it in.....?

[swordswinger710]

Um, haha, yes I have, but where? Typing it in the VBA window and then trying to run it gives me an error.

[Kyle123]

here:
\1

[swordswinger710]

There's a window called Immediate - who would have guessed!

Okay, so trying to run that brings up the Macros window.

[JosephP]

type it in and just press enter at the end of the line to run it.

[swordswinger710]

Oh! Thank you. I get Ne03: when I do that. This is very nice, thank you so much!

[Kyle123]

Glad it's working, thanks for the feedback