ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Easiest way...use shortcuts and internet explorer (https://www.excelbanter.com/excel-programming/443484-easiest-way-use-shortcuts-internet-explorer.html)

Bert Van Valckenborgh

Easiest way...use shortcuts and internet explorer
 
Hi,
the solution with the shortcut works great when you're using it in an internet browser. I used it in Sharepoint and reporting services too.
Offcourse when people export the reports to excel, I got the same effort.
My solution?
I create a shortcut to internet explorer and I put as parameter the shortcut to the template of word.

Something like this:
...<server adrres\SHORTCUTS\Launch_IE_With_Template.lnk

The command to launch the IE looks like this:
"<path IE\IEXPLORE.EXE" "<network path\SHORTCUTS\ShortcutToTemplate.lnk"

And this finally works in my report as well as in the exported excel.

greetz 2 @ll

Submitted via EggHeadCafe - Software Developer Portal of Choice
Custom Favorites Web Site with MongoDb and NoRM
http://www.eggheadcafe.com/tutorials...-and-norm.aspx

Bert Van Valckenborgh

something got lost
 
The command to launch the IE with the lnk as parameter seemed to got lost in my last post:

"[path IE]\IEXPLORE.EXE" "[Path Shortcut]shortcutWordTemplate.lnk"

Greetz again

Submitted via EggHeadCafe - Software Developer Portal of Choice
Changing WCF Service Implementation at Runtime
http://www.eggheadcafe.com/tutorials...t-runtime.aspx

Bert Van Valckenborgh

last try
 
"<Internet browers executable" "<shortcuth pathShortcutTemplate.lnk"

I hope this works,


Submitted via EggHeadCafe - Software Developer Portal of Choice
A Comparison of Managed Compression Algorithms
http://www.eggheadcafe.com/tutorials...lgorithms.aspx


All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com