View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RadarEye RadarEye is offline
external usenet poster
 
Posts: 78
Default command not found when using excel VBA function format

On 7 dec, 19:40, OHCQ_DB wrote:
I have an extensive piece of VBA code that use the format function. *The
macros run on my development machine and on one other in building. *I tried
to use the code on an additional computer and got a command not found error. *
I am assuming that means that there is some file missing on that computer.. *
Can anyone suggest what the specific fiel might be?

Thank you


Hi OHCQ_DB

On one of the machines the project does work:
Load de file
Open the VBE ([Alt]+[F11])
Click Tools -- References.
All needed / used extra files are listed here.
Copy the filenames

On one of the machines the project is not working:
do the same and check if one is missing
There should be a marking with "MISSIING" in the list.

Hoop This Help,

Radareye