Excel sheet selector tool.

For Flowcode users to discuss projects, flowcharts, and any other issues related to Flowcode 7.

Moderator: Benj

Post Reply
gdt
Posts: 71
Joined: Thu Aug 10, 2017 2:04 pm
Has thanked: 25 times
Been thanked: 36 times
Contact:

Excel sheet selector tool.

Post by gdt »

Hello body,
I've tried many times to use the Microchip online selector (http://www.microchip.com/ParamChartSear ... nchID=1005#) but the page is very slow to me so I've created an excel macro to easily build an offline sheet.
You can download and modify if you need.
Here is step by step my procedure:

1) From the link above, thick "Show All Specs" , download the excel file in csv format and save as Flash.csv in a directory C:Temp where you also have to download the attached file Microchip_FLASH_Format.xltm.
2) Run Microchip_FLASH_Format.xltm and enable contents.
3) Alt-F8 and you will see a Macro Update_Flash that you have to run.
4) Click on Yes to save the file without Macro and in the Temp directory you'll have a file Microchip_FLASH.xlsx that you can filter as you need to shrink your search.

Should you not to trust the Macro, you can Modify before to execute just to see what it does.
It's important to use the above names for files and directory otherwise you have to modify the macro.
I hope you find of interest.

Regards
Giuseppe
Attachments
Microchip_Selector.zip
(1.19 MiB) Downloaded 231 times

Post Reply