text to columns problem

V

Vato Loco

I have an invoice that uses "text to columns" to help it update. I use
macro to paste data from a network application to the invoice. When
close down Excel, even though I have it saved, it no longer separate
the test when pasted. Anyone know why?

Thanks, Vat
 
B

BrianB

A guess in the absence of other replies :-

Normally with a text file we have to SaveAs a .xls workbook otherwise
the file remains a text file. I wonder if this is affecting your data.
 
Top