Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
is it possible to change/add properties on the 'Custom' tab using VBA? (I've tried to use the VB recorder, but it comes up empty.) Similary, is it possible to read from the 'Contents' properties tab using VBA, e.g. the names of worksheets or named ranges? Context: I'm still not satisfied with the speed at which I get certain basic info from an Excel file and I was hoping that by writing such info to the file's properties and reading them without opening the workbook I might speed things up. Many thanks for your help on this. Regards, JVL |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reading values from a closed workbook | New Users to Excel | |||
Excel document propeties in Cells | Excel Discussion (Misc queries) | |||
Reading Cells is the same workbook different tab | Excel Discussion (Misc queries) | |||
Reading a worksheet from a specified workbook | Excel Worksheet Functions | |||
Reading from a closed workbook | Excel Programming |