473,320 Members | 1,580 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Problems with VBA using Excel 2003 (missing DLL's)

Hi everybody,

About 5 years ago I created a program using Visual Basic in Excel 2003. This has always worked perfectly in our company.
Problem now is that one of the pc's it ran on has crashed, I re-installed Windows XP, and Office 2003 with original disks but when running this excel file is gives an error concerning missing DLL's but does not say which one.
The program still works on the other pc's so it must be something with the installation of Office I think.

I noticed that .NET is also installed upto version 4.
Could that be the culprit ?

Anyone got any ideas as to what could be going wrong.

Thanks a lot for your info.
Andy
Oct 17 '11 #1
6 2706
Guido Geurs
767 Expert 512MB
Is it possible to install XP and office 2003 on a blanco new PC without .net?
Run the VB program and=>
- If it's not working then you are missing DLL's who are not in the original packet.
- If it's working, then the software XP and office is OK and is on the original PC the DLL deleted or overwritten with a new version in which the called functions in the VB are not present or changed ?.

Do you have the source of the VB program?
Are there function call's?
Are all the DLL's in these call's present?
Are there References linked?
Are these DLL's present?
Oct 17 '11 #2
Guido, thanks for your reply.
Here is your answer with my comments.
Weird that it works on all other machines.
Andy

Is it possible to install XP and office 2003 on a blanco new PC without .net?
Not possible as the .net is neccessary for another program.Run the VB program and=>
- If it's not working then you are missing DLL's who are not in the original packet.
- If it's working, then the software XP and office is OK and is on the original PC the DLL deleted or overwritten with a new version in which the called functions in the VB are not present or changed ?.

Do you have the source of the VB program?
Yes, I wrote it myself
Are there function call's?
The first error mentioned is when I try to give a variable a value
Are all the DLL's in these call's present?
That's the problem, which DLL's are missing and which do I need ?
Are there References linked?
Are these DLL's present?
Oct 18 '11 #3
Guido Geurs
767 Expert 512MB
- By a blanco PC I mean an other PC: new or old with nothing on the HD.
Just for testing XP, office and your program.

- A variable in a "Declare function..." or a variable "Dim"med by your own?
Oct 18 '11 #4
Guido,
Ik heb geen 'lege' pc beschikbaar.
De code dat een fout geeft is....
datetot = DateSerial(2010, 2, 10)
Met deze variabele (datetot) ga ik de datum van vandaag verglijken en naargeland eerder of later wordt er een bericht getoond.
Heeft jaren gewerkt, nu met deze pc (na her-installeren) niet meer.
Wat nog raarder is dat als ik deze sub-routine en de call ernaartoe verwijder werkt het nog niet, geeft steeds melding ivm dll's.
Ik heb nu .net versie 4 er vanmorgen verwijderd en ga straks proberen met Office 2003 opnieuw te installeren. Misschien dat dit werkt.
Alvast bedankt voor je tijd en raad.
Andy
Oct 18 '11 #5
Guido Geurs
767 Expert 512MB
Please Andy, can we continue in English ? (house rule of Bytes) so everyone can read it and learn from our problems and solutions.

Do you know the "Object browser" in VBA ?
It tells us in which DLL the function "Dateserial" is found. (see attachments)

Dateserial is in the VBA DLL location: (click on the green VBA at the bottom)
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
Is this file OK?
Attached Images
File Type: gif Object browser.gif (15.7 KB, 239 views)
File Type: gif References.gif (10.8 KB, 256 views)
File Type: gif VBA file.gif (16.4 KB, 379 views)
Oct 18 '11 #6
Guido,

Sorry for the Flemish text, I forgot for a moment that others might also read this.
Appologies to all readers.

My problem is solved !
How did I solve it ?
As I said, yesterday I removed .net version 4 (VBA still gave errors)
This morning I removed Office 2003 and re-installed it (VBA still gave errors)
I installed service pack 2 from disk (VBA still gave errors)
I installed service pack 3 from MS-site (VBA works)

Thanks again for taking the time to read and reply to my messages.
I'll certainly be back if I need more help on VBA in the future.

Kind regards,
Andy
Oct 19 '11 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: cybertof | last post by:
Hello, Is there a way to connect (through automation) a c# application to a running Excel 2003 instance on a specific workbook ? In the past, i used to use GetObject(...) function in VB6. ...
2
by: kosecki | last post by:
Hi, I can't find the way to do something from vb .net in current copy of Excel. All posts which I read tell how to make application.excel object and do something. I need to write something like...
2
by: Dominic | last post by:
Hi I've done a lot in Excel Automation in prior C# and VB.Net Versions...but I've no chance just to open an Excel Workbook with Visual Studio 2005. I've go always these HRESULT-Failures...:-( ...
5
by: Mike in Santa Rosa | last post by:
I'm trying to get a simple c# app built that can launch/manipulate an excel workbook, sheet. I've chased down several examples and can't any of them to work. So I must be doing somethnig obviouslt...
0
by: Darragh | last post by:
I'm encountering some serious problems trying to set Access 2000 querys (parameters and views) as data sources for my mail merge documents (Word 2003). After spending hours scouring the web for...
5
by: =?Utf-8?B?U3R1YXJ0?= | last post by:
Hi There I have been having a play around with the following code to display a datagrid in Excel (all from Steve Orr's site): Private Sub btnTechServAccred_Click(ByVal sender As System.Object,...
0
by: liam_jones | last post by:
I'm very new to Python, well IronPython to precise, and have been having problems when using Excel. The problem I'm having is the closing of my Excel object. I'm able to successfully quit the...
1
by: lilmunchkin97 | last post by:
I don't know if I'm in the right place or not, but I'm using Excel 2003 and I'm trying to make the white checkbox larger. I've changed the height and width numbers, but that only makes the white...
4
by: =?Utf-8?B?THluZXJz?= | last post by:
Hello All, We have a VB.NET application writen using VS 2003. This application apens an excel file from a vendor, reads the data and performs whatever functions it needs. We recently upgraded our...
1
by: bcr123 | last post by:
As I couldn’t find suitable calculation by using Google: I am using Excel 2003 and I am trying to calculate maximum drawdown for given data sample. Various data is recorded in column D...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.