fredL
03-02-2010, 01:24 AM
Hi guys,
I'm having a bit of a problem. I've made a workbook containing a bunch of macros and forms, but when I open it from another computer in the network (the workbook is located on an office server) and try to run some of the macros, I get error messages like "the object isn't available on this machine" when trying to run a userform, and "can't find project or library" when running some other stuff.
I'm running Excel 2007 on both machines, and I've exported the modules from the original computer to the user computer. Every piece of code is there, but it's obvious I've missed something.
My question is: Is there a way to export my xls containing all the data needed to use the workbook correctly on another computer?
I'm having a bit of a problem. I've made a workbook containing a bunch of macros and forms, but when I open it from another computer in the network (the workbook is located on an office server) and try to run some of the macros, I get error messages like "the object isn't available on this machine" when trying to run a userform, and "can't find project or library" when running some other stuff.
I'm running Excel 2007 on both machines, and I've exported the modules from the original computer to the user computer. Every piece of code is there, but it's obvious I've missed something.
My question is: Is there a way to export my xls containing all the data needed to use the workbook correctly on another computer?