F
farmboy
On one of my MS Excel document, I have developed VB GUI components, such
as a CommonDialog component for opening/saving a data file, triggered
by a button link to a macro. For example,
Sub buttonclick () {
...
Sheet1.CommonDialog1.xxx...
...
}
The EXcel document works on my computer, on my friend's computer, but
it doesn't work for the people we sent it to, for their own perusal. So
I tried opening and running the Excel document on another computer,
which has the same VB version installed (VBA 6.3). However, it breaks
with error saying that there is a library error and it couldn't find a
CommonDialog component. That is it could not find the CommonDialog1.
Could anyone suggest what could be the problem, and what I can look
for. My suspicion is the VBA installation, missing some Control
Component libraries. Or it could be the registry settings. Or could be
the PATH environment setting. etc.
Need help urgently.
as a CommonDialog component for opening/saving a data file, triggered
by a button link to a macro. For example,
Sub buttonclick () {
...
Sheet1.CommonDialog1.xxx...
...
}
The EXcel document works on my computer, on my friend's computer, but
it doesn't work for the people we sent it to, for their own perusal. So
I tried opening and running the Excel document on another computer,
which has the same VB version installed (VBA 6.3). However, it breaks
with error saying that there is a library error and it couldn't find a
CommonDialog component. That is it could not find the CommonDialog1.
Could anyone suggest what could be the problem, and what I can look
for. My suspicion is the VBA installation, missing some Control
Component libraries. Or it could be the registry settings. Or could be
the PATH environment setting. etc.
Need help urgently.