Compiling a VB project

[D-niss]

Hello all!

I have this small VB project that uses Excel (Office 2003) commands but I have Office 2002 on my pc. Obviously I get error when compiling because I use methods not recognized by Excel 2002.

Is there any way I can force the execute to be created? Any other way around this?

TIA

p.s. don't flame me I did a search but haven't found anything specific to my prblm.

[BuggyProgrammer]

You can't force it, because it wouldn't work if you did. You have to add some references to access Excel from a VB app. Post your code.

[D-niss]

Thanks for your prompt reply.

Here's the portion of my code that's bugging:

With theBook.Worksheets(1)
.ListObjects.Add(xlSrcRange, Range(.Cells(7, 1), .Cells(NoOfLine + 7, 11)), , xlYes).Name = "List1"
End with

It's obvioulsy an Excel 2003 command.