Macro To Open a File in Excel 2003

May 29, 2013 at 11:50:00
Specs: Windows XP
I am looking to write (or record preferably) a Macro where when I click on a button I create (let's say it's named "Open") a new worksheet is opened and the Open menu screen is displayed in that worksheet. I would then search for the file that I want imported and when found and chosen it of course is brought over to my worksheet. I have zero experience writing complex Macros and again would prefer to record this as opposed to writing it.

See More: Macro To Open a File in Excel 2003

Report •

May 29, 2013 at 12:51:55
"brought over to my worksheet" how?

How To Ask Questions The Smart Way

Report •

May 29, 2013 at 12:54:50
A copy of the information (headings and all) would be imported over.

Report •

Related Solutions

Ask Question