View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_4_] Dick Kusleika[_4_] is offline
external usenet poster
 
Posts: 595
Default Problem with this VBA Code and Network Printers (UNC Path)

On Fri, 11 Apr 2008 14:48:18 +0200, "Holger Hasenmüller"
wrote:


Dim objReg As RegObj.Registry
Dim objRootKey As RegObj.RegKey

in English:
failure at compilation
user defined type is not defined

What's wrong here ?


You need to set a reference to Registration Manipulation Classes (Tools -
References). Or use CreateObject("RegObj.Registry") and dim those variables
as Object.
--
Dick