I have an excel file that currently does a few things when the specialorder macro is run...
It sorts by 9s and 13s and then saves the file with a new name plus that days date in a particular location (there is a specialorder button on the main sheet that needs to be pressed for this to happen).
When you first open the file you will see a Clspcontrol error or something pop up, that is because it is not connected to the database that it needs to pull the information from (that is what the GO button is for, when you press it it updates the values in the sheet)
Then you press the special order to run the way I would like it
What I need it to do is this...upon opening the sheet it runs the GO part automatically, waits 75 seconds, then runs the special order macro and then closes the files.
The macro does sort of do this now but it has a few issues, so you may need to do a ctrl+break to stop it from running otherwise the file close automaticallyanother problem I am having is that when when the new file that was saved is open...it runs the macro automatically again!)
Password to VBA is DBG or DGB
Please also remove the whassup part, hah, I was messing around with something
Thanks in advance for all the help I know I will get
Start Free Trial
