Musiclover
New Member
- Joined
- Jun 6, 2020
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
Morning all, hope someone can put me out of my misery.
I have many hyperlink calculations on an excel sheet that link to an external hard drive.
Example: in cell H134 =HYPERLINK("F:\Our Music\"& B134&"\"&C134&"\"&F134&".mp3") where B134 is a band name, C134 is the CD and F134 is the track name.
When I click on it it works fine (although there is a vert annoying harmful file warning) and opens the mp3 file in vlc which is exactly what I want.
Is there a way of opening multiple links at the same time using VBA. I have searched the internet and found a few options but none of them work. Ideally picking the files from various points as opposed to a range, although a range is better than one at a time.various
Thanks for any help you can offer
I have many hyperlink calculations on an excel sheet that link to an external hard drive.
Example: in cell H134 =HYPERLINK("F:\Our Music\"& B134&"\"&C134&"\"&F134&".mp3") where B134 is a band name, C134 is the CD and F134 is the track name.
When I click on it it works fine (although there is a vert annoying harmful file warning) and opens the mp3 file in vlc which is exactly what I want.
Is there a way of opening multiple links at the same time using VBA. I have searched the internet and found a few options but none of them work. Ideally picking the files from various points as opposed to a range, although a range is better than one at a time.various
Thanks for any help you can offer