
In that case, you need to carefully “alter” the API calls to work in 64bit (e.g. The latter is particularly true when the Office version in which your “application” will run, is 64bit.

So, if you are not very familiar with Windows APIs, you might have trouble adjusting the API functions into your VBA code.

While this totally OK, the VB 6.0 solutions will probably rely on one or more Windows APIs. In other words, he/she might try to find solutions based on some old examples. To answer the last two questions, somebody might think to search for some old Visual Basic 6.0 code snippets. However, what if your VBA “application” needs to know how many printers are installed and available on a particular computer? What if your “application” must set the default Windows printer to “Adobe PDF”, hence, printing in a PDF file, instead of a paper? The obvious reason is that the VBA was not designed for this kind of purpose. Follow Melanie on Twitter at For the latest IT news, analysis and how-tos, follow ITworld on Twitter and Facebook.Although VBA is a great language for building Office “applications”, when it comes to handling Windows devices, such as a printer, for example, things start to become difficult. Read more of Melanie Pinola’s Tech IT Out blog and follow the latest IT news at ITworld. Windows will choose the default one for you based on your network. Now you don't have to select a different printer every time you want to print. Finally, you can use the dropdown boxes to match the printer you want to use on a specific network.Select the "Change my default printer when I change networks" option.Next, click the "Manage default printers" button in the toolbar.For your current network, right-click on the printer you want as the default and make it the default printer, if you haven't already.Head to Control Panel > Printers (or Control Panel > Hardware and Sound > Devices & Printers).If you have one of those, here's how to set up the printer settings. Note that this setting is only available in Windows 7 and 8 Premium and Enterprise versions, though.

Windows has a built-in setting for automatically switching the default printer based on the network you're connected to. If you often work at different locations-say, the office and your home office-you don't have to manually switch the default printer every time you go from one place to the other.
