- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
3 Posted Topics
 | For 243 combinations it is utterly undue considering the language implications. Of course, if you intend to perform the validation 1 billion times over 243 combinations the matter would be different. For all intents and purposes I would select C for speed, VB or VB.NET for ease or direct validation …  |
| | Can you not simply replace wb.save() to wb.saveas() and specify the proper file ending as CSV instead. Let the internal workings do what it does best. Just be ware of naming syntax with / and \ depending on system and so on. Then again, if you're going to convert it … |
| | Skip the part CByte() for type casting unless you do recalculation of the values in the string as ASC returns an Integer and at times could cause an overflow in the byte array. [code] Public MyByteArr() As Byte Public Sub StringToByteArray(ByVal s As String) Dim i As Long ReDim MyByteArr(Len(s) … |
The End.