Please, any help with a problem finding vba code

[Dan]

Hi.

I wrote a form with Excel 2003 with XP at home. The form was very basic but
used some commands in vba such as Ucase, Strconv, and Format.

first question:
When i took it to work and tried the form it said that it couldn't find the
library for those three actions. Work is using Excel 200 on an office 200
server. However, i exported the form and and imported it into a new norm
(created with excel 200) and it recoginized the ucase, etc with no problem.
This is the first time i have ever had a problem with those commands. I did
another form at home and took it to work and same problem. Do i need to
convert or save the .xls in a different format?

second question:
Another form ised a Listview i added to the toolbox. I used a simople
command for it i.e.
dim x as listitem
for each x in listview1
msgbox x.text
next

this works great at home but at work it doesn't recoginize the listitem
command. When i added the listview to the toolbox at work, it found it no
problem.
Is there a way of coding a refernece or imports(such as in vb.net) that will
allow excel to recoginize the listitem command without adding it to the
toolbox?

thanks alot for the help
Dan Butler

 

[Rob van Gelder]

Dan,

1st Q: From VBA go to Tools References and look for the broken references.

2nd Q: For Each x in ListView1.ListItems

Rob

 

[Dan]

Thanks for the response Ron, I;m gonna try it tomorrow at work.

Dan Butler