Universal Data Exporter ASP Support Product Page

Old Resolution Not Found: Overflow: 'CLng'

Reported 14 Oct 2013 16:07:57
1
has this problem
14 Oct 2013 16:07:57 Duane Hume posted:
Multiple years of posts do not provide a resolution to the issue of the Clng error on Line 890 of the Excel writer script. Here's what I get...and I just bought this extension:
Microsoft VBScript runtime error '800a0006'

Overflow: 'CLng'

/ScriptLibrary/ExcelWriter.asp, line 890
All fields being exported are text fields and are specified as such on the Advanced tab. Though I have several 12 character fields that appear to be numeric and may be the source of the problem, the script needs to NOT interpret these as numbers.

I read through all of the previous posts on this issue and though it was marked as resolved, I can find no resolution. Please provide.

Replies

Replied 15 Oct 2013 14:25:02
15 Oct 2013 14:25:02 Duane Hume replied:
Though I did find a solution mentioned (replace CLng with CDbl) and it does eliminate the overflow error, I should NOT have to modify the code of extensions I purchase. This is just not in keeping with what I have come to expect from DMX Zone over the years...

Reply to this topic