Problem opening files within code

[Dom W]

I am struggling to complete a project with a client; unfortunately he's in Japan whilst I'm in the UK, so we're working remotely.

The code I've written asks for a folder to be selected; it then takes all .csv files that are within that folder, copies the data contained, carries out formatting and saves off each worksheet as a new workbook.

Everything works fine on my computer (PC running Excel 2010).

My client is having variable results. We've traced this to an issue in the "find .csv files" portion of the code.

In an attempt to understand the issue, I modified the code being used to find / cycle through files in order to simply provide a list of files within the folder - in order that he could return this to me and I would at least be able to see what filenames / extensions were present in the folder.

However, it now transpires that when he uses this trial code, regardless of which folder he selects in the "open folder" dialogue, the macro shows the contents of his Desktop folder.

Anyone able to solve my headache and suggest what's going on?!

Code used is as follows:

Please Login or Register  to view this content.

This is modded code from ExcelExperts.com - http://www.excelexperts.com/VBA-Tips...es-In-A-Folder.

[6StringJazzer]

I am not sure why you are getting different behavior on the two systems, but I think it is flawed to assume that the current directory will be changed to the one selected by the dialog. CurDir will return the current directory, and in your client's case it is clearly the desktop, and it is not being changed.

This code will explicitly take the folder selected in the dialog, replacing the original line that I show as commented out:

Please Login or Register  to view this content.

[Dom W]

Face. Palm.

Obvious when you see it - thanks!