Open All Workbooks in a Folder
Sometimes you may need to go into your folder, open each workbook, edit, save it, close the workbook, and then open the […]
Save and Close All Workbooks at Once
Sometimes you may need to save and close many workbooks at once. For each workbook you have opened, you need to activate […]
Refresh All Data Connections on Workbook Open
Your workbook may have connections to external data sources such as web queries, MSQuery connections, PivotTable connections, and so on. In these […]
Determine If a File Exists in a Directory
Sometimes you may need to determine if a file exists in a directory. For instance, the purpose of your macro may be […]
Determine If a Excel Workbook is Already Open
The last macro automatically opened a specific workbook chosen by the user's selection. As we consider automatically opening workbooks, you must think […]
Opening a Specific Workbook Chosen by the user
Sometimes you need to allow your users a rapid way to open a Excel Workbook? This macro opens a friendly dialog box, […]
Open a Workbook to a Specific Sheet
Sometimes you need to open your workbook be started on a specific worksheet. With this macro, if a user is working with […]
Unprotect a Worksheet on Workbook Open
Sometimes you need to unprotect the worksheets in a workbook before continuing your work. If you find that you’re constantly unprotecting worksheets, […]