Brian Hman wrote:
> The problem here is that when I look at the data in excel some of the
> columns that are decimal are coming across as dates. Should I be doing
> something in the vbscript to ensure that the columns'
Yes, I think you should "do something".
Take a look at microsoft's "Text or number converted to
unintended number format in Excel", found here: http://support.microsoft.com/kb/214233
It explains what could be causing unintended formatting.
There is also a suggestion(s) as to how to explicitly set
the formatting you want. That can be done is script,
as well as "manually". If you are uncertain as to how
to do it, turn on your macro recorder and then go through
the manual process. Save the macro, and look at the (vba)
code. It should be fairly easy to convert vba to vbs.
You got questions? WE GOT ANSWERS!!! ..(but, no guarantee
the answers will be applicable to the questions)