strange application behaviour
Hello, experienced VB programmers
I have one huge problem with a small application i have developed recently.
It's in VB 6 and I've run it on several machines, but it won't work on the PC it's supposed to be run on.
The thing is I get run-time error 13 : type mismatch when I call any VBA method.
I wrote a small program to test some VBA methods (my program crashes on Weekday) and it works fine.
My program references ADODB and Surfer 8 type library and also VBScript regular expressions.
On the PC I'm trying to deploy on there is also vb 5 runtime installed, but
there are some VB 6 programs running.
Any ideas why this might be happening?
Thanks in advance
Re: strange application behaviour
Welcome to VBForums :wave:
Have you actually installed the package, or just copied the program/code file(s)?
Does this problem happen in VB itself, or with the compiled file? (either way, the things you reference need to be installed)
If it is in VB, you can check your references list (via "Project" -> "References"), and see if any of the ticked items are marked as "MISSING:".
Re: strange application behaviour
What are you coding in VBA, VB5 or VB6?
Re: strange application behaviour
Thanks for the welcoming =)
The problem occurs with the compiled file.
I have just copied my executable, but the computer has all necessary libraries already installed and updated with randem's Automatic OS Updater.
It's coded in VB 6.
Re: strange application behaviour
You really should not do it that way. Since I image it works on your development computer the problem seems to be with the dependencies. Create a proper installation and retry.
Re: strange application behaviour
Problem solved!
It turned out that the local settings for the date format on the PC I had problems with are different and apparently the CDate() function depends on these settings, so it yielded an error trying to convert the string passed ...