Re: VBA and VSTO

Tech-Archive recommends: Fix windows errors by optimizing your registry

Just wondering how you were getting on with this.
The offer to look at your workbook(s) still stands.

RBS

"Jos Vens" <jos.vens@xxxxxxxxxxxxxx> wrote in message news:%23OKZFvQWGHA.128@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

after doing al steps, problems remain:

I've exported all modules and forms, imported them in a new project
I've set on all modules: option explicit and declared all variables
I've compiled thet project (XP) and set it up for Office 2000. It crashes.
I recompiled the project in Office 2000. If I save it afterwards, excel crashes while I'm saving.

Strange things are happening. I don't see any reason to not move to VB6. It would be nice to have an EXE-file to start up, in stead of a dll, adding to excel. Can I call a procedure of an exe-file of VB in VBA (the event-cycle must stay in VBA I guess, so I would like to call procedures in VB).

Thanks,
Jos

"RB Smissaert" <bartsmissaert@xxxxxxxxxxxxxxxx> schreef in bericht news:e1UC4SrVGHA.5916@xxxxxxxxxxxxxxxxxxxxxxx
I wouldn't worry too much about that for now.
I think the main thing is to be able to compile the project with Option Explicit in each and every module.
I have had some modules of those sizes and no problem at all.
I noticed you had lots of modules that were very small, so you should be able to put modules together.
Still, worry about the other thing first.

RBS

"Jos Vens" <jos.vens@xxxxxxxxxxxxxx> wrote in message news:OvW3%230qVGHA.6048@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

after exporting everything, I have three critical modules: 87k, 75k and 64k. I split them, but so the number of increases...

Jos


"RB Smissaert" <bartsmissaert@xxxxxxxxxxxxxxxx> schreef in bericht news:%23LiI9%23jVGHA.1356@xxxxxxxxxxxxxxxxxxxxxxx
Here is some code that will export all your modules, to look at the size of them.
This doesn't seem the main problem, but interestingly your
module Libra_Toolbar is 74 kB.

You will need to set a reference to
Microsoft Visual Basic for Applications Extensibility
to run this code:

Sub ExportAllVBA()

'to export all the modules and forms to files
'--------------------------------------------

Dim VBComp As VBIDE.VBComponent
Dim Sfx As String
Dim strExportFolder As String

strExportFolder = "C:\Libra\Modules\"

'so overwrite old files without warning
'--------------------------------------
Application.DisplayAlerts = False

On Error Resume Next
MkDir strExportFolder
On Error GoTo 0

For Each VBComp In ThisWorkbook.VBProject.VBComponents
Select Case VBComp.Type
Case vbext_ct_ClassModule, vbext_ct_Document
Sfx = ".cls"
Case vbext_ct_MSForm
Sfx = ".frm"
Case vbext_ct_StdModule
Sfx = ".bas"
Case Else
Sfx = ""
End Select
If Sfx <> "" Then
VBComp.Export _
Filename:=strExportFolder & VBComp.Name & Sfx
End If
Next VBComp

Application.DisplayAlerts = True

End Sub


RBS


"Jos Vens" <jos.vens@xxxxxxxxxxxxxx> wrote in message news:uLjX8RfVGHA.5588@xxxxxxxxxxxxxxxxxxxxxxx
Hi Bob,

you can try it yourselve: I stripped a lot of code and placed it on my website. You can download Libra and extract it. You start it up with Libra.xls which opens Libra.xla in the Programma folder. It is compiled with office 2000 first release, so in that case, it does not crash (in office 2000, it never crashes on any servicepacks)

So the assumption of 100 modules is not right here, because I deleted many modules and almost all forms. Maybe something must be corrupted but the CleanProject did not resolve anything...

http://www.puntenboek.be/Download/Crash.zip


Jos

"Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx> schreef in bericht news:uRLlf$eVGHA.4952@xxxxxxxxxxxxxxxxxxxxxxx
If that is the case, you should be able to strip it down to something much
simpler than causes these crashes. Could you do that and then offer the code
for review?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jos Vens" <jos.vens@xxxxxxxxxxxxxx> wrote in message
news:us7irJeVGHA.4764@xxxxxxxxxxxxxxxxxxxxxxx
Thank you all for your reactions. Let's explain a bit more:

I just tried Bob's method: I opened my application in Office 2000 first
edition. Compiled it. Worked fine.
Then I opened it in office XP, crashed on startup.

I think Bob means: all commands of 2000 will work on XP and 2003. Yes, I
know, but thats not the problem. I use only 2000 commands. The problem is
the compilation. If I migrate from 2000 to XP or 2003, my compilation is
gone. I know that because if I open the VBE-environment, the menu-item to
compile is black, not greyed out, saying my project is not compiled yet.
If
I compile then, It works fine.

