During the last several weeks, I have undertaken an effort to automate a huge process within our department, which will save an enormous amount of time and resources in the future. This has been facilitated via tagsets.excelxp. This component of created multiple worsheets within spreadsheet in mass has been accomplished, albeit the inability to automate the creation of the company logo on the worksheets.
The process then involves having our customers fill in the spreadsheets, predominantly with dates. The issue I am having now is the invokation of the macro specified in the subject line. The macro works fine. The issue is how the dates get imported. They all get imported as a date with the time stamp appended but in CHARACTER format which looks like:
2009-01-12T00:00:00.000
... thus rendering my dilemma.
Can anyone suggest how to remedy this issue? Is there any part of the macro, created by SAS, that can be changed to accomodate this?