general misunderstanding

[AK]

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

 

[Bob Phillips]

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.