Thread: Help - Can Excel create a text file??
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] donnie.sims@gmail.com is offline
external usenet poster
  
Posts: 1
Default Help - Can Excel create a text file??
Try this
ActiveCell.FormulaR1C1 = Range("A1")
ActiveCell.FormulaR1C1 = Range("A2")

Open "C\text.txt" For Append As #1
Write #1, Range("A1"),1Range("A2")
Close #1

Reply With QuoteReply With Quote