Can't get my head around this one, hoping someone can help
I have a spreadsheet in Open Office that is a simple receipt system
I need to create a macro to do the following when an attached button is pressed
- Save a copy of the invoice (file name as invoice number, so say cell E9 =0001, the file name should be 0001.ods) to C:\Invoices\
- *If possible * - export a .pdf copy to C:\pdf Invoices\
- Add one to the invoice number in cell E9 (so 0002 in this case), ready for the next reciept
- Save the current sheet as say "current.ods" in C:\Invoices so the number will remain and stay consistent
I had this all set up fine in Excel 2010, but that isn't an option here. Internet cookies waiting for anyone who can show me the light
I have a spreadsheet in Open Office that is a simple receipt system
I need to create a macro to do the following when an attached button is pressed
- Save a copy of the invoice (file name as invoice number, so say cell E9 =0001, the file name should be 0001.ods) to C:\Invoices\
- *If possible * - export a .pdf copy to C:\pdf Invoices\
- Add one to the invoice number in cell E9 (so 0002 in this case), ready for the next reciept
- Save the current sheet as say "current.ods" in C:\Invoices so the number will remain and stay consistent
I had this all set up fine in Excel 2010, but that isn't an option here. Internet cookies waiting for anyone who can show me the light