Export to Excel

[John Big Booty]

I've been having a play with the function posted here by ajetrumpet and have run into trouble with the line of code;

Dim xl As New Excel.Application

I'm getting a Compile error "User-defined type not defined" What should that line read?

 

[JANR]

Set refrence to excel, the code uses early-binding ?

JR

 

[John Big Booty]

Sorry I'm not quite sure I follow

 

[JANR]

Do you have set refrence to Excel ?

In the VBA window under Tools - Refrence Make sure you have selected Microsoft Excel

JR

 

[vbaInet]

John,

In the VBA editor:

TOOLS > REFERENCES > tick "Microsoft Excel X.0 Object Library" > hit OK.

Where X depends on your version of Excel. 11 will be for 2003 and 12 for 2007.

 

[John Big Booty]

Thanks for that

 

[vbaInet]

Always good to see or or even change to or at least

Lol.

 

[John Big Booty]

......both of you

 

[John Big Booty]

JANR, just out of curiosity where in Norway are you?

 

[JANR]

The town is called Kongsberg which is about 1 hours drive from the capital Oslo.

The town is most famous for its silvermines which was in service 1623-1958, now it's mostly hightech defence and offshore companys who runs the town.

JR

 

[John Big Booty]

Thanks JANR, just curious as my sister moved to Bergen earlier this year for work. So Norway is now at the top of our must visit list

 

[JANR]

Bergen, bring an umbrella.. the town in Norway which gets the most rain.

JR