Load Excel xlxs file to a Sheet & Cell Location

amerifax

Registered User.
Local time
Today, 05:19
Joined
Apr 9, 2007
Messages
304
I want to go to a cell on a specif work sheet in Excel 2010, 2 different ways. "Link". I will using a macro program that can load very easy.

1. Open a closed Excel "xlxs" to a specif work sheet & also a different cell
Example:
a. File PermitUpdateMst.xlsx
b. A sheet called "Master"
c. A cell location called ab200 or named "trident"

2. If the Proper work sheet is already open I want to do the same as above, go to cell location on it's Tab-Sheet. I'm sure Tab-Sheet is an improper name for the tab's on the page bottom.

Bob
 
So far I have found that using TaskBar address I can load an Excel file. Now I only need a way to load the "Sheet" and "RangeName", cell location.
Bob
 

Users who are viewing this thread

Back
Top Bottom