Hi guys I am no VB expert at all so I am in desperate need of help please.
Does anyone have some code I can cut and past for the following:-
I have a excel spreadsheet with 2 worksheets.
I have a button in one of the sheets and what I want to happen is once this button is clicked I want it to activate a sheet called Data Fixes and export out the data inside it to my D: drive in CSV format and have the file name as yesterdays date in the format DD.MM.YYYY.csv however I this will be clicked a few times a day so I would want it to append to the same file and not over write it.
Can anyone help at all??
Cheers
Ian
Does anyone have some code I can cut and past for the following:-
I have a excel spreadsheet with 2 worksheets.
I have a button in one of the sheets and what I want to happen is once this button is clicked I want it to activate a sheet called Data Fixes and export out the data inside it to my D: drive in CSV format and have the file name as yesterdays date in the format DD.MM.YYYY.csv however I this will be clicked a few times a day so I would want it to append to the same file and not over write it.
Can anyone help at all??
Cheers
Ian