Save\export specific worksheet error

Hi guys,

I am trying to run a macro that will export the 'Results' WS & ask the user where he/she wants the .xls to be saved, though when I click 'Save' nothing happens.

In additons in the save as part it has the WB's name(and full extention) is there a way to make this blank or to have something in it? I.e the WS's name?

Thanks in advance

Please Login or Register  to view this content.

hi SarahPintal

Please Login or Register  to view this content.

This will save the active workbook to another folder with the optin to rename it
but do you want to create a csv of sheet "Results" or a new workbook with the results sheet?

Pike,

Looks like this works:

Please Login or Register  to view this content.

though in the save field it has ""false.csv""'... is there a way to have the sheets name (results) in there instead?

thanks


End Sub

sorry watching back to the future three

arrrr.. this is some old code that ask for file name then folder to save the active worksheet to

Please Login or Register  to view this content.

with the csv you just can save and xls as csv
but we can do other stuff to create on and write to it?

marty michael fox is a laugh
which way would you like to go?

chopped down

Please Login or Register  to view this content.

or csv

Please Login or Register  to view this content.

your welcome .No need to be sorry.
you can change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.