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!
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!