Hi there, I've also had problems with DownloadManager dll. Sometimes it would get the progress bar as if it's going to download the file, but then it would just freeze and I had to kill the process. The larger the file, the more likely it is to happen. I also had problems before registering the dll ...

Humm, I got it =].

Thanks for explaining and for your help with that.

Much appreciated!

I'm actually using both methods, hagchr. If I use MS to remove the CRLF, it will remove the ones at the end of the lines too, therefore it will break the .csv file. I ported the Excel Macro to MS just to make sure the script will work wherever it's run i.e: in a place where we don't have the macro s...

Sorry, that did work. I had to remove the quotes from vbCrLF, though.

However, the code in MS takes way longer to be executed than the Excel Macro.

In Excel it takes like 1sec. in MS it takes like 15secs or so.

Do you know the reason?

Thanks again!

Many thanks, hagchr, the code looks much more organized, however, I'm getting the same error at the same line =/.

Any idea?

Hi again, I thought: "why not get this Excel Macro and run it within Macro Scheduler?", so I'm trying to convert it to be run in MS, but I'm getting the following error: :-2147418111 Line 24, Column 12 Code: VBSTART Option Explicit Dim xlApp Dim xlBook Dim xlCalculationManual Const xlSaveChanges = 1...

Thanks, Marcus. Here's how I solved it (in case someone needs it): VBSTART Dim xlApp Dim xlBook Const xlSaveChanges = 1 Set xlApp = CreateObject("Excel.application") Set objWorkbook=xlApp.Workbooks.Open("C:\Users\vilmondes\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB") Set xlBook = xlApp.Wo...

Hello, I've created a global Excel macro to have at available at all times. When you created a global macro, its name is PERSONAL.XLSB! MacroName . I used the below code, but it won't run the Macro: Let>csvFile=c:\temp\streams\toyota-export.csv Let>csvNewFile=c:\temp\streams\toyota-export-modified.c...

Many thanks for looking into this, Marcus.

The .csv file is still broken when I open it with Excel 2013. Therefore, the Open+Save trick won't work for me (neither the XLGetSheetDims, XLGetCell etc).

Are you using another version of Excel?

Thanks JRF, but that pattern does not exist =/ These LF s are in a column which contains user generated content, so the LFs can be anywhere within whose quotes. Sometimes I have one LF followed by another one. I can't think of any RegEx to solve that because when MS reads the file, it becomes a sing...

I opened up the .csv file using Notepad++ and found that the culprit are LF s, however, if I remove all LF s using the below code, it will also combine the last item of a row with the first item of the next row because there are no comma separating them: ReadFile>vFile,vData StringReplace>vData,LF,,...

Ah, one more question, please: Do you think it would be possible to call a PHP file that would fix the csv and then Macro Scheduler goes through the rest of the script? Just wanted to know if it's possible to call another script and then get back to the .scp. So the steps would be: - Macro Scheduler...

Humm, I got it. I had already contacted the tool's tech support hoping that they can fix that.

In the meantime I'll test this code you suggested and let you know the result.

Thanks a lot for your help =]

Hi JRL, Thanks for replying. The thing is that one of the columns (which should not be the last column) contains CRLF or something like that which is making it to be the last column, so the row is being broken into 3 rows, i.e: the full row should have 30 columns, but now I have 3 rows, one with 12,...

Hello, I guess the best way to trim CRLF from a given CSV column would to use SQL statements, however, as per the http://www.mjtnet.com/blog/2009/10/05/more-on-reading-and-writing-csv-files/ article, it's not possible to UPDATE (not sure whether it's already possible). So the question is: what's the...