My first VBA Excel program doesn't port to new computer..
My first VBA Excel program doesn't port to new computer..
(OP)
I developed my first Excel program and it works great on the computer on my desk. Last night I tried to run it on the manufacturing computer and it has a compile error.
I can't totally remember the error message and I am not at work right now, but I will update this post shortly. It make me think that one of my functions wasn't being recognised from one VBA module to the next.
Any wild ideas you have at this point will be welcome.
Thanks,
groundhog
I can't totally remember the error message and I am not at work right now, but I will update this post shortly. It make me think that one of my functions wasn't being recognised from one VBA module to the next.
Any wild ideas you have at this point will be welcome.
Thanks,
groundhog





RE: My first VBA Excel program doesn't port to new computer..
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: My first VBA Excel program doesn't port to new computer..
It shows
missing VIsio 11 type
missing Visio 11 dwg cntl
They reference dll files and i will put them on the new computer.
RE: My first VBA Excel program doesn't port to new computer..
My fight-or-flight panic response is going down now.
It needed some Visio dll files.
I have Visio on my desk computer, but not on the mfg machine.
Thankyou,
groundhog
RE: My first VBA Excel program doesn't port to new computer..
Not to rain on your parade, but you might want to make sure those Visio dll's are legally redistributable. Should say so in the Visio documentation if they are.
Regards,
Mike
RE: My first VBA Excel program doesn't port to new computer..
I did create bmp cartoons of the test setup in Visio, but I don't see why the spreadsheet really needs those dll files.
groundhog
RE: My first VBA Excel program doesn't port to new computer..
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.