Copy Excel Data to .CSV file

[joelbeveridge]

Ok Gang, This is going to be a Hard one for you Smart people.

I need a Super powerful Macro so when i click on the macro i
automatically saves the chosen data as a .CSV file.

I'll Give you E.g.

I enter data (numbers,text) from Cell "A1" across to Cell "G1" and dow
to "G12" then back to "A12" making a nice box full of Sexy data. The
After all that data is entered i Click on my Super Powerful Macro an
it gets all that information and saves it into a .csv file somewher
esle. So in the end i would have my normal Excel doc and my New .cs
doc.......

If anyone can help me with this you will be the smartest person alive

 

[joelbeveridge]

heeelppppp..... pleas

 

[NickHK]

It's only been a while.

Try this:
Dim InitialName As String
InitialName = ThisWorkbook.Name
With Worksheets("SexyData")
.SaveAs .Name & ".csv", xlCSV
End With
ThisWorkbook.SaveAs InitialName, xlNormal

You need add error trapping/check for existing files.

NickHK

"joelbeveridge" <[email protected]>
wrote in message
news:[email protected]...

 

[Dave Peterson]

Don't forget to check your other posts.

Ok Gang, This is going to be a Hard one for you Smart people.

I need a Super powerful Macro so when i click on the macro it
automatically saves the chosen data as a .CSV file.

I'll Give you E.g.

I enter data (numbers,text) from Cell "A1" across to Cell "G1" and down
to "G12" then back to "A12" making a nice box full of Sexy data. Then
After all that data is entered i Click on my Super Powerful Macro and
it gets all that information and saves it into a .csv file somewhere
esle. So in the end i would have my normal Excel doc and my New .csv
doc.......

If anyone can help me with this you will be the smartest person alive.