general misunderstanding

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AK - 18 Mar 2008 22:29 GMT

I have Excel 2003 & Visual Basic 6.3 which I can launch via ALT+F11.

First, I couldn't find VB 6.3 in any of my Program Lists or my hard drive -
where is this program located ? Can this program be launched outside of Excel
?

Secondly, I have a simple Public Function written in a seperate module.
When I go back to Excel this function is not seen(get #NAME? error).
Why does this happen ? Is there some that needs to be done to tie my
Book1.xls VBA Project to the Excel file ?

Please help -

ak

Reply to this Message

Bob Phillips - 18 Mar 2008 23:50 GMT

>I have Excel 2003 & Visual Basic 6.3 which I can launch via ALT+F11.
>
> First, I couldn't find VB 6.3 in any of my Program Lists or my hard
> drive -
> where is this program located ? Can this program be launched outside of
> Excel

It is a DLL shared between the Office programs, VBE6.DLL, in the common
files area of Program files.

It cannot be launched independently, it hasto be hosted by an Office app.

> Secondly, I have a simple Public Function written in a seperate module.
> When I go back to Excel this function is not seen(get #NAME? error).
> Why does this happen ? Is there some that needs to be done to tie my
> Book1.xls VBA Project to the Excel file ?

If it is a different workbook, you need to qualify it with the workbook
name.

Reply to this Message