Copying File Properties of Excel Worksheet

  • Thread starter Thread starter serno001
  • Start date Start date
S

serno001

Hello

I want to know if it is possible to enter all the file properties,
Title, Subject Author, Manager, Company Category, key words
from the File>>Properties>>Summary menu and copy these into other
Worksheets automatically.

can this be done with a MACRO or script? Trying to find a way to get
lazy people to fill in these blanks

Serno001
 
Worksheets don't have Properties.

Workbooks have Properties.

Why would you want to copy the same properties data to each workbook?

Wouldn't a lot of those custom properties be unique to its own workbook?

Like Author, keywords etc.

You want all New workbooks to have the Properties of one default workbook?

Open a new workbook, customize the File>Properties as you wish.

File>Save As Type: scroll down to Excel Template(*.XLT) and select. Name
your workbook "BOOK"(no quotes). Excel will add the .XLT to save as
BOOK.XLT.

Store this workbook in the users' XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for File>New or the Toolbar button
New Button or CTRL + n

WARNING................Do not use File>New...Blank Workbook or you will get
the Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.


Gord Dibben MS Excel MVP
 
Back
Top