Missing Library

[Richard Cole]

This is probably a FAQ, but an Alta-Vista^h Google search of this group
didn't find anything.

In Excel 2007 I've written a Form driven VBA macro that reads a text file
and inserts selected fields into the correct columns in a spreadsheet.

The code all runs fine on my PC (but then I do have VB6 Professional
installed), but when I run it on another users PC (no VB6 or any other
programming language, installed), it generates a 'Missing Library' error
message from the VBA the first time it encounters a Format command
[i.e. ActiveCell.value = Format(Now,"dd/mm/yyyy")]

Any clues on how to fix this as prior to this everything is working fine
(CommonDialog calls, etc).

I'm sorry I don't have the code at home, so the above example if from
memory, but the Missing Library bit seems to be the problem.

Thanks

Richard
For caravanning tips and information visit
http://www.caravanningnow.co.uk

 

[Jim Cone]

Try this search...
http://groups.google.com/group/micr...ogramming/search?q="missing+library"&start=0&
--
Jim Cone
Portland, Oregon USA



"Richard Cole"
wrote in message
This is probably a FAQ, but an Alta-Vista^h Google search of this group
didn't find anything.

In Excel 2007 I've written a Form driven VBA macro that reads a text file
and inserts selected fields into the correct columns in a spreadsheet.

The code all runs fine on my PC (but then I do have VB6 Professional
installed), but when I run it on another users PC (no VB6 or any other
programming language, installed), it generates a 'Missing Library' error
message from the VBA the first time it encounters a Format command
[i.e. ActiveCell.value = Format(Now,"dd/mm/yyyy")]

Any clues on how to fix this as prior to this everything is working fine
(CommonDialog calls, etc).

I'm sorry I don't have the code at home, so the above example if from
memory, but the Missing Library bit seems to be the problem.
Thanks
Richard
For caravanning tips and information visit
http://www.caravanningnow.co.uk

 

[Richard Cole]

Try this search...
http://groups.google.com/group/micr...ogramming/search?q="missing+library"&start=0&

Thanks Jim

I'll forward this to myself at work & start looking at using late binding.

Richard
For caravanning tips and information visit
http://www.caravanningnow.co.uk