Requirements to run excel 2000 with VBa
 

hi all,
I new in excel 2000 and vba.
i m calling SAP from excel. However, i find that excel runs fine on my
machine and other 2-3 machines. but at some places its not working and
that machines are at different location (country).
i checked it and found out that visual studio 6 is missing on their
machine.

please can anyone suggest me what are the requirements to run excel
coded in VBA???


please help me as its needed urgently.

thanks in advance,
jigs

Requirements to run excel 2000 with VBa
 

Depends what you mean by "its not working". Some details, error
descriptions, line of failure, etc would help.
However, VS6 is not a basic requirement to run VBA.
But, it will depend on the components and libraries referenced in the
workbook.

Check the ToolsReferences for any marked "MISSING".

NickHK

"jigs" wrote in message
oups.com...
hi all,
I new in excel 2000 and vba.
i m calling SAP from excel. However, i find that excel runs fine on my
machine and other 2-3 machines. but at some places its not working and
that machines are at different location (country).
i checked it and found out that visual studio 6 is missing on their
machine.

please can anyone suggest me what are the requirements to run excel
coded in VBA???


please help me as its needed urgently.

thanks in advance,
jigs

Requirements to run excel 2000 with VBa
 

hi nick,
when we execute enable micros to run its giving compilation error.
when we try to find out missing in references and found that VB forms
dll is missing...

we tried to include that in sys32 folder but its not working still...

please help to sort it out.

u were telling me abt some components..
what are required?


jigs

Requirements to run excel 2000 with VBa
 

Do you mean the reference to "MS Forms 2.0 Object Library" is marked as
"MISSING".
If so, this is part of the Office installation, not VS.

If not, which reference ?

If it does turn out to be a component that is provide by VS, then will need
to make sure all machine have that component installed, either by VS or an
individual license.

Is the DLL registered ?
It is not enough just to copy the file .
http://www.vbaccelerator.com/insprob.htm

NickHK

"jigs" wrote in message
ups.com...
hi nick,
when we execute enable micros to run its giving compilation error.
when we try to find out missing in references and found that VB forms
dll is missing...

we tried to include that in sys32 folder but its not working still...

please help to sort it out.

u were telling me abt some components..
what are required?


jigs