Pass referring link

Jesse

New member
Joined
Mar 22, 2011
Messages
51
Reaction score
0
Points
0
Anyone know of a way to capture the link a sheet comes from? Ie click a link to open an excel file and the sheet knows the url of the page that called the file? I'm building a template for projects, the task list publishes RSS so rather than save a file with all the details if I can capture the url that the sheet was linked from I can populate the sheet dynamically.

Jesse
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,520
Reaction score
5
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Interesting question... can't say that I do. I'd be surprised if Excel captured that information though as the process of opening Excel was shelled out to the OS to do, right?
 

Jesse

New member
Joined
Mar 22, 2011
Messages
51
Reaction score
0
Points
0
Exactly. I could code the website to make a cookie but then I'd have to instance the default browser, could be tricky.
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,520
Reaction score
5
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Right, and even with that, if they happen to not be working in their default browser then it may not be exact.

Do they always come from the same domain? Would it be possible to check all active browser windows and parse the addresses to see which match your top level domain? I guess that would only work if the user wasn't running multiple tabs though...
 

maninweb

New member
Joined
Mar 22, 2011
Messages
88
Reaction score
0
Points
0
Location
Germany
Website
excel-translator.de
Excel Version(s)
2010, 2016, 2016 Insider
Hi...

very interesting problem, making me curious; I have some additional questions...

Is it always the same Excel file which is being downloaded?
Can you run PHP scripts on your server or scripts in another language?
Is it possible, for example, to rename the workbook similar to the URL or putting an ID in its name for matching the ID later with a list of URL's?

Regards :)
 

Jesse

New member
Joined
Mar 22, 2011
Messages
51
Reaction score
0
Points
0
Ken, they always come from the same domain, it would be an internal site so I have pretty free access to do whatever I wish. I suppose what I could do would be set a variable server side when you click and then have the excel file pull and clear the flag.

Maninweb, I want to use one file that generates when you open it. I can run PHP or just about anything really. I don't want to change the filename, I want it to stay static.

Jesse
 
Top