How do I get it right
Hi,
I'm intigued as to what I am doing wrong, I really like your solution so would like to get it right if you can help?
I started with a blank workbook, started VB editor and under the project tree for "VBAProject" I right clicked and selected insert module, I then copied the code (and eventually my additional Private Type code piece) into the module. This created a "Modules" folder in the project tree and a new "Module1" under it.
I could then access the macro from the macros icon in the excel ribbon. I saved the workbook as "macros.xlsm". When I have this workbook open I can use the macro in any other open workbook. It clears the active sheet and then creates the table with filenames.
I am using a "sparklines.xlam" add-in which appears in the project tree albeit separate and above the "VBAProject" item (wish I could attach a screen shot!).
Thank you for the solution!
Samir
