MBR IT/.NET 247 : Excel problem on ASPFriends.com 'ngfx-msoffice' list

Excel problem

Messages

Related Types

This message was discovered on ASPFriends.com 'ngfx-msoffice' list.

Ulf.Ekberg@notes.sema.se

Hi all,

A collegue of mine is getting errors like "wrong library" etc when trying
to create an excel file from .Net

** code snippet**

Dim lobjExcel As Excel.Application

lobjExcel = CreateObject("Excel.Application")

' This row creates the error.
lobjExcel.Visible = False

** end code ***

He is using Excel 2000 on his machine and he gets the impression that the
errors point s to an Excel 97 library

What is wrong ? How should his syntax be ?

TIA

Ulf

Reply to this message...

Scott Hutchinson

Try this. In Visual Studio .NET, add a reference to the Microsoft Excel
object library, then:

Dim appXL As New Excel.Application

Use the above "As New" (early binding) instead of "CreateObject" (late
binding) whenever possible.

Scott Hutchinson
Click here to reveal e-mail address
(to contact me, remove all dots left of @)

<Click here to reveal e-mail address> wrote in message news:664950@ngfx-msoffice...
[Original message clipped]

from .Net</font>
[Original message clipped]

library</font>
[Original message clipped]

Reply to this message...

MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

	Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
	Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com