Saving CSV file and sending to a folder over and over again

If anybody has another way of doing it that would be good as well

i need the CSV sheet saving as a csv file to the path and name set in cell 'MATCH SETUP'!B34 , this cell name will change ie it will put the time it is saved in the name

so i need to save that file on demand when running the macro and hopefully say every 10 seconds as well (but that bit could wait)


maybe it could open a blank workwook, paste the data from CSV sheet onto the new workbook then save and send that new work book as a csv file to the path ,, maybe thats even more complicated !!

any ideas the less complicated the better would be good


thanks very much

scott

I Have attached a file to show what i mean if it helps

you will have to change the path name on the MATCH SETUP tab in cell B32 so it can save somewhere on your own computer to test

so on the Calculator Sheet when you press that button it will save the datat on CSV sheet as a CSV file to the path specified which is what i want

however when you rpess the button again it dosnt like it because the sheet CSV dosnt exist anymore because it has been overwritten with a new name from the csv file last saved

any ideas anyone ? could do with some help or a pointer in the right direction please

help

any code to change a worksheet name back to original name would help

thanks

ok ive taken itrom a differnet angle using some code ive found and changed a bit this works nicely wiht one exception,, it creates a copy of all the worksheets in my workbook

i woul dlike it to just copy one of the worksheets in my workbook , in this case the worksheet called CSV

What do i need to change ?

Please Login or Register  to view this content.

thanks

ok, i think i am talking to myself lol but i have solved that last problem and it now save the one worksheet i want it to ,

however after the active.window.close command at the end of my code it is asking me if i want to save the changes which i do but i just want it to automatically save rathe rthan ask me,

any idea ??????/

latest code

Please Login or Register  to view this content.

it's ok ive figured that bit out now

im slowly but surely getting there,, it now saves the one worksheet i want saving as a csv file to a path and name i want

the next thing is to do this automatically every 10 seconds , no idea how to do that , but will keep persevering

as always any help will be great

ok, what might be more manageable rather than use a time refresh to save the sheet is to save the sheet when my target cell changes , it seems to involve the Worksheet _change function but im unsure how to incoprate it into the code i already have

i want it to trigger this code when cell B34 changes

Please Login or Register  to view this content.

ok,, ive got something to work in a fashion

putting some code into a worksheet private sub function fires the macro i want howveer it only calls the macro if i physical type something into the cell, i just want it to call the macro if the data in the cell changes without me typing anything in,, any ideas please ?

Please Login or Register  to view this content.

i think i have worked it all out myself now from looking around websites etc and eperimenting so i will close thread as solved