Setting a Global Variable

So I've read quite a few things on global variables but none of it has made sense to me. I want to set a variable that works in all my modules to set the name of my printer for each macro. Here is the code that I have within each macro and I just want it in one place because it seems like whenever I restart my computer or have to unhook the printer it changes the Ne##. If anyone knows how to prevent that from happening that would be great as well. Thanks for any help.

Please Login or Register  to view this content.

If you only want to have to change it in one place you can use a constant rather than a variable:

Please Login or Register  to view this content.

You can also use a function to return the port number (the NExx bit): http://www.excelforum.com/tips-and-t...excel-vba.html

You could use a combination of the two:

Please Login or Register  to view this content.

That's true, but then all the current code has to be changed, and I'm very lazy.

The original code used printer_name as the variable though.