URL Links (doc, xls) and how to open...

10 posts in this topic

nitekram 68

I am trying to open a link the same way Office applications open embedded links within the file. I want to bypass opening the link into a browser, as that is slow, and there is authenication to have to pass through. If I open the link in the office application, it simplies opens the file in what ever application it is associated to. How would I go about doing the same thing within AutoIt - I have tried using the Word UDF, but that is rather slow, and it asked me to authenicate.

I have to do nothing in the office application, except wait, and it opens in less than about 15-20 seconds.

2¢

All by me:

"Sometimes you have to go back to where you started, to get to where you want to go."

"Everybody catches up with everyone, eventually"

"As you teach others, you are really teaching yourself."

From my dad

"Do not worry about yesterday, as the only thing that you can control is tomorrow."

Ternary operator

Share this post

Link to post

Share on other sites

water 1,748

then the time is spent by Windows to access the share and fetch the document to the local PC, store it in a temporary location etc.
Can you manually copy the file to your local drive and open it using _Word_DocOpen?

Share this post

Link to post

Share on other sites

nitekram 68

That is what I would think too. Time to go out to server and retrieve the file via Word.

But the time needed to open the same documeny from a link in Outlook is quick - really quick, though it is a URL and not a path to a file. I am trying to find that kind of speed. In fact it does not even open IE, it just opens Word. I found this by accident, when I clicked on a link for an updated process. I figured it might be in either the Word UDF or the Outlook UDF, but nothing was in outlook, and only the test above for Word.

I will try this tomorrow - I will see if I can call Word with a command line and the file path, and see the length of time needed.

Edited February 12, 2015 by nitekram

2¢

All by me:

"Sometimes you have to go back to where you started, to get to where you want to go."

"Everybody catches up with everyone, eventually"

"As you teach others, you are really teaching yourself."

From my dad

"Do not worry about yesterday, as the only thing that you can control is tomorrow."