Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File URL Path
I need help on how to get the URL path for an active file that is stored in
an eRoom. I'm trying to generate a link to the file to include in an email. When I use the Visual Basic command ActiveWorkbook.Path I get C:\...\ApplicationData\eRoom\eRoomClient... What I want is https://e6.xxx.com/eRoom/extranet4/xxxx/0_1ab23 like you get when you right click the file on the eRoom page. Any ideas ? -- Thanks, Nancy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File URL Path
Hi Nancy;
Go into the VBA Editor into help. Search for the FollowHyperLink reserve word. It will give you an example of how to accomplish the URL. I hope it helps "NancyG" wrote: I need help on how to get the URL path for an active file that is stored in an eRoom. I'm trying to generate a link to the file to include in an email. When I use the Visual Basic command ActiveWorkbook.Path I get C:\...\ApplicationData\eRoom\eRoomClient... What I want is https://e6.xxx.com/eRoom/extranet4/xxxx/0_1ab23 like you get when you right click the file on the eRoom page. Any ideas ? -- Thanks, Nancy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File URL Path
The FollowHyperlink commands assume you already know the URL path. I'm
looking for a way to identify the path - all files are not necessarily residing on the same eRoom page -- Thanks, Nancy "DownThePaint" wrote: Hi Nancy; Go into the VBA Editor into help. Search for the FollowHyperLink reserve word. It will give you an example of how to accomplish the URL. I hope it helps "NancyG" wrote: I need help on how to get the URL path for an active file that is stored in an eRoom. I'm trying to generate a link to the file to include in an email. When I use the Visual Basic command ActiveWorkbook.Path I get C:\...\ApplicationData\eRoom\eRoomClient... What I want is https://e6.xxx.com/eRoom/extranet4/xxxx/0_1ab23 like you get when you right click the file on the eRoom page. Any ideas ? -- Thanks, Nancy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Path Too Long? Not Anymore! Check out Long Path Tool | Excel Discussion (Misc queries) | |||
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
Creating Excel file that points to relative path .cub file | Excel Programming | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
How set file open path to filepath of file opened with Explorer ? | Excel Programming |