Follow Hyperlink question.

No. The code works fine but a would like to add some more buttons to the same sheet to open different files and I can't get them to work. The first setup is great.

I don't know if I need to do anything special, add another line somewhere, put it in a seperate modual or what. I have changed the target range in the new code but still no result except the erroe msg.

Jim O

Here are both codes that I am trying to use. The code assigned to command button 1 (cell C7) works fine, I cannot get the second code, assigned to command button 2 (cell E15), to function.

Please Login or Register  to view this content.

Anyone have any thoughts on this?

Jim O

I am still unable to get a second command button to work, only the first one works. I am a an impass. I don't even know if it is possible.

Any thoughts on this issue?

Jim O

Yes it works if I click on it without using the button but if I try the button I get a run-time error. If I click on the debugger "ThisWorkbook.FollowHyperlink strURL" is highlited.

Jim O

Does anone have any thoughts on this issue?

Jim O

I am not sure what you are asking. With the original code I set up a command button to open a specific file and it works properly. I would like to add some more buttons to open other files but I have not had any sucess. I copied the first code, and changed the references but I still have not been able to get them to work. My first question is, is this something that is even possible? It seams as though it should work but I have no idea.

If their is another way to to open files without using a hyperlink, I am interested in learning about it.

Jim O

Excel .xlsx and .xlsm . They are data files on my hard drive.

Jim O

I am still having an issue.

I copied and pasted the code, changed the button and cell references to thappropriatete value and I am still getting an error mgs. If I click on debug the "Workbooks.Open strURL" ihighlighteded in yellow. This is what I was getting with the first code. I can click on the link in the sheet with the mouse and the file opens but it wont open using a button although the original code and button work.

Jim O

Sorry for my ignorance with this but I am not sure I understand what you are saying.

All I know is that I can set up a hyperlink and it will only work if I click it with a mouse, if I assign a command button to it I get an error. However the first button I put on the sheet WILL work with a button. I have not been able to get any others to work from a command button. I have even tried to assign the first button with a different file ( that I can open with a mouse click) and I get an error msg. I am totally stumped.

Jim O

Again, what I want to do is to click on a button and have a file open. As to why I want to open them, I find it much easier to work on them if they are open.

I am just trying to understand why the code works sometime and not other times.

Jim O

did you change the target of the button to call CommandButton2_Click()?

each button should be targeted at their own macro

also, since it it is looking at a value (strURL = Worksheets("Select Customer").Range("E15").Value) the value showing has to be the correct link address and not just a label
ie. if the value showing is Invoice 2, and the link address is \\drive\folder\Invoice 2.xlsx then strURL will equal Invoice 2 not \\drive\folder\Invoice 2.xlsx

Scott,

That is the answer I was looking for. I had set up a link using a word rather than an address to the file. It would work if I clicked on the hyperlink but the code was looking for the actual address of the file.

Many thanks!

Jim O