Search results for query: *

Hi, I'm trying to do a simple drop down, styled by CSS which looks uniform in IE and Firefox. Here is a sample page www.puresoft.co.uk/select.htm. For some reason the Firefox browser seems to want to make the drop down have a 3D border. How can I remove this look, so its flat, like the IE...

Guys, Thank you for your replies. The input string is about 50 characters long. I'm trying to interface a PIC microcontroller. I have comms going from the PC to the PIC, but not the other way around. I have done some further tests and it appears to be an issue with my string input not being...

Hi, I have written some code which seems to trip up, can anyone tell me why this deosn't work? input_string = MSComm1.Input input_string_holder_array = Split(input_string, ",") Label1.Caption = input_string_holder_array(2) It seems that when the array value is passed over to...

Thanks for the pointers, I found out that to convert a string to a number to use the Val() function, then coupled with the Round() function that does what I need. Here is an axample for anyone interested. Dim order_total As Double temp_hold_values() As String order_total = order_total +...

Hi, I am pulling text from a file (csv export from a shopping cart) in string format, some of this text naturally represents numbers. I'm having problems assigning these strings as numbers to a new variable, originally defined as a variant. Here is the line along with my variable declarations...

I just re-read the variable declaration help and see that variables on the same line, separated by commas, do not get the same type as the last defined, rather they get the default variant, unless specifically defined otherwise. I didn't realise that was the case, thanks for the info, I'm on my...

Thanks, Thats gotten me a couple of lines further :-) However I'm now having problems with assigning this captured line from the array to another array (filling it with the split up values form the original line of text), I'm getting type mismatch error for the last line shown: Dim strStripped...

sorry, its defined as: Dim Line_holder_array() As String

Hi, I have a simple loop that seems to cause problems with 'subscript out of range' - I want to read in a text file, line by line and fill it into an array for subsequent reference. Here is the code: m = 0 While Not EOF(1) Line Input #1, Line_holder_array(m) m = m + 1 Wend What's my...

vb5prgrmr, Thanks so much - I was trying something along those lines, but was getting muddled how to structure things properly. I ran the code and had to add just one extra line under the replace line of code section of S = Left(S, (Len(S) - 2)) to chop off an extrs vbNewLine character that it...

Hi, I'm really not getting anywhere :-( I can't seem to open the file read through it and replace the characters as required. I used ultraedit to view the files and see its because I don't have the carriage return character in my csv, just the line feed, that's tripping my routines up, so I...

Hi, I have a csv export file (from a shopping cart system) that when processed raw, gives problems because the end of line character does not appear to be right. It will view fine in Excel, starting new lines as supposed to, its just that when I use the 'Line Input' command on the raw file it...

Thanks Tom, That does the trick! Philip

Hi guys, I'm sure this should be an easy one for you, although I couldn't find an example in some searches on the forum. I have a csv file (from a shopping cart export) I've split up and read into an array holding these values as strings. What I want to do now is test some of them to see if...

ok, got it sorted out. Used the string '&' function to concantenate my array elements together, adding in the required formatting for the csv. Needed to use the Print command as opposed to the Write command. Here is the working code for anyone else dropping by: Private Sub Command1_Click()...

John, Thanks again for replying, but I want to be able to write record by record (or alternatively a line at a time created from my cusomised records) becuase I'm going to have to insert custom fileds that I'm creating dynamically from the original file content - I'll be doing things like...

John, Thanks for the reply, and the example using the direct access of Excel, though I'm wanting to do it avoiding the need for Excel to be installed and resident on the host PC, since I will want to offer this finished conversion utility to other users who have the same shopping cart system...

Thanks for the pointer. I have now got the basics nearly there, though I am still having two problems: 1) I am using the write statement, reading from the array, but the field outputs from each line are placed on successive lines, rather than one long line - see snippet below. What ways are...

Hello Guys, I have a website order export as a raw csv file with the various fields one after the other, with a separate line for each order. I want to read in that file, assigning each field to a variable so I can analyse those variables and then do some manipulations, before finally exporting...

Yes! That works wonderfully. Thank you so much. I had almost given up on it! Rick, send me an e-mail so I can send something to you... Regards, Philip Hodgers. philip@puresoft.co.uk