Convert multiple Unknown file type to .xlsx format

%3CLINGO-SUB%20id%3D%22lingo-sub-1537984%22%20slang%3D%22en-US%22%3EConvert%20multiple%20Unknown%20file%20type%20to%20.xlsx%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1537984%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20convert%20a%20unknown%20file%20type%20to%20.xlsx%20format%20in%20VBA%20or%20any%20tool.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIts%20basically%20a%20unzip%20file%20downloaded%20from%20Outlook%20mail.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22devs91_0-1595410749041.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207086i3D49B63BC3A326D9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22devs91_0-1595410749041.png%22%20alt%3D%22devs91_0-1595410749041.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20me%20how%20can%20i%20sort%20this.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EDevS%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1537984%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1538033%22%20slang%3D%22de-DE%22%3ESubject%3A%20Convert%20multiple%20Unknown%20file%20type%20to%20.xlsx%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1538033%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F736109%22%20target%3D%22_blank%22%3E%40devs91%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3EIf%20an%20unknown%20file%20is%20to%20be%20opened%20in%20Windows%2C%20Windows%20often%20asks%20which%20program%20should%20be%20used%20to%20open%20it.%20Here%20you%20can%20also%20use%20the%20file%20extension%20to%20specify%20the%20program%20with%20which%20the%20file%20is%20to%20be%20opened%20using%20the%20file%20extension.%20There%20is%20a%20suggestion%20list%20or%2C%20alternatively%2C%20any%20program%20can%20be%20selected%20using%20the%20%22Browse%22%20button%20(see%20figure).%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Open%20with%20-%26gt%3B%20Windows%20program%20selection%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20But%2C%20this%20is%20relatively%20cumbersome%2C%20especially%20if%20you%20may%20want%20to%20use%20a%20different%20program%20for%20a%20file%20type%20and%20do%20not%20always%20want%20to%20remember%20the%20check%20mark%20at%20%22Always%20open%20file%20type%20with%20the%20selected%20program%22.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Often%2C%20however%2C%20you%20get%20a%20file%2C%20mostly%20exported%20from%20some%20system%2C%20which%20you%20can%20definitely%20open%20via%20Excel%2C%20but%20which%20do%20not%20have%20one%20of%20the%20usual%20file%20extensions%20such%20as%20CSV%2C%20XLS%20etc.%20As%20an%20example%2C%20the%20%22MUSTER.%20DAT%22%2C%20which%20is%20popular%20in%20the%20SAP%20environment%2C%20may%20be%20mentioned%20here%20for%20exported%20lists%2C%20which%20are%20then%20later%20to%20be%20processed%20in%20Excel.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Of%20course%20it%20is%20also%20possible%20to%20use%20Excel%20as%20the%20file%20type%20for%20*%20.%20DAT%2C%20to%20search%20for%20the%20correct%20application%20via%20the%20website%20endungen.de%20or%20to%20view%20the%20file%20from%20Excel%20by%20opening%20it%20in%20Excel.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20find%20out%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

 

I am trying to convert a unknown file type to .xlsx format in VBA or any tool.

 

Its basically a unzip file downloaded from Outlook mail.

 

devs91_0-1595410749041.png

 

Please help me how can i sort this.

Thanks

DevS

 

 

1 Reply

@devs91 

If an unknown file is to be opened in Windows, Windows often asks which program should be used to open it. Here you can also use the file extension to specify the program with which the file is to be opened using the file extension. There is a suggestion list or, alternatively, any program can be selected using the "Browse" button (see figure).

Open with -> Windows program selection

However, this is relatively cumbersome, especially if you may want to use a different program for a file type and do not always want to remember the check mark at "Always open file type with the selected program".

Often, however, you get a file, mostly exported from some system, which you can definitely open via Excel, but which do not have one of the usual file extensions such as CSV, XLS etc. As an example, the "MUSTER.DAT", which is popular in the SAP environment, may be mentioned here for exported lists, which are then later to be processed in Excel.

Of course it is also possible to use Excel as the file type for * .DAT, to search for the correct application via the website endungen.de or to view the file from Excel by opening it in Excel.

 

I would be happy to find out if I could help.

 

Nikolino

I know I don't know anything (Socrates)