Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Hyperlink Issues
I am having a problem using Hyperlinks within a Pre Scripted Macro.
I have successfully placed a Fixed Hyperlink in a Macro, but I need that Hyperlink to be a variable; let me explain: I have created an Excel spreadsheet as a master with the following name: US-MAS-000-08 Excel-Master With each new customer order I need to open the Excel-Master, and through a Macro I open a separate workbook named Master Sequence File 2008 and grab the next number in sequence. After I have that number I rename the Excel-Master so as to reference the customer. Here are some examples: US-MAS-001-08 Logistics Kit 10 US-MAS-002-08 Elizabeth City Kit 2 US-MAS-003-08 Elizabeth City Kit 66 US-MAS-004-08 SE OPU-HP As you can see, I have a numerical sequence from 001 thru 004 with the customers name at the end. Now, after the new US-MAS file has been created I will need to retrieve additional sequence numbers from the Master Sequence File 2008 and place them within the US-MAS from which I am working. Here is my problem. I need to open US-MAS-001-08 Logistics Kit 10, click on a Macro Button that takes me to the file Master Sequence File 2008, grads the next Invoice # (for example) in sequence, then returns me to US-MAS-001-08 Logistics Kit 10 so that I can use the new #. Each time I try to run the Macro it takes me back to the US-MAS-000-08 Excel-Master file because that is the file I used when I created the Macro. I do not know enough about VBA code to resolve my issue. Can someone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink issues | Excel Discussion (Misc queries) | |||
Hyperlink issues | Excel Discussion (Misc queries) | |||
PDF hyperlink issues | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Update links - hyperlink issues | Excel Discussion (Misc queries) |