View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default macro won't run macro

No. That is not Excel's little way of telling you your code is too long.
Excel generally speaks in the form of error messages.

Define "does not even begin to work". Do you get an error. Does the code
just stop (do you have error handling). Where is the third macro located?
Do you use code like

Range("A1").Select
Selection.Value = 3
Worksheets("Sheet3").Activate
Range("B9").Select
Selection.copy


Have you tried

Sub ThirdMacro()
converter
transferor
End Sub

--
Regards,
Tom Ogilvy

"dave glynn" wrote in message
...
I have two macros that I run together in another macro. Both work well if
used independently but when run as part of third macro, designed purely to
bring them together, it stops after running the first macro.

The first macro (the converter) takes data from another application and
converts it into a usable fromat. The second macro (the transferor)

transfers
the usable data to my main application.

Both run perfectly well if I run them as independent procedures.

However when I bring them together in a third macro to make conversion and
transfer a seamless process the transferor macro does not even begin to

work.

I have tried adding the transferor code to the ned of the converter macro,
still no joy, it stops at the ned of the conversion procedure.

Is this Excel's way of telling me that any extension of the converter

makes
the procedure too long.

Help please!!!!!!


Dave