We run Excel 2003.
I have a spreadsheet that has both a hyperlink and a formatted command (the cell that is formatted looks like: “C:\Program Files\Internet Explorer\iexplore” “http://our-Intranet/LicenseEXE/lgen.dll?ID=record-identifier&USER=myuser.name@mycompany.com”). The hyperlink runs code on our intranet. I get the formatted cell’s command to work using the following steps:
1) I open a DOS window,
2) I COPY the command cell from EXCEL, then
3) back in the DOS window, I right-click to “paste” the data.
Is there any way that I can automate this process?
I receive multiple, 100-300 line items spreadsheets monthly, so this would make my life much simpler.
Also, each command opens a separate Explorer window, limiting me to selecting 5-7 cells at a time. Is there any way around this?
Thanks in advance.