Load Excel file-Sheet-Range

[amerifax]

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

 

[Tom Urtis]

These two lines of code should do it, based on your description:

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

 

[amerifax]

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]

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.