View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JVLin JVLin is offline
external usenet poster
 
Posts: 22
Default Reading/Changing Workbook Propeties with VBA?

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