Ignore Blanks

[Todd]

Hi All,

I am currently writing a macro that pulls data in from a
text file, my problem is that the text file contains
blanks and i won't to write a macro that will ignore all
the blanks, and when it reaches a character to read it
into the spreadsheet
Can anyone suggest how i can ignore these blanks?
Thanks

 

[Rog]

How are you currently reading it in to the spreadsheet?

 

[Guest]

I'm using the filesystemobject from the microsoft
scripting references at the moment to read the file into
the spreadsheet.

 

[Rog]

Then whichever method you are using
(Read/Readline/Readall), you should just be able to use

worksheetfunction.substitute(string just read in," ","")
before you output to sheet

Rgds

Rog