Excel Macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel macro application run beautifully on a PC using Excel-97. I
cannot get it to run on other PC's (same vintage) in my office. I want to
upgrade all PC's and version of Excel being used, but I am reluctant to start
the upgrade process until I can get the macro working on more than one PC.
When I click on the macro icon I get the message "The macro ProductionOrder
cannot be found".

I can see that ProductionOrder is a subroutine within a Visual Basic macro,
but copying that file to my test PC does not overcome the problem. Does
anybody have any ideas?

Ray
 
Just some thoughts ..

The sub: ProductionOrder could be one located within Personal.xls
rather than the file/book itself.

When you do an ALT+F8 on the original PC, does it appear in the Macro dialog
as: Personal.xls!ProductionOrder ? (rather than just: ProductionOrder)

If so, try copy the sub over from Personal.xls to the file itself in VBE's*
project explorer's window then save the file. Now the file will carry the sub.
*Press ALT+F11 to go to VBE, the project explorer window should be tiled on
the top left [titled: Project - VBAProject]. Press CTRL+R to make it visible
if necess.

To copy the sub, in VBE's project explorer's window, find & drag the module:
ProductionOrder from amongst those listed under Modules in VBAProject
(Personal.xls), then drop it into VBAProject (<your file>.xls)
 
Back
Top