Sytze de Boer wrote: <snipped>> There are 180 columns in the spreadsheet
Good Lord! That's really wide! > Column 7 references Stock Code > A stock code may be alpha "ABCD" or alpha numeric "ABC123" or numeric > "123456" > There may be 200 Rows > If the cell is alpha or alphanumeric, all is fine. > But if comes across a numeric cell, it treats it as blank > > Column 8 only references numeric data. It leaves it blank at all times. > The column next to is also numeric, its blank > Column 1 is also only numeric data. It imports this fine Have you tried some automation code to treat/flag the column as non-numeric? > > Bottom line. > If no-one else here can help, does anyone know if I can approach Craig Boyd? I'm sure you can email him at his website. You've got his url. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
