I have a problem that I can't narrow down and I'm stuck for ideas on where to go.
I have created a project that reads a file and gets the information it needs but appends it to a spreasheet.
The batch file then renames this spreadsheet and runs it through as input for a secondary Monarch project. where the output for this one is the name of the original spreadsheet.
Now I've taken the projects and the batch file and sent it to a coworker at another location. They've loaded the system with the same directory structure.
I can run the project endlessly with no problems. It will read in the information and append to the spreadsheet multiple times if I wish it to.
My co-worker's offsite system doesn't work. It doesn't append any information to the spreadsheet at all. When she sends me the spreadsheet back for me to use and check. It stops appending for me as well.
We're both using Excel 2003 (old, I know) and we're both using Monarch version 10.
When I look at the spreadsheet we're trying to appen to, there doesn't seem to be any difference inside it with one exception. The fonts and background of the heading cells are a diffent color. Apart from that we're both starting with a blank spreadsheet which is empty of information.
Essentially. I end up with an eact duplicate of the initial spreadsheet I start with and can work multiple times with except, Monarch fails to work. It skips over it very fast and doesn't append to it. Almost as if Monarch can't open the file from the batch and I don't know why. I've verified the data by opening. it in Monarch rather than running the batch and that works correctly.
Anyone have any expereince or knowledge in what could possibly cause this? Any hidden data possibly embedded somehow in the excel spreadsheet that might cause it to look similar but actually be different? Is there any way to capture perhaps the error number or code that would occur during a failure to open the spreadsheet in the batch file?
I'm kind of just reaching for ideas at this point.