Open From HTML - Environment Variables

slink9

New Member
Joined
Feb 16, 2007
Messages
13
I solved my pervious request of being able to pass in variables from an HTML command, or at least I thought I did - use environment variables.
The environment variable is set in my web page and it shows with my SET command prompt but it is not seen by the loaded Excel sheet. It appears that the newest environment variables are not seen by the newly opened sheet. If I open the sheet normally it will iterate through the environment and find the variable. Any suggestions how to affect the environment seen by a new Excel sheet opened from a web page with a hyperlink beginning with "FILE\\"?
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,099,622
Messages
5,469,758
Members
406,668
Latest member
ElizaR

This Week's Hot Topics

Top