Macro to ue url in cell

[rjplante]

I was wondering if it is possible to do a couple of things using VBA.

1) Have a macro that will access a link in a cell. I have a cell with a hyperlink to a file on a local server. Is it possible to use a macro to access that hyperlink and launch the associated file?

2) I would like to use a button 1 to launch macro A. I want macro A to display a dialogue box to search for a file and then place the hyperlink to the file selected into cell X. Then to finish Macro A, I would like it to assign macro B to button 1 (the same button used to access macro A). Macro B would be used to launch file listed in cell X. Is this transfer of macro A to macro B possible using VBA?

Thanks for any direction you can provide.

Robert

 

[texasalynn]

you can have a macro call another macro

Sub MacroA()
 
Call MacroB
End Sub
 
Sub Macro B()
' do stuff
End Sub