I've come accross a seeming odity with printing/opening files from a
browser window. If I go and select properties and make sure the
"opens with" setting is correct (including "always use the selected
program for this kind of file" box is checked) I end up with the file
opening in the correct application (in this case a png file with
Acrobat) when I double-click on it.
However, if I right click and try to use the open or print command, it
goes back to the original default program (MS Photo Editor) and
fails. I don't get it.
(I'm in Windows XP)
Note that when I go to select the "Opens with" app & check box, even
though Acrobat is already the selected App, the app that appears in
grey (selected?) in the list is always the Photo Editor...
I have also tried all this from the Tools->Folder Options-> File Types
menu. Same result.

The reason this is important to me is that I'm trying to use vba
script in Excel to print a bunch of image files (in cells as
hyperlinks) which may be jpg, pdf, png etc. I don't know in advance.
I wanted to set my default app for all image files to Acrobat and
print. But its getting stuck at png every time. In vba, I'm using
ShellExecute.

Any ideas?
Thanks!

"Anne Rensonnet" <pickanything******.com> wrote in message
news:2dda4184-aed7-4791-9857-b576bc50a35a@j22g2000hsf.googlegroups.com...
>
> I've come accross a seeming odity with printing/opening files from a
> browser window. If I go and select properties and make sure the
> "opens with" setting is correct (including "always use the selected
> program for this kind of file" box is checked) I end up with the file
> opening in the correct application (in this case a png file with
> Acrobat) when I double-click on it.
> However, if I right click and try to use the open or print command, it
> goes back to the original default program (MS Photo Editor) and
> fails. I don't get it.
> (I'm in Windows XP)
> Note that when I go to select the "Opens with" app & check box, even
> though Acrobat is already the selected App, the app that appears in
> grey (selected?) in the list is always the Photo Editor...
> I have also tried all this from the Tools->Folder Options-> File Types
> menu. Same result.
>
> The reason this is important to me is that I'm trying to use vba
> script in Excel to print a bunch of image files (in cells as
> hyperlinks) which may be jpg, pdf, png etc. I don't know in advance.
> I wanted to set my default app for all image files to Acrobat and
> print. But its getting stuck at png every time. In vba, I'm using
> ShellExecute.
>

This is because the print properties of the file are separately defined.

If you go to the tools menu at the top of your open folder, and select
"Folder Options", a dialogue box opens. Select the "File Types" tab. Now
highlight your file type in the "Registered File Types" and then click the
"Advanced" button. From here you can edit the print properties.