Extract one sheet into CSV

[hcabs99]

Hi

some advise please. I have a spreadsheet with various sheets & macros , all of which result in data bring populated into a sheet called "upload"

I need to then extract the populated lines from just this sheet into a CSV file which is then stored on the users local drive.

I have worked out how to extract just the required data, but I'm struggling to work out, how to just extract the required sheet (upload) and covert to CSV. Also, just to make it just that bit more complicated, before saving the CSV, i want the user to be able to select the location where he wants to save the file. Reason for this is , a number of different users will be using this so i cannot hard code in "My documents" folder , and writing to C:/ is prohibited on certain PC's in my company

Any help would be appreciated

Cheers

 

[hcabs99]

This should suppress the prompts:

Application.DisplayAlerts = False

Set it back to True when done.

Thanks, almost perfect, it kept the this file already exists message, but now i think about it, thats ok to leave in.

Thanks for your help