Hello, I am using a command line to open an Excel spreadsheet (from our customer) into Calc and automatically convert it to CSV and then close the spreadsheet.
My problem is: 1. The customers spreadsheet contains links to other spreadsheets (which I don't need or have access to) and shows a message box asking whether I wish to update these links. 2. When the CSV conversion macro runs I get a warning message telling me 'Only the active sheet was saved' My question is: How can I get my macro to ignore these messages (or close them automatically). Also is there a way to stop a macro running if it is set to run when opening a document? I believe that with Excel you could hold down <shift> or <control> when opening the sheet. Thanks Jon
