Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating Document property values using macro
Hello everyone,
I have a question which has been giving me quite a bit of trouble this morning. First off I need to populate the "metadata" (document properties) for several workbooks and decided that a macro would be the best approach considering we already have one for editing and formating data from other workbooks into a new one(this is the one that needs the "metadata"). My code is as follows: Sub T00() ' StatSumm Macro ChDir "file path" Workbooks.Open Filename:="file path", UpdateLinks:=0 Range("A1:J65").Select Selection.Copy Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Range("K:M").Delete Range("A1").Select ActiveWorkbook.Title = "Blah" ActiveWorkbook.(insert others as needed) = "blah blah blah" ActiveWorkbook.SaveAs Filename:="file path", FileFormat:=xlNormal ActiveWorkbook.PublishObjects.Add(xlSourcePrintAre a, _ "\\S90x02\res\BULLETIN\FY06\Bull0605\Web\t00.h tm", "summary", "", _ xlHtmlStatic, "t00", "").Publish (True) Workbooks("t00.xls").Close SaveChanges:=False End Sub The problem I have is that my method for populating those values doesn't work for Company or Category can some one please help? Mike DeWinter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Intellectual Property of an excel document | Excel Discussion (Misc queries) | |||
Including document property values in Excel headers | Excel Discussion (Misc queries) | |||
Populating word document from userform inputs. | Excel Programming | |||
Stop open file through Document Property | Excel Programming | |||
ReadOnly property of word document not returning proper value. | Excel Programming |