Saturday, November 17, 2018
Home Tags Vba

Tag: vba

How to check a Workbook Exists

This macro will provide a quick and easy way to check that a Workbook exists before you attempt to access it. This can be a problem when trying to open a Workbook from within another Workbook, or a Workbook that is required has been deleted or moved. If you try to access a Workbook that does not exist your macro will fail with the following debug message

How to print Worksheets to different Printers

The quickest and simplest way to solve this problem is by using a Visual Basic Macro. In this case we need to set specific commands to print Sheet A to one printer and then Sheet C to another printer and not printing Sheet B.

How to check a Worksheet Exists

The following simple macro will provide a quick and easy way to make sure a Worksheet exists in a Workbook before you start any changes or other processing on that worksheet. This can be a problem when working with large numbers of worksheets that are created during a macro process. If you try to create a worksheet name that already exists your macro will fail with the following debug message

LATEST

MOST VIEWED