Add variable to excel header
Posted on 2010-09-07
This question is related to the question that BlueDevilFan just answered yesterday (see "related solutions")... Is there a way to add a variable to an excel spreadsheet header?
For example, in the vbscript that bluedevilfan created yesterday, a spreadsheet is opened, and some information from outlook is populated in the spreadsheet (based on a date that the user provides). Is there a way to display the day of the week, and date in the left side of the header? Of course the day of the week/date would not always be "today's date" -- it would be the date that the user provides for the vbscript.
For example, if the user provides 9/7/10 to the existing vbscript, is there a way to populate the excel header with: