Cannot activate the MODI Viewer Control

A

ArtDecade

I am having problems with my VBA procedure. Working in Excel's VB Editor I
have checked off Microsoft Office 11.0 Object Library and the MODI 11.0 Type
Library under Tools/Refernces. (I have some other libraries activated as
well.) All my programs, btw, are 2003, not XP.

I have written a procedure which allows me to create MDI files from Excel
spreadsheets. I can then get MODI itself to work. For example:

Dim MyDoc as New MODI.Document
Create MyDoc "C:\myfile.mdi"
MyDoc.PrintOut

However, I cannot get the MODI Viewer Control to fire up. I have tried
several versions of the following:

Dim MyDoc as New MODI.Document, Viewer as New MODI.MiDocView
Create MyDoc "C:\myfile.mdi"
Viewer.Document = MyDoc

NOTHING happens. I've tried moving NEW out of the Dim statements and into
the code itself. I have also tried using Dim MiDocView (dropping the MODI).
I've tried using Set statements. NOTHING works.

Is there a patch or updated library I should be using? Another library I
need to reference? Do I need to muck around with Class Modules (ugh!)?
Help!!

BTW, I am not a programmer but an end-user who has done a lot (for an
end-user) of programming to automate some of my daily Word and Excel work.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top