EXCEL AUTOMATION ERROR - almost there

General
1

Dim excel as ExcelApplication
Dim book as ExcelWorkbook
Dim sheet as ExcelWorksheet

These all give an error

I found a suggestion which worked for someone

ANSWER
move MSOfficeAutomation.rbx from the extras folder to the plugins folder

I found this MSOfficeAutomation.rbx from the extras folder

to the plugins folder

Where about’s in the plugins folder should I copy this to please ?

image

2

Hi George,

The file can be placed with those other plugins and it will work well.

Just remember to restart Xojo so that it will load the plug-in. :slight_smile:

3

I have used:

Dim excel As New ExcelApplication
excel.Visible = True
excel.Workbooks.Add 
excel.Cells(2,2).Value = "Test"
1 Like
4

I think I hadn’t restarted XOJO - Works perfectly now - Thank You