On Mon September 19 2005 08:20, + Jon Grosse wrote: > [ MODERATED ] ******************** > 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.
Hi Jon, The best mailing list for macros is [EMAIL PROTECTED] Please reply to [email protected] only -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
