This is my first post on Excel forum.

I want a macro that will open a without fiile in a folder and convert without format file whose name is like "cognos.701Z%27%5d&SA=propEnum,properties&ITEM=data&EA=&SS=queryOptions,options&dataEncoding=MIME&ES=&EM=" to Excel (.xlsx). Save excel file in same folder and delete above file.

Please help on this.

Thanks,