Recent content by analyst1411

Annihilannic, Thank you. I will look into this.

Hi, I need to connect to a remote system and download files from a certain directory. I already have a script that does just that, however, for each file I download, I have to move it to an ARCHIVE directory on the remote system. Can anyone help in giving me tips on doing this? Can this be done...

Hi, I created a macro to import a csv file and I want to do some extra calculations on the imported data. My problem is that the file I import gets updated and the number of records change and I need to perform the calculations on valid lines (those with data) only. How do I specify the range...

Thank you all for your valuable comments. I now have something to start with. If succeeded, I will share the final code/macro here. Thanks again, Analyst1411

Hi, I need to import multiple CSV files from a specific folder having the same naming format (for example: ABCA1G.TXT, ABCB1G.TXT, ABCC1G.TXT,...) into excel. I also need to import each file into its own sheet in the worksheet and name that sheet as the file that was imported. Does anyone have...

Hi, My company is looking for a solution that will enable us to archive raw EDI data and search withing that data for specific documents using special keys, e.g. ISA number, BOL number, PO number, etc. The tool can be seperated from the translator or integrated in a complete solution. However...

Hi, Does anyone have the mapping for this document and is willing to share? Thank you, analyst1411

Hi, We are using Qualedi as our EDI translator and our current system level is 16.347. Qualedi just posted a few updates to the program and I would like to know if anyone in this forum is using Qualedi, and if there are such, what are the major changes that are included in these updates (17.00...