Macro to batch change file type

[dwain]

Hi all,

I am trying to create a macro that batch changes xls files to csv files.. i have come up with this so far..

Please Login or Register  to view this content.

the only problem is that I get an error on GetFoldername..

hope someone can help sort this

Thanks

[dominicb]

Good afternoon dwain

the only problem is that I get an error on GetFoldername..

GetFolderName isn't a standard Excel instruction - it's actually a UDF (user defined function) whcih is called which uses API's (Windows system files) to show the standard Windows "select folder" gadget. You need to include the UDF code within your module. The code for this is fairly prevalent on the internet, but here's a link for you :

http://www.gtwiki.org/mwiki/index.ph...=GetFolderName

HTH

DominicB

[dwain]

Thanks , sorted