Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formating Excel

Status
Not open for further replies.
badrion

badrion

Programmer
Jul 16, 2001
34
US
I have a program that reads an Excel spreadsheet looks for a field with a "Y" flag and then exports it to a text file. Problem is: the excel file has all the fields set to General, but if a dealer changes their partnumber to a full numeric 12345, I have it reading it as a string thru VB but it doesn't, it reads it as a null field and errors out. I've tried trim, mid, cstr and can't seem to get it to work.
HELP!
 
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Read Excel Sharepoint File
Replies
0
Views
244
Swi
Swi
Niki_S
  • Locked
  • Question
How to read an excel file using VB 6?
Replies
17
Views
568
strongm
strongm
Niki_S
  • Locked
  • Question
Error in Excel/VB6 function: "Constant expression required"
2
Replies
31
Views
896
strongm
strongm
Niki_S
  • Locked
  • Question
How to read excel with a gap in vb 6? 1
Replies
2
Views
221
Niki_S
Niki_S
Niki_S
  • Locked
  • Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
358
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top