Userform Problems

[Grant Ford]

I've assembled a flowchart and code that works great when it is on my
machine. However there is a userform within my VBA project that includes a
hidden spreadsheet and a visible chart that never appear to be transferred
whenever I save the program to a usb drive and attempt to launch it on
another machine. I use the microsoft office spreadsheet 10.0 and microsoft
office charts 10.0 controls to add these items to the userform. I currently
have access to only one other machine with Visio 2003 on it, so it may simply
be an issue with that machine, but both have the most recent Visio Service
Packs. If anybody else has had this problem or knows how to solve it please
let me know, thanks in advance

Grant

 

[Al Edlund]

and does the other system also have the office suites loaded as well.
al

 

[Grant Ford]

I believe so, I did check to ensure that the same controls were available on
the other machine, so I can add the spreadsheet and chart after I transfer
the program, but this isn't exactly acceptable for the end user.

 

[Al Edlund]

If it works when you get it over there and manually add the components, it
might be as simple as path statements. i.e. are they going into the same
directories.
al

 

[Grant Ford]

Al, you're a lifesaver, I've tried a few things now and I'm not 100% sure
which fixed the problem but all of my ideas were shots in the dark so I'm
sure yours did it, thanks a million!

Grant