View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default VBA code for sending cells B6:J10 to text file.

Hi Luther

It's ready-to-use in the last part of Chip's page
http://www.cpearson.com/excel/imptext.htm

--
HTH. Best wishes Harald
Followup to newsgroup only please

"lothario" skrev i melding
...
Hi,

Can you show me VBA code that copies contents of cells B6:J10 into a
plain text file?
By contents I mean the actual data and not the formulas, etc.

I cannot use "Save As" CSV because this data changes often so I need to
automate this process.


Thanks,
Luther



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/