Define an excel built-in function

[CyberJar]

Hey All,

How do I define the built-in FORMAT function? My Excel app requires it


Is it something like:
Declare Function Format Lib "kernel32" ..................?


Thanks,
CJ

[RhinoBull]

You don't define it - just use it. But what is it that you need to format?

[CyberJar]

My app gets errors on PCs that don't have the VB libraries installed.

By defining everrything - so far- the erroes have gone away.

I'm getting an error on the line that is defining the Format builtin function. So I think If I define it, the error will go away.

I'm formatting a value located in a Worksheet Cell and assigning it to a text box on a form.

Thanks,
CJ

[RhinoBull]

Oh, I see ...
VB executables are not stand along programs - they must installed properly by whatever packaging utility you can use - perhaps Package And Deployment Wiazard (aka P&DW) that comes shipped with VB. So, if you just copy/pasted your exe file from dev machine to user - build distribution package first and then install it.

[CyberJar]

Thanks for your reply.

The thing is the client wants the app to run over the Internet ( on their web server) so I cannot install anything to anyone's computer because of firewalls and other software.

Can you suggest another way around this?

CJ

[RhinoBull]

You may package at least vb's runtime files + referenced libraries and zip'm up but your users will have to know how to register those files. Another way (and it's much better and cleaner too) create a self extract install package and have link to it available on your page so they can download and install first.