Excel Macro VBA Tip 22 - Open Workbooks with Excel Macros

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.


Have a great day!

[excel]

Thank you. very clear speech and good way of explaining

[pandharinathjoshi]

Great sir..
If this file copy to another PC it will open or not sir

I want work only one pc sir

[wreckerray]

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

[TeachExcel]

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

[TeachExcel]

@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.

[mohammadahmed]

Sir can you provide a VBA for changing header and footer in folder having 12 files(workbooks) with one worksheet.because i do not know to create a VBA. thanks

[UrbanGuerrilla]

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

[caballero]

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...

[suprithobone]

Hi, I made an excel based aplication and I want the file can be on a dedicated computer only. Can you help for this problem, please?

[junlarr]

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

[IARislam]

hi bro, how to open protected workbook file?