PDA

View Full Version : Call function



newbie06
05-26-2006, 12:33 PM
How do I get the macros to open a workbook from a location regardless of the length of a filename as long as it follow by a /.

ex. my excel workbook can be name as c:/abc.csv or c:temp/abc.csv

lucas
05-26-2006, 12:39 PM
Sub OpenDocFile()
' ActiveWorkbook.FollowHyperlink Address:="C:\temp\help.doc", _
ActiveWorkbook.FollowHyperlink Address:="help.doc", _
NewWindow:=True
End Sub