| Junior Member with 1 posts. THREAD STARTER | | Join Date: Dec 2009 Location: Virginia Experience: Intermediate | |
Excel Worksheet to NotePad Type file I have generated a spreadsheet using excel. The data is stored in a worksheet column that looks like
((1.2,2.4),(3.2,5.4),
(6.2,8.4),(3.7,1.4),
(3.2,2.4),(5.2,5.4),
(7.2,2.4),(7.2,5.4))
I would like to 'copy' this data as it looks here to a notepad type file with the extension .djk. A file name like data.djk would be used. The data is used as an input file to another program
Is it possible to develop a macro that does this automatically in excel? The file name would be in a cell in the worksheet.
Currently I am using Excel 2003
Any help appreciated |