Need advice for excel development

[Greenman]

Hi

I would appreciate it if someone can send me a link to a tutorial where I can learn to do development for excel using C# or Vb.net

[Nookie]

have you tried google

[Greenman]

Of cource I did:)

The problem that I have is the following:

I have developed a Vb program that creates an excel worksheet. The program works fine if I use Office 2007 but when trying to run the program with a computer that don't have office 2007 i get the following error:

'Could not load file or assembly 'Microsoft.Office.Interop.Excel,Version = 12.0.0.0,Culture = neutral,PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.

I think it has to do with the fact that I added the 'Microsoft Excel 12.0 object reference' wich is for Office 2007. The problem is that it must work for all versions of Office

[FReaKno2]

trying to remember but i think it goes something like

in vs2005
on your solution explorer
the top object is the solution properties
the one underneath is the Project properties
Right click this click properties
On the left you will have

Application
Build
..
..
..
Publish


Click publish

Click application files

Check the tick that says show all files

Look for the dll and change the include setting to include it

[GrimStoner]

I'm not sure whether installing the O2K7 Primary Interop Assemblies (PIA's) on the computer would work...

I'm also not sure whether developing the program using XP/2003 PIA's will then work on the computer using O2K7...

But it's worth a try.

I think there may be a O2K7 PIA merge module as well, that you can include in your setup project.

Edit: Go look at http://msdn.microsoft.com/en-us/library ... S.80).aspx

[GrimStoner]

Also...

http://www.microsoft.com/downloads/deta ... laylang=en