Xdoc As Domdocument Windows 10

Popular Posts

• 

  Now, on Windows 10 (using Office 2007), I get a Compile Error: User-defined type not defined. I checked my references, same. Lg r40 laptop driver for mac. Not in front of Excel, and not an expert at VBA, and not familiar with Windows 10, but - two immediate thoughts are: the object name changed, or the.dll that defines these objects isn\'t present. The latter is much more likely as ServerXMLHTTP has been around since the Windows Vista days. First, check for the presence of msxml2.dll on your system.

  wilkisa

  Well-known Member

  Many of our users have been getting errors in Excel with macros that worked perfectly fine in all older version of Excel. Now that they are using Windows 10 and Excel 2016, the \'user-defined type not defined\' error comes up each time it hits a UDF statement. It is as follows:
  
  Can someone please help me modify these UDFs so they will work in Excel 2016? I\'m sure we need to change some of the statements but don\'t know what to change. The references turned on for these documents are:
  Visual Basic for Applications
  Microsoft Excel 16.0 Object Library
  OLE Automation
  Microsoft Forms 2.0 Object Library
  Microsoft Office 16.0 Object Library
  Microsoft XML, v6.0
  Any guidance you can give will be very gratefully appreciated
  
  ...'>Xdoc As Domdocument Windows 10(14.04.2020)
• 

  Now, on Windows 10 (using Office 2007), I get a Compile Error: User-defined type not defined. I checked my references, same. Lg r40 laptop driver for mac. Not in front of Excel, and not an expert at VBA, and not familiar with Windows 10, but - two immediate thoughts are: the object name changed, or the.dll that defines these objects isn\'t present. The latter is much more likely as ServerXMLHTTP has been around since the Windows Vista days. First, check for the presence of msxml2.dll on your system.

  wilkisa

  Well-known Member

  Many of our users have been getting errors in Excel with macros that worked perfectly fine in all older version of Excel. Now that they are using Windows 10 and Excel 2016, the \'user-defined type not defined\' error comes up each time it hits a UDF statement. It is as follows:
  
  Can someone please help me modify these UDFs so they will work in Excel 2016? I\'m sure we need to change some of the statements but don\'t know what to change. The references turned on for these documents are:
  Visual Basic for Applications
  Microsoft Excel 16.0 Object Library
  OLE Automation
  Microsoft Forms 2.0 Object Library
  Microsoft Office 16.0 Object Library
  Microsoft XML, v6.0
  Any guidance you can give will be very gratefully appreciated
  
  ...'>Xdoc As Domdocument Windows 10(14.04.2020)