Save and Exit macro with prompting dialog box
Posted: Mon Feb 12, 2018 5:43 pm
Hello there all,
I will appriciate any help with my goal that I want to accomplish with my [.ods] spreadsheet.
I have one spreadsheet with two subsheets named: Pokladnicna_kniha and DataVal.
I want to make Button (in Pokladnicna_kniha subsheet) with name: Save and Exit that will save the file to specific location: C:\username\desktop with name based on Cell value from, DataVal subsheet. Cell location is "P1".
I have the button, I have the cell "P1" with dynamic updateing based on some data input in spreadsheet, but I don't have the major part, which is code that Button should trigger.
I already find some written macros on some Forums, but it runs into runtime errors.
Can you help anyone?
I will appriciate any help with my goal that I want to accomplish with my [.ods] spreadsheet.
I have one spreadsheet with two subsheets named: Pokladnicna_kniha and DataVal.
I want to make Button (in Pokladnicna_kniha subsheet) with name: Save and Exit that will save the file to specific location: C:\username\desktop with name based on Cell value from, DataVal subsheet. Cell location is "P1".
I have the button, I have the cell "P1" with dynamic updateing based on some data input in spreadsheet, but I don't have the major part, which is code that Button should trigger.
I already find some written macros on some Forums, but it runs into runtime errors.
Can you help anyone?