Excel Macro VBA Tip 22 - Open Workbooks with Excel Macros

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

This Excel video tutorial shows you how to create or write a macro that will open another workbook on your computer. You will learn how to use this macro to open a single workbook on your computer as well as multiple workbooks on your computer.

The method talked about here to open the workbooks can do a lot of really cool things to the just opened workbook. However, this tutorial serves as an introduction to this method and will show you only how to open other workbooks from a macro in Excel. Other tutorials will show you how to use the more complicated and powerful features.

For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• microsoft excel 2007
• excel tips
• excel tricks
• excel guides
• excel tutorials
• excel help
• excel teacher
• spreadsheets
• worksheets
• workbooks
• vba
• macros
• excel macros
• visual basic
• write a macro
• learn macros
• open workbooks
• macro to open workbook

[UrbanGuerrilla187]

Is there a Marco to open up a worksheet (within the same workbook) rather than a workbook,

sorry if you already have a tutorial on it its just there so many

[ExcelisHell]

@UrbanGuerrilla187 Yea no problem. You can open, go to, or create a new worksheet with a macro. I don't have a tutorial for that currently but you might find something if you search on google.

[excel201013]

Thank you. very clear speech and good way of explaining

[ExcelisHell]

@excel201013 Thanks :) I'll add some more macro tutorials soon!

[wreckerray]

liked it a lot i need to open a list of files stil trying to figure it out

[caballero4321]

HI I need to learn how to use ADO variable to retrive data from a Server to excel, do you have a tutorial for it?

Thank you in advance...

[junlarr]

HOW ABOUT OPENING A WORKBOOK AND A SPECIFIC SHEET LIKE SHEET 3