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