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

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" wrote in message
news:3y0Pb.40589$Ar1.1729@fed1read04...
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

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

Dan Butler


"Rob van Gelder" wrote in message
...
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" wrote in message
news:3y0Pb.40589$Ar1.1729@fed1read04...
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