DigitalDan
05-15-2008, 06:33 PM
I've been using excel for years and have a decent understanding of it, but am just starting to pick up and learn the beginnings of VBA.
I need to take Cell A1 contents which is a number and hyperlink it to another workbook and the column/row specified in A2. I have a formula to come up with the text equivalent of the Column/Row letter&number that it needs to go to at the final destination.
For instance if Cell A1 has "100" in it and A2 has text of "B5" I need to:
1) Provide a hyperlink in a cell to "c:\100.xls". (Each tab in the destination file will be the same as the filename. So file 100.xls will have a single tab worksheet named 100.
2) But in the macro I need to make sure that the current file that the user is in is SAVED and then hyperlink out of it to the new destination file based on A1's contents.
(The user needs to bounce around from spreadsheet to spreadsheet, so they would basically type the destination filename # in A1, and I can make it where they Hit an Icon next to it and trigger the macro)
3) Once there, Position the cursor at the column/row specified in Cell A2, which is really actually referring to that of Column/Row B5. <If too much trouble, ignore this>
I don't want to have additional windows continually opening everytime the user jumps from workbook to workbook. I would like it to close the current window (or however), and just open up the new excel file each time.
I would be so grateful for a solution, and I look forward to learning more of VBA each day I can. Thanks!
I need to take Cell A1 contents which is a number and hyperlink it to another workbook and the column/row specified in A2. I have a formula to come up with the text equivalent of the Column/Row letter&number that it needs to go to at the final destination.
For instance if Cell A1 has "100" in it and A2 has text of "B5" I need to:
1) Provide a hyperlink in a cell to "c:\100.xls". (Each tab in the destination file will be the same as the filename. So file 100.xls will have a single tab worksheet named 100.
2) But in the macro I need to make sure that the current file that the user is in is SAVED and then hyperlink out of it to the new destination file based on A1's contents.
(The user needs to bounce around from spreadsheet to spreadsheet, so they would basically type the destination filename # in A1, and I can make it where they Hit an Icon next to it and trigger the macro)
3) Once there, Position the cursor at the column/row specified in Cell A2, which is really actually referring to that of Column/Row B5. <If too much trouble, ignore this>
I don't want to have additional windows continually opening everytime the user jumps from workbook to workbook. I would like it to close the current window (or however), and just open up the new excel file each time.
I would be so grateful for a solution, and I look forward to learning more of VBA each day I can. Thanks!