Question about text files from excel. DESPERATE HELP NEEDED.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know about the Print# and the Input# and the Input# functions for Excel
when moving information to a text file from a spreadsheet. But, how do I set
it up so that I can concatanate string text(my own text) with the fields
coming from the spreadsheet? It is not going to be a a delimited file but a
custom format file that I want to blend in with my own stringed text. Please
help. Thanks!

Brett
 
dim myStr as string
myStr = "this is mine " & activesheet.range("a1").text & " and this is mine"

maybe???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a text file and printing excel spreadsheet data onto it 1
Excel VBA help: Text file formatting 19
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
Excel Typed text appears in wrong cell 0
import text 1
Excel EXCEL 2010 HELP 1
Help file for VBA custom function 2
Copying Text from a file into Excel w/ Macro 6

Back
Top