Excel VB | workbook summary & VBA report
It useful when working with large workbooks to be able to summaries the contents of them and in particular see the file properties without having to look through the file options in windows.
My Excel VBA Addin below does just that -the options are Workbook Summary, Worksheets Summary, VBA Summary and Range Name Summary.
The Worksheet Summary is a bit buggy in Excel 2007 as there is a problem with the .SpecialCells(xlCellTypeBlanks) function:
This behavior occurs if you select more than 8,192 non-contiguous cells with your macro. Excel only supports a maximum of 8,192 non-contiguous cells through VBA macros. Typically, if you try to manually select more than 8,192 non-contiguous cells, you receive the following error message: The selection is too large. However, when you use a VBA macro to make the same or a similar selection, no error message is raised and no error code is generated that can be captured through an error handler.
I have tried to solve this by using the UsedRange function for the sheets albeit I know this won’t work in all places. If you are still using 2003 or 97 you can change this in the code to reflect all cells on the sheets.
Set x = w.UsedRange.SpecialCells(xlCellTypeConstants, 23)
Another note is that if you want to run a summary of the VBA code you need to go into maco security and check the “Trust access to the VBA project object model” (this by default is not ticked and you will be prompted that VBA summary can’t be created).
You’re currently reading “Excel VB | workbook summary & VBA report”.
- Tuesday, August 19th, 2008
- Simon Page
- Artwork (75)
- Design Inspiration (33)
- Design Resources (10)
- Excel (12)
- Filemaker (5)
- Gadgets (26)
- Music (3)
- Photography (3)
- Photoshop (1)
- Press (7)
- Random (5)
- Software (4)
- Video Gaming (15)
- Wallpaper (6)
- Album Cover Artwork Inspiration
- Creative Movie Poster Inspiration
- Criss Cross - iPad and iPhone Wallpaper
- Design Inspiration | typography posters
- Exclusive iPad Wallpaper
- Futurism - Limited Edition Prints
- Geometric Silk Scarves
- Geometric Silk Scarves #2
- Inspiring Gallery of Video Game Concept Art
- International Year of Astronomy 2009 Posters
- International Year of Chemistry 2011 Prints
- iPad HD Retina Wallpaper