| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where is hyperlink pointing...File or Folder
How can I tell if the hyperlink is pointing to a file or folder??!?
Thanks in advance! ~ Matt -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where is hyperlink pointing...File or Folder
Edit the hyperlink?
Do you mean with code? -- Regards, Tom Ogilvy "BVHis " wrote in message ... How can I tell if the hyperlink is pointing to a file or folder??!? Thanks in advance! ~ Matt W --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where is hyperlink pointing...File or Folder
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where is hyperlink pointing...File or Folder
Look in help at the Dir command and the GetAttr command. See the help
example for Dir: If (GetAttr(MyPath & MyName) And vbDirectory) = vbDirectory Then -- Regards, Tom Ogilvy "BVHis " wrote in message ... Yes. TIA! ~ Matt W --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pointing lots of Excel Pivot Tables at a Different Cube file | Excel Worksheet Functions | |||
| Need code to save file to new folder, erase from old folder | Excel Discussion (Misc queries) | |||
| Excel links are pointing to the same file | Links and Linking in Excel | |||
| Create Folder and Text File in folder | Excel Programming | |||
| Have a lookup pointing to a CSV file | Excel Programming | |||
![BVHis[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
