Sending a variable Hyperlink with Macro using a filepath & active sheet

tcnt9176

Board Regular
Joined
Jun 23, 2008
Messages
223
I am basically just needing to send a hyperlink to a specific group of people each day at the end of my macro. The hyperlink would be based on the path to a network drive & the name of the file I just saved. Below is the macro line saving the file. Instead of emailing the actual spreadsheet, what do I need to add to have it simply email this link daily(each day the link changes b/c it adds the date at the end of the file name)?

"xxxxx\Inventory Manager\Regional\Detail\Inventory Manager Detail " & Range("S30") & ".xls"
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Watch MrExcel Video

Forum statistics

Threads
1,102,344
Messages
5,486,299
Members
407,538
Latest member
kbendelac

This Week's Hot Topics

Top