View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Holger Hasenmüller Holger Hasenmüller is offline
external usenet poster
 
Posts: 6
Default Problem with this VBA Code and Network Printers (UNC Path)

Hi Mats,

OK, i have done it like you write, but in VB Editor the "Microsoft Office
11.0 Object Library" was checked. Also the "Microsoft Excel 11.0 Object
Library" was checked. So i scrolled down and found a "Microsoft Word 11.0
Object Library", which was unchecked.
I checked that also on.

Now i run my first test. I'm waiting, and waiting, and waiting ... and than
i get an messagebox output. I saw that you write "Key:="Adobe PDF")", so i
changed it to "Key:="\\srv01.abc.local\ADOBE-PDF")
But if i run that, i get an Error Message: Runtime Error 462 - The
remote-server-computer does not exist or is not available

After that i run the Script with F8.

After "strAdobePrt = System.PrivateProfileString(Filename:="", _
Section:=strSection, Key:="\\srv01.abc.local\ADOBE-PDF")"
i get the error ;-(

And now ???

The winword.exe process is always running, but that is OK, because the
script does not run to the end.

Kind regards

Holger