Hi,
I've got a workbook with multiple sheets, which is used to facilitate operational processes. I'm almost done with the "tool" except for one more thing.
I am looking for a vba code to save the sheet called "Input CW1" as CSV with the following side notes:
- I wish to save the file under the name I put in the tabblad "Output CW1" cell B2
- I wish to save the file in the location I put in the tabblad "Output CW1" cell B3
- I wish to connect this macro to a button in the tabblad "Output CW1" so the operator completes field B2 & B3, presses the button and then gets the file in the desired location.
Since I have little to zero knowledge of VBA I hope someone can support me over here.
Roland
I've got a workbook with multiple sheets, which is used to facilitate operational processes. I'm almost done with the "tool" except for one more thing.
I am looking for a vba code to save the sheet called "Input CW1" as CSV with the following side notes:
- I wish to save the file under the name I put in the tabblad "Output CW1" cell B2
- I wish to save the file in the location I put in the tabblad "Output CW1" cell B3
- I wish to connect this macro to a button in the tabblad "Output CW1" so the operator completes field B2 & B3, presses the button and then gets the file in the desired location.
Since I have little to zero knowledge of VBA I hope someone can support me over here.
Roland
