ExcelBanter - Where is hyperlink pointing...File or Folder

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Where is hyperlink pointing...File or Folder (https://www.excelbanter.com/excel-programming/297062-where-hyperlink-pointing-file-folder.html)

BVHis[_5_]

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

Tom Ogilvy

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/

BVHis[_8_]

Where is hyperlink pointing...File or Folder

Yes.
TIA!

~ Matt

--
Message posted from http://www.ExcelForum.com

Tom Ogilvy

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/

All times are GMT +1. The time now is 02:39 PM.