I have a Calc spread sheet which i use for my invoicing, on that I have a "save"button that as well as saves the invoice to the appropriate folder it also opens a text file with the next invoice number with open for input to read the invoice number to apply’ it then updates the file with open for output and saves the new invoice number for next time.
is it possible to use something like “open for output” to a base file or even better a MYSQL database as part of the save macro
I am only looking to save things like the invoice date for instance (A1) and invoice amount (B2)
I have a base file connected to MSQL for this information but i have to manually input it after i save the invoice which is prone to errors
If someone could point me in the right direction I would much appreciate the help
Many thanks Neil