ruler
02-09-2007, 05:49 AM
Hi,
The macro works but when I replace argument with formula it fails. How is this formula's correct syntax in macro?
'<< Open Folder >>
Sub OpenWindowsExplorer()
ActiveWorkbook.FollowHyperlink "F:\dm_06", NewWindow:=True
Exit Sub
End Sub
Above works.
When I replace "F:\dm_06" with =+HYPERLINK(+VLOOKUP(F7,mytable,2)) or with +VLOOKUP(F7,mytable,2), macro fails with function not supported message.
+VLOOKUP(F7,mytable,2) look up result is text F:\dm_06
Is it even possible, that such formula works in macro?
I have spent many hours with this task alreadyy :-(
Thanks for any help.
The macro works but when I replace argument with formula it fails. How is this formula's correct syntax in macro?
'<< Open Folder >>
Sub OpenWindowsExplorer()
ActiveWorkbook.FollowHyperlink "F:\dm_06", NewWindow:=True
Exit Sub
End Sub
Above works.
When I replace "F:\dm_06" with =+HYPERLINK(+VLOOKUP(F7,mytable,2)) or with +VLOOKUP(F7,mytable,2), macro fails with function not supported message.
+VLOOKUP(F7,mytable,2) look up result is text F:\dm_06
Is it even possible, that such formula works in macro?
I have spent many hours with this task alreadyy :-(
Thanks for any help.