Hi All,
I was wondering if somebody could help me with an excel query problem.
In my new role, we have to do create a daily report from a backup server. This normally entails logging on to the server, generating a preliminary report in html and then manually copying the table into an excel sheet that will calculate the % of failures etc...
I'm not much a programmer but have written a bat script to automate this as much as possible and created a simple query to take the data from the HTML table and import it into the xls sheet. When each report is complete, we have to copy it to a sharepoint for recording and RC analysis.
I was wondering if there is anyway to automatically delete the query from excel when the file is saved, so it can't be updated anymore?
It would be great if someone could help and I will apologize in advance for my lack of excel knowledge!!!
Thanks,
Fionnan
Bookmarks