Macro not working correctly, what did I do wrong?

This is the code I am using, the problem is that it does not process the file it gives me "Complete 0 files where processed" It seems not calling the other function, but when I change its the name it ask for it and when I change the path for the files it gives me "could not find the path". When only running the "call subfunction" it works fine but together with Sub "OpenConvertSave" it does nothing... something I am missing

Sorry for the trouble...

Please Login or Register  to view this content.

The code looks fine, you created a folder on the D:\ drive called 2010 and put your CSV file in there?

You can go the OPENCONVERTSAVE macro in the VBEditor and press F8 to step through the code one line at a time, switching back and forth between the editor and the workbook to see what occurs, hovering your mouse over key variables after they become initiated to see what the current value is...

As you F8 through the code, does a CSV from your folder get opened?
Does your JusteraRutter macro begin and let you step through that?
Where does it fail to do what you expect as you step through?

Sure, that means there is nothing in the fName variable.

That means your macro looked in "D:\2010\" and found no csv files in there. Check your spelling of the folder name, Excel can't find a CSV file in the folder you've specified.

Originally Posted by JBeaucaire

Sure, that means there is nothing in the fName variable.

That means your macro looked in "D:\2010\" and found no csv files in there. Check your spelling of the folder name, Excel can't find a CSV file in the folder you've specified.

Could the problem be with the letters "å, ä, ö" in the filename?
I dont see anything wrong with the paths or csv files see attached printscreen...

Thanks

Change the filename from "ö" to "o" but that did not help so that is not the problem...

I don't know. I tried the macro on my C:\2010\ folder and it works, your system is not resolving the path properly it appears.

Note: the code to make the \Imported folder inside the CSV file folder occurs BEFORE the line of code that is failing, but I don't see the folder in your screen shot. So it appears your system is having problems addressing that folder/drive.

Windows Server does have significant security, something I can't comment on.

You have a working macro and know where to use it so that it does work, I think that's all the help I'll be able to give. Someone with expertise in Server securities may have some advice for configuring your server, probably a different forum.

Meanwhile, you have a tool you can use, albeit on a drive you'd prefer not to.

Please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

I didn't think you were complaining. No worries.