Imports required for Excel Automation in VB.NET

[lklo]

Hi

Does anybody know what Imports **** is necessary in nx journal,
so it will be possible to use Range (excel).

I need to dim variable Cell.
to be used in a little sequence ...
------------------------------
But I got an error in line 40 - type ´range´ is not defined

line 40: Dim Cell as Range

For Each Cell In ws.UsedRange.Cells
If Cell.Value = "" Then Cell = Num
MsgBox ("Checking cell " & Cell & " for value.")
Next


lklo

 

[lbd7700]

Hi, if you haven't, please try adding the -Microsoft Excel (office version) Object Library- reference, and then:

Imports Excel = Microsoft.Office.Interop.Excel

Dim Cell As Excel.Range

Regards