Load Excel file-Sheet-Range

amerifax

Board Regular
Joined
Dec 17, 2008
Messages
244
I want to go to a cell on a specif work sheet in Excel 2010


Open a closed Excel "xlxs" to a specif work sheet & also Cell or Range Name

Example:
a. File PermitUpdateMst.xlsx
b. A sheet called "Master"
c. A cell location called "Grand" or cell AB200

I have been able to load the spreadsheet using the TaskBar Address Box. Problem is loading the "Sheet" and NameRange "Grand" with same action.


T:\Excel\PermitUpdateMst.xlsx Master Grand
My thought but as you might know it will produce no results.

Bob
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,225
These two lines of code should do it, based on your description:

Code:
Workbooks.Open Filename:="T:\Excel\PermitUpdateMst.xlsx"
Application.Goto worksheets("Master").Range("AB200"), 1
 

amerifax

Board Regular
Joined
Dec 17, 2008
Messages
244
That was quite simple. Thanks for your help. I would like to take my question one step further...and you may or may not know the answer. How would I do this exact thing from OneNote. I am also setting up some interoffice Help Files and would like to link to this exact location, so there are no mistakes. Do you know if this is possible and how?

Regardless, thanks so much for you help!

Bob
 

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,225
Bumping this up while replying that I would defer to people reading this who are more familiar with One Note than I am. Hopefully someone seeing this can help with that aspect of your project.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,492
Messages
5,601,994
Members
414,490
Latest member
Rip181

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top