Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to open a normal Folder (Not a file) in VBA
for browsing files from a path contructed from an array. If I put path in a cell as a hyperlink I can click on it and the folder will open. If I try to open the folder fron a macro I get errors. I've tried: Worksheets("SheetName").Range("A2").Hyperlink.Foll ow NewWindow:=True I get: Object doesn't support this property or method What I am trying to do, is allow a user to open a folder based on a subject, direct them to the appropriate folder that contains files pertaining to the subject and allow them to choose the document they wish. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Workbooks opening in browser window | Excel Discussion (Misc queries) | |||
Error opening a CSV from Web Browser after changing Region | Excel Discussion (Misc queries) | |||
HTML HREF Opening in Browser | Excel Programming | |||
Opening browser window | Excel Programming | |||
runtime error 1004 when opening excel file via VBA in a browser | Excel Programming |