Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Excel Data to .CSV file
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 -- joelbeveridg ----------------------------------------------------------------------- joelbeveridge's Profile: http://www.excelforum.com/member.php...fo&userid=3704 View this thread: http://www.excelforum.com/showthread.php?threadid=56775 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Excel Data to .CSV file
heeelppppp..... pleas -- joelbeveridg ----------------------------------------------------------------------- joelbeveridge's Profile: http://www.excelforum.com/member.php...fo&userid=3704 View this thread: http://www.excelforum.com/showthread.php?threadid=56775 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Excel Data to .CSV file
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" wrote in message news:joelbeveridge.2bybt2_1154587504.2656@excelfor um-nospam.com... heeelppppp..... please -- joelbeveridge ------------------------------------------------------------------------ joelbeveridge's Profile: http://www.excelforum.com/member.php...o&userid=37045 View this thread: http://www.excelforum.com/showthread...hreadid=567758 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Excel Data to .CSV file
Don't forget to check your other posts.
joelbeveridge wrote: 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. -- joelbeveridge ------------------------------------------------------------------------ joelbeveridge's Profile: http://www.excelforum.com/member.php...o&userid=37045 View this thread: http://www.excelforum.com/showthread...hreadid=567758 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy data for match word from one file to another file | Excel Worksheet Functions | |||
How to copy 2007 excel file formula results into a 2003 Excel file | Excel Discussion (Misc queries) | |||
Copy data from one file to another | Excel Programming | |||
EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
using vba copy data from .csv file into an excel spreadsheet | Excel Programming |