I'm trying a microsoft example (http://msdn2.microsoft.com/en-us/library/aa140253(office.10).aspx (http://msdn2.microsoft.com/en-us/library/aa140253(office.10).aspx)), when i try to generate the excel BoM i get an error.
Roughly translated:
"A user defined data type is not defined"
VBA tells me the problem is somewhere with
Dim appExcel As Excel.Application
Anyone know why its not doing this?
Commenting shows me it also crashes on:
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
- Lars-Erik
did you include the excel libraries in your references
Tools > References when you're in the VBA editor...
That did it, thanks...