Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro code to update File Properties

Status
Not open for further replies.
DanAuber

DanAuber

IS-IT--Management
Apr 28, 2000
255
FR
Hi there,

I want to run some code that picks up whatever is in Cell A1 on sheet1 and then uses this as the File Property: Category. If I do this while running a record macro it doesn't write the code. Can anyone help ?

Thanks

Dan

 
Sort by date Sort by votes
A starting point:
Code: 
ActiveWorkbook.BuiltinDocumentProperties("Category") = ActiveSheet.Range("A1")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
CTRL + BREAK from second macro button
Replies
5
Views
316
strongm
strongm
remeng
  • Locked
  • Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
272
dhookom
dhookom
feipezi
  • Locked
  • Question
How to make a recorded Excel macro (convert a text file to a Workbook) more efficient?
Replies
11
Views
310
SkipVought
S
Kymenglish
  • Locked
  • Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
186
strongm
strongm
remeng
  • Locked
  • Question
If obsolete - deactivate all but one macro
Replies
6
Views
186
mintjulep
M

Part and Inventory Search

Sponsor

Back
Top