What have I figured out by now: it is the mso.dll that causes the problem.
I
build my menubar on startup, and there it crashes. If I use the mso.dll
from
the excel version I have compiled with (by replacing the installed one), I
have no problem.

I know my project loses it compilation if it encounters another mso.dll. I
also know that if I forget to compile, my project crashes. So If I
compile,
and go to another excel-version, compilation is gone and my project
crashes.

Thanks, more suggestions are welcome!
Jos Vens

"Jos Vens" <jos.vens@xxxxxxxxxxxxxx> schreef in bericht
news:uvxoCCcVGHA.5900@xxxxxxxxxxxxxxxxxxxxxxx
>I know,
>
> but if VSTO is stable, I can convince my customers to migrate to > 2003,
now
> it's a mess: my excel application crashes on almost every machine,
unless
> it is upgraded to the right version (like for XP is it > 10.6789.6735
SP3).
> All other versions are crashing, unless I recompile. I've built a
compiler
> (I use the sendkeys method to unlock the project etc etc... It > worked,
but
> on 2003 I couldn't save it anymore - an error on saving appeared > for an
> unknown reason).
>
> Thanks for all your suggestions!
> Jos Vens
>
>
>
> "Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx> schreef in > bericht
> news:eIFbDYbVGHA.2444@xxxxxxxxxxxxxxxxxxxxxxx
>> If you are deploying to Excel 2000 and Xp as well as 2003, VB.Net >> isn't
>> really an option anyway.
>>
>> -- >> HTH
>>
>> Bob Phillips
>>
>> (remove nothere from email address if mailing direct)
>>
>> "Jos Vens" <jos.vens@xxxxxxxxxxxxxx> wrote in message
>> news:O1B0EUbVGHA.736@xxxxxxxxxxxxxxxxxxxxxxx
>>> Hi Chip,
>>>
>>> I mean, I developped in VBA, and I don't want to spend to much >>> time to
>>> set
>>> my code in vb.net. Is the language comparable or do I have to >>> learn a
>>> lot
>>> (and debug a lot) to get my code back in vb?
>>>
>>> I never used VB.NET! I assume you mean I cannot copy and paste >>> my code
>> from
>>> vba to vb.net.
>>>
>>> Jos
>>>
>>> "Chip Pearson" <chip@xxxxxxxxxxxx> schreef in bericht
>>> news:uuJmpPYVGHA.1728@xxxxxxxxxxxxxxxxxxxxxxx
>>> > Assuming you know VB.NET,
>>> >
>>> >> 1. Is my code in VBA in a high level portable to the new >>> >> platform
>>> >
>>> > Only you can answer that question.
>>> >
>>> >> 2. Can I compile the project to an executable stand-alone >>> >> file
(.exe)
>> so
>>> >> I am not dependent to what the user have installed of dll's
>>> >
>>> > With VTSO, you end up with a workbook and a managed code DLL.
>>> >
>>> >> 3. Does it work with all versions of Office (starting with >>> >> 2000)
>>> >
>>> > No. 2003 only.
>>> >
>>> >
>>> > -- >>> > Cordially,
>>> > Chip Pearson
>>> > Microsoft MVP - Excel
>>> > Pearson Software Consulting, LLC
>>> > www.cpearson.com
>>> >
>>> >
>>> >
>>> > "Jos Vens" <jos.vens@xxxxxxxxxxxxxx> wrote in message
>>> > news:ubE1QEYVGHA.5020@xxxxxxxxxxxxxxxxxxxxxxx
>>> >> Hi,
>>> >>
>>> >> since I have serious problems in VBA, I consider to migrate >>> >> to
VSTO.
>>> >> I
>>> >> have some questions about that, in order of importance:
>>> >>
>>> >> 1. Is my code in VBA in a high level portable to the new >>> >> platform
>>> >> 2. Can I compile the project to an executable stand-alone >>> >> file
(.exe)
>> so
>>> >> I am not dependent to what the user have installed of dll's
>>> >> 3. Does it work with all versions of Office (starting with >>> >> 2000)
>>> >>
>>> >> Thanks for your help.
>>> >> Jos Vens
>>> >>
>>> >> PS my big problem in VBA is the difference of the mso.dll >>> >> (mso9.dll
>>> >> for
>>> >> office 2000) of the different office versions, which causes a >>> >> crash
>>> >> on
>>> >> startup when I build up my menu-bar. Recompilation on the >>> >> specific
>> excel
>>> >> version solves the problem, but then I have to maintain at >>> >> least 3
>>> >> versions (2000, XP and 2003). Even subversions (Service Packs >>> >> and
>>> >> minor
>>> >> upgrades cause those commilation problems so I cannot keep >>> >> that
much
>>> >> versions).
>>> >>
>>> >
>>> >
>>>
>>>
>>
>>
>
>













.

Quantcast