Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File locations becoming relative when workbook is emailed by macro
Hi,
I have a workbook which is filtered, sorted and emailed by a macro on a weekly basis. The workbook is stored on a lan, and is sent to colleagues globally, who cannot necessarily see the same local drive(s). Unfortunately, hyperlinks within the workbook default to c:\documents and settings\etc..., when received by my colleagues. This has only started happening over the last couple of weeks. Previously, local users were able to launch the hyperlink, which pointed to the local (e.g. K:) drive. I have reviewed the current code verses the previous, and cannot find any changes, and have even copied the old, working, code into my current macro, but to no avail. Only users within my local lan environment need to be able to launch the hyperlinks. Any suggestions will be gratefully received! Sam |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
File locations becoming relative when workbook is emailed by macro
How are the links created? Within the macro that filters, sorts and emails
the workbook? Or some other way, such as via a formula? "Sam" wrote: Hi, I have a workbook which is filtered, sorted and emailed by a macro on a weekly basis. The workbook is stored on a lan, and is sent to colleagues globally, who cannot necessarily see the same local drive(s). Unfortunately, hyperlinks within the workbook default to c:\documents and settings\etc..., when received by my colleagues. This has only started happening over the last couple of weeks. Previously, local users were able to launch the hyperlink, which pointed to the local (e.g. K:) drive. I have reviewed the current code verses the previous, and cannot find any changes, and have even copied the old, working, code into my current macro, but to no avail. Only users within my local lan environment need to be able to launch the hyperlinks. Any suggestions will be gratefully received! Sam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I email amacro? | Excel Worksheet Functions | |||
mail merging 2 workbooks??? | Excel Discussion (Misc queries) | |||
Using a macro to create a macro in another workbook | Excel Worksheet Functions | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |