Hey All-
I was handed a prexisting project and I want to make it bettter, there are some quirks in the code and some of it I can fix, some I can't.
This one for example I can't...
We have a button that when you click it, it calculates some values, and then prints it in on a graph in excel.
Anyway, when you don't close excel using File/Quit and just close using the X and try and run the command again by clicking the button, I get the error Method 'Worksheets' of object '_Global' failed.
Can anyone suggest to me as to what the problem could be and any possible resolutions?
I was handed a prexisting project and I want to make it bettter, there are some quirks in the code and some of it I can fix, some I can't.
This one for example I can't...
We have a button that when you click it, it calculates some values, and then prints it in on a graph in excel.
Anyway, when you don't close excel using File/Quit and just close using the X and try and run the command again by clicking the button, I get the error Method 'Worksheets' of object '_Global' failed.
Can anyone suggest to me as to what the problem could be and any possible resolutions?