On 6 Giu, 22:07, DKS wrote:
Hi R,

Thanks for this routine. *Works fine for pdf file. *Nevertheless for ..xls
and .doc I am getting similar error, the system asks me to confirm if I want
to open or save or cancel. *Any way to get around?

For example: here is an excel file urlhttp://www.exinfm.com/excel%20files/Balanced_Scorecard_Templates.xls

Many thanks in anticipation.

Hi all.
If IE is on, try to open file directly;

Public Sub prova()
Workbooks.Open "http://www.exinfm.com/excel%20files/
Balanced_Scorecard_Templates.xls"
End Sub

Regards
Eliano