Script fails to run in other office/vba version 2007 > 2003

**vin1** · 02-21-2012, 06:12 AM

Hello i have some code and i get some odd error when trying to run my code on a 2003 excel/VBA vers.

It gives an error at the Format function. which worked fine in 2007.
altough the other computer had excel 2007, the file is build up from a .xls (2003).

the code it selects when trying to run:

Please Login or Register  to view this content.

The fat text is selected with an error wich says something like: "The project cannot be found".

Any ideas how to fix this problem?

My own guess is that it doesnt see "Format" as a excisting function. in other words its an undeclared variable. wich is not the case with the previous in the excel 2007 software on the different computer.

excel type = .xls (2003 main)

**AndyPS** · 02-21-2012, 06:46 AM

FORMAT$() certainly works in code written in Excel 2007 (Win7) and run on Excel 2003 (XP). I can't comment on FORMAT() running or not but I think it is in the Excel 2003 function list.

**vin1** · 02-21-2012, 06:51 AM

i whould think so too but for reason it doesnt see as if it is so.

is there any other way or other function how i can format some value in a textbox?

I can say that the current computer i am working on is very old (i think Windows XP).
but in the end i want this program be able to run on any microsoft / vba version if possible.

**AndyPS** · 02-21-2012, 06:58 AM

Could this be amissing reference (see http://www.cpearson.com/excel/missingreferences.aspx) and check in VBA Tools/references for which MS Office library is installed.

**vin1** · 02-21-2012, 10:22 AM

In that screen 4 lines are turned on:

Visual basic for applciations, Microsoft excel 11.0 Object Library, OLE Auotmation, Microsoft office 11.0 Object Library.
As far i can see notting else is turned on and notting is missing.

Wich line should be turned on for the function to make work?

I have no clue what each line is used for

**AndyPS** · 02-21-2012, 11:59 AM

I think it is the Visual Basic for Applications reference. Have you tried prefacing the function with VBA. (i.e.VBA.FORMAT()) to see if the explicit declaration works.
Also, do any other functions throw errors?
I have experienced intermittent problems with code use in a corporate environment with different builds of XP Professional and MS Office (11) though this was with scripting objects and caused problems at run time despite compiling OK. I believe this is late binding.

**OnErrorGoto0** · 02-21-2012, 12:57 PM

Are you checking the reference on the machine with the problem? I would put money on it being a missing reference, since Format is a native VBA function.

**vin1** · 02-22-2012, 04:27 AM

Yesterday there were not any refererences missing (perhaps somethign was not turned on)

today when i try open my programcode it gives an error: "cannot load DLL"
When i check my referances the next line is missing: "MISSING: Ref Edit Control"
This line was not turned on yesterday.

i did not make any changes since yesterday.

It is a bit weird for me and because of this, I cannot work on my project on this computer at the moment.

#Edit I can acces 1 userform actualy but the rest are most returning into an error.

**OnErrorGoto0** · 02-22-2012, 05:35 AM

Try unchecking the reference. You should not actually require a reference to use a RefEdit control. (they are however troublesome creatures. You may want to use Application.Inputbox instead))