Forum Discussion
Device Magic to Excel
One thought: try just importing into an existing workbook the data from that Device Magic exported file.
On a very regular basis I export data from Fidelity having to do with an investment portfolio. It is exported as an Excel file (although the option exists to do it as CSV). I open that file in Excel, but then use the FILTER function to import the data into a formatted section of my active workbook where I can do whatever analyses of specific elements I wish.
The single formula that brings in the data is this:
=FILTER([filename.xls]Worksheet1!$A$5:$T$99,[filename.xls]Worksheet1!$A$5:$A$99<>"")
Which basically says FILTER in all rows and columns from $A$5 to $T$99 where the cells in column A are not blank. "filename" only contains data in a subset of those rows, I just specify up to 99 rows to allow for the file to change in size.
In other words, I don't try to format the exported file; I do all the processing and formatting on a stable workbook sheet into which I've brought (via that formula) the data from the exported data.
So that's just a possibility. (Or did I misunderstand what you wrote, and that's actually what you've been trying?)
- Thanks. I was trying for a very simple solution. I have resorted to opening my template worksheet and then the DM excel file and copy and pasting the data from the DM file to the template file and renaming that file.
