macros

[fastbuck]

Hi, I just bought a new laptop with excel 2013 on it. I'm trying to run my spreadsheets with macros on them but an error keeps coming up. Compile error. User-defined type not defined. Can anyone help. Thanks Narelle

 

[MARK858]

In the VBE look under Tools - Refefences and see if any are showing as missing. Uncheck the checkboxes if they do.

Other than that post the code.

 

[fastbuck]

Thanks for your reply. I created the spreadsheet and macros on my old computer with excel 2007. It worked fine. It has a number of macros some have a command to retrieve information from a web site. It’s those macros that don’t work. The ones that don’t need to retrieve the data work fine. I’m a real novice at this sort of stuff. The first line below is the one that the macro seems to get stuck on. Many thanks Narelle

Dim xmldoc As MSXML2.DOMDocument

Set xmldoc = New MSXML2.DOMDocument
xmldoc.async = False

 

[fastbuck]

Can anyone help with this one? Its now become annoying not being able to use my spreadsheet

 

[MARK858]

In tools/references try putting a tick in the Microsoft XLM...... tickbox (can't say which version number it will be as not running 2013).

 

[fastbuck]

Thanks for your help. I had a look and Microsoft XLM V6 was already checked so I unchecked it and checked V3 and it all works great now. Cheers Narelle