Export to Excel (1 Viewer)

John Big Booty

AWF VIP

Local time

Tomorrow, 03:26

Joined

Aug 29, 2005

Messages

8,263

• Oct 8, 2010

• #1

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

Code:Copy to clipboard

Dim xl As New Excel.Application

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

 

J

JANR

Registered User.

Local time

Today, 19:26

Joined

Jan 21, 2009

Messages

1,623

• Oct 8, 2010

• #2

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

JR

 

John Big Booty

AWF VIP

Local time

Tomorrow, 03:26

Joined

Aug 29, 2005

Messages

8,263

• Oct 8, 2010

• #3

Sorry I'm not quite sure I follow

 

J

JANR

Registered User.

Local time

Today, 19:26

Joined

Jan 21, 2009

Messages

1,623

• Oct 8, 2010

• #4

Do you have set refrence to Excel ?

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

JR

 

V

vbaInet

AWF VIP

Local time

Today, 18:26

Joined

Jan 22, 2010

Messages

26,374

• Oct 8, 2010

• #5

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

AWF VIP

Local time

Tomorrow, 03:26

Joined

Aug 29, 2005

Messages

8,263

• Oct 8, 2010

• #6

Thanks for that

 

V

vbaInet

AWF VIP

Local time

Today, 18:26

Joined

Jan 22, 2010

Messages

26,374

• Oct 8, 2010

• #7

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

Lol.

 

John Big Booty

AWF VIP

Local time

Tomorrow, 03:26

Joined

Aug 29, 2005

Messages

8,263

• Oct 8, 2010

• #8

......both of you

 

John Big Booty

AWF VIP

Local time

Tomorrow, 03:26

Joined

Aug 29, 2005

Messages

8,263

• Oct 8, 2010

• #9

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

 

J

JANR

Registered User.

Local time

Today, 19:26

Joined

Jan 21, 2009

Messages

1,623

• Oct 8, 2010

• #10

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

AWF VIP

Local time

Tomorrow, 03:26

Joined

Aug 29, 2005

Messages

8,263

• Oct 8, 2010

• #11

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

 

J

JANR

Registered User.

Local time

Today, 19:26

Joined

Jan 21, 2009

Messages

1,623

• Oct 8, 2010

• #12

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

JR