That message proves the wrong sheet is selected.
You are opening the CSV file when you open the workbook to load it... wrong. It won't always have time to change to the newly opened csv file before the code starts to run. It is better to have a button on the excel file that opens the csv, thus allowing excel to open and 'settle' before doing anything. The reason it's working on one and not the other is probably down to disk access times, the server being faster.
To get around this, with no guarantees, I've put a DoEvents in after the file loads. This, in theory, will allow it to run. But a button is far better.
Reply With Quote