Re-2: OT: Any VBS, VBA, Excel specialist out there who might help?

2009-08-10 Thread runrev260805
Hi Ken, no problem. I suspended the work on that. Thanks for your help. After replacing the line as you suggested it works. Regards, Matthias Original Message Subject: Re: OT: Any VBS, VBA, Excel specialist out there who might help? (07-Aug-2009 16:17) From:Ken Ray k

Re: OT: Any VBS, VBA, Excel specialist out there who might help?

2009-08-07 Thread Ken Ray
as i already said, i am not very familiar with vbs. My script is from a book. So i am not sure, how and where in the script i should pass this parameter. Regards Matthias Oh geez, Matthias I haven't had a chance to read the list for a while and just caught this, so I hope I can

OT: Any VBS, VBA, Excel specialist out there who might help?

2009-07-23 Thread runrev260805
Hi, i am having a problem converting a CSV file to excel. My csv file is structured like this: ArtNr;ShortDescription;LongDescription;ManufactureNo;EAN;Manufacturer;Stock 010002;Epson LQ300; Epson LQ 300 Matrixdrucker;C11C63800;8715946316949;Epson;2 There is no text delimiter. The field

Re: OT: Any VBS, VBA, Excel specialist out there who might help?

2009-07-23 Thread Ken Ray
My csv file is structured like this: ArtNr;ShortDescription;LongDescription;ManufactureNo;EAN;Manufacturer;Stock 010002;Epson LQ300; Epson LQ 300 Matrixdrucker;C11C63800;8715946316949;Epson;2 It looks to me like the problem may be in the Workbooks.OpenText call. Here's the params according

Re: OT: Any VBS, VBA, Excel specialist out there who might help?

2009-07-23 Thread Matthias Rebbe
Thanks Ken, as i already said, i am not very familiar with vbs. My script is from a book. So i am not sure, how and where in the script i should pass this parameter. Regards Matthias Am 23.07.2009 um 19:20 schrieb Ken Ray k...@sonsothunder.com: My csv file is structured like