A
Alex St-Pierre
Hi!
1) When I make a modification (ex: only add a line) inside a vba project,
and close vba without saving it and only save the excel file, I can't reopen
the excel file with the macro(excel error: must disable macro). (file size:
0.8m)
2)If I save the vba project and save the excel file, all works good at the
opening. (file size 1.4m)
I'm not familar with this kind of error. Is there a reason why the vba
cannot be compilate when I save only excel? Before last week, I never had
problem with this.
It seems to have a link between the file size and my error. If the file size
is 0.8m, I'm sure that I will get an error! Is there anything to add in the
problem to ensure the filesize will always be 1.4 even if I don't save the
vba project separately?
Does anyone has an idea ?
Thanks!
Alex
Note: I used Word library in the project but Word reference is always opened
(this is not new and worked well)
1) When I make a modification (ex: only add a line) inside a vba project,
and close vba without saving it and only save the excel file, I can't reopen
the excel file with the macro(excel error: must disable macro). (file size:
0.8m)
2)If I save the vba project and save the excel file, all works good at the
opening. (file size 1.4m)
I'm not familar with this kind of error. Is there a reason why the vba
cannot be compilate when I save only excel? Before last week, I never had
problem with this.
It seems to have a link between the file size and my error. If the file size
is 0.8m, I'm sure that I will get an error! Is there anything to add in the
problem to ensure the filesize will always be 1.4 even if I don't save the
vba project separately?
Does anyone has an idea ?
Thanks!
Alex
Note: I used Word library in the project but Word reference is always opened
(this is not new and worked well)