Hello,

I am taking information from an Excel spreadsheet
and importing it into a tab delimited text file and
process the information using a VB 6.0 application that
then spits out several different text files. The issue
that I am having is that when I import from Excel to the
text file it also includes blank cell to the right and
bottom of the information that I need. How do I stop this
from happening? The excel sheet will always vary on its
size.

Select entirecolumns to the right of your data and delete them (use the gray
buttons with the column names)

Select entirewors below you data and delete them (use the gray buttons with
the row numbers)

Then save the workbook

This should reset the usedrange

Go to Tools=Goto = Special and select Last Cell.

It should now go to the bottom right corner of your data.

--
Regards,
Tom Ogilvy


"Jim" wrote in message
...
Hello,

I am taking information from an Excel spreadsheet
and importing it into a tab delimited text file and
process the information using a VB 6.0 application that
then spits out several different text files. The issue
that I am having is that when I import from Excel to the
text file it also includes blank cell to the right and
bottom of the information that I need. How do I stop this
from happening? The excel sheet will always vary on its
size.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!