CruellBuell
12-06-2007, 12:05 AM
Hello out there,
I have built some VB code to manipulate data . For maintenance purposes I hav put the code in one workbook, and the data and buttons referring to the macros in another.
On windows this works fine (from win95/office 97 up to XP / office 2003)
Running the same pair on a MAC (Office 2004 for Max, OS 10.4) results in a crash. not immediately, but as it seems as soon as the code containing book saves itselves.
from then on it just starts up ans crashes on every action that calls a macro.:banghead:
When in debug mode, is suddenly (meaning at unknown event) states "Data invalid" won't show the VB code anymore and crashes on next occasion
simply opening the book on windows ans saving it solves the problem, for a while...
(books stored on a network drive, but local copies suffer the same problem)
it looks as if the code is overwriten?
: pray2: HELP anyone with a hint (or solution )
I didnot place code, since there is a lot of code, and no specific place where it crashes. When in debug mode, it just does not start up the code window, it simply crashes and restarts. if one opens the code pages then it looks truncated, or it states "invalid data" and stops on every action.
There are no event handlers active in my code.
I have built some VB code to manipulate data . For maintenance purposes I hav put the code in one workbook, and the data and buttons referring to the macros in another.
On windows this works fine (from win95/office 97 up to XP / office 2003)
Running the same pair on a MAC (Office 2004 for Max, OS 10.4) results in a crash. not immediately, but as it seems as soon as the code containing book saves itselves.
from then on it just starts up ans crashes on every action that calls a macro.:banghead:
When in debug mode, is suddenly (meaning at unknown event) states "Data invalid" won't show the VB code anymore and crashes on next occasion
simply opening the book on windows ans saving it solves the problem, for a while...
(books stored on a network drive, but local copies suffer the same problem)
it looks as if the code is overwriten?
: pray2: HELP anyone with a hint (or solution )
I didnot place code, since there is a lot of code, and no specific place where it crashes. When in debug mode, it just does not start up the code window, it simply crashes and restarts. if one opens the code pages then it looks truncated, or it states "invalid data" and stops on every action.
There are no event handlers active in my code.