Ignore Blanks
 

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

Ignore Blanks
 

How are you currently reading it in to the spreadsheet?



-----Original Message-----
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


.

Ignore Blanks
 

I'm using the filesystemobject from the microsoft
scripting references at the moment to read the file into
the spreadsheet.
-----Original Message-----
How are you currently reading it in to the spreadsheet?



-----Original Message-----
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


.

.

Ignore Blanks
 

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



-----Original Message-----
I'm using the filesystemobject from the microsoft
scripting references at the moment to read the file into
the spreadsheet.
-----Original Message-----
How are you currently reading it in to the spreadsheet?



-----Original Message-----
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


.

.

.