Universal Data Exporter ASP Support Product Page
Export to excel error"O verflow: 'CLng' /bluedot/ScriptLibrary/ExcelWriter.asp
Asked 11 Nov 2013 17:20:55
1
has this question
11 Nov 2013 17:20:55 Alejandro Mucino posted:
I added Export to excel and I get this error when the page loads:Microsoft VBScript runtime error '800a0006'
Overflow: 'CLng'
/bluedot/ScriptLibrary/ExcelWriter.asp, line 890
How to fix ?
Replies
Replied 11 Nov 2013 17:31:22
11 Nov 2013 17:31:22 Alejandro Mucino replied:
This is the code thats generated and causes the error. If I delete it from the page it works fine.
<%
' Universal Data Exporter ASP 1.14
' Type: excel
dim GeneralInfo
Set GeneralInfo = New dmxExcelExporter
GeneralInfo.ExcelType = 0
GeneralInfo.ScriptFolder = "../../../ScriptLibrary"
GeneralInfo.RowBgColor = "#FFFF66"
GeneralInfo.EvenRowBgColor = "#FFFFFF"
GeneralInfo.LineSize = 0.3
GeneralInfo.LineColor = "#000000"
GeneralInfo.StripHtmlTags = true
GeneralInfo.UseHeader = true
GeneralInfo.HeaderFont = "helvetica"
GeneralInfo.HeaderFontColor = "#FF0000"
GeneralInfo.HeaderFontSize = 12
GeneralInfo.HeaderBgColor = "#33FF99"
GeneralInfo.HeaderBold = false
GeneralInfo.HeaderItalic = false
GeneralInfo.HeadersOnAllPages = true
GeneralInfo.FontName = "helvetica"
GeneralInfo.FontSize = 12
GeneralInfo.FontColor = "#000000"
GeneralInfo.CellBold = false
GeneralInfo.CellItalic = false
GeneralInfo.TableRowHeight = 10
GeneralInfo.Download = true
GeneralInfo.SaveCopy = false
GeneralInfo.FileName = "GeneralInfoXP"
GeneralInfo.SourceRecordset = ContactsFiltered
GeneralInfo.SourceFieldsString = "UserId,UserId,50,C,L,0,T,UserType,UserType,50,C,L,0,T,FirmId,FirmId,50,C,L,0,T,EmployerId,EmployerId,50,C,L,0,T,LastNm,LastNm,50,C,L,0,T,FirstNm,FirstNm,50,C,L,0,T,DobD,DobD,50,C,L,0,T,SSN,SSN,50,C,L,0,T,Email,Email,50,C,L,0,T,Nationality,Nationality,50,C,L,0,T,NiStatus,NiStatus,50,C,L,0,T,ExpiresOnD,ExpiresOnD,50,C,L,0,T,Docstatusstat,Docstatusstat,50,C,L,0,T,NIVMaxStatus,NIVMaxStatus,50,C,L,0,T,I94DateD,I94DateD,50,C,L,0,T,I94,I94,50,C,L,0,T,I797Date,I797Date,50,C,L,0,T,I797,I797,50,C,L,0,T,EadDate,EadDate,50,C,L,0,T,Ead,Ead,50,C,L,0,T,ApDate,ApDate,50,C,L,0,T,ApNum,ApNum,50,C,L,0,T,Iap66Date,Iap66Date,50,C,L,0,T,Iap66,Iap66,50,C,L,0,T,GcDate,GcDate,50,C,L,0,T,GC,GC,50,C,L,0,T,I20Date,I20Date,50,C,L,0,T,I20,I20,50,C,L,0,T,PpExpireOnD,PpExpireOnD,50,C,L,0,T,PpNum,PpNum,50,C,L,0,T,PobCountry,PobCountry,50,C,L,0,T,Employer,Employer,50,C,L,0,T,Attorney,Attorney,50,C,L,0,T,PobCountry,PobCountry,50,C,L,0,T,archivedcont,archivedcont,50,C,L,0,T,contactstatus,contactstatus,50,C,L,0,T,Docstatusstat,Docstatusstat,50,C,L,0,T,Docstatdesc,Docstatdesc,50,C,L,0,T,Dswg,Dswg,50,C,L,0,T,VisaExp,VisaExp,50,C,L,0,T,VisaType,VisaType,50,C,L,0,T,VisaStatus,VisaStatus,50,C,L,0,T"
GeneralInfo.doExport
%>
<%
' Universal Data Exporter ASP 1.14
' Type: excel
dim GeneralInfo
Set GeneralInfo = New dmxExcelExporter
GeneralInfo.ExcelType = 0
GeneralInfo.ScriptFolder = "../../../ScriptLibrary"
GeneralInfo.RowBgColor = "#FFFF66"
GeneralInfo.EvenRowBgColor = "#FFFFFF"
GeneralInfo.LineSize = 0.3
GeneralInfo.LineColor = "#000000"
GeneralInfo.StripHtmlTags = true
GeneralInfo.UseHeader = true
GeneralInfo.HeaderFont = "helvetica"
GeneralInfo.HeaderFontColor = "#FF0000"
GeneralInfo.HeaderFontSize = 12
GeneralInfo.HeaderBgColor = "#33FF99"
GeneralInfo.HeaderBold = false
GeneralInfo.HeaderItalic = false
GeneralInfo.HeadersOnAllPages = true
GeneralInfo.FontName = "helvetica"
GeneralInfo.FontSize = 12
GeneralInfo.FontColor = "#000000"
GeneralInfo.CellBold = false
GeneralInfo.CellItalic = false
GeneralInfo.TableRowHeight = 10
GeneralInfo.Download = true
GeneralInfo.SaveCopy = false
GeneralInfo.FileName = "GeneralInfoXP"
GeneralInfo.SourceRecordset = ContactsFiltered
GeneralInfo.SourceFieldsString = "UserId,UserId,50,C,L,0,T,UserType,UserType,50,C,L,0,T,FirmId,FirmId,50,C,L,0,T,EmployerId,EmployerId,50,C,L,0,T,LastNm,LastNm,50,C,L,0,T,FirstNm,FirstNm,50,C,L,0,T,DobD,DobD,50,C,L,0,T,SSN,SSN,50,C,L,0,T,Email,Email,50,C,L,0,T,Nationality,Nationality,50,C,L,0,T,NiStatus,NiStatus,50,C,L,0,T,ExpiresOnD,ExpiresOnD,50,C,L,0,T,Docstatusstat,Docstatusstat,50,C,L,0,T,NIVMaxStatus,NIVMaxStatus,50,C,L,0,T,I94DateD,I94DateD,50,C,L,0,T,I94,I94,50,C,L,0,T,I797Date,I797Date,50,C,L,0,T,I797,I797,50,C,L,0,T,EadDate,EadDate,50,C,L,0,T,Ead,Ead,50,C,L,0,T,ApDate,ApDate,50,C,L,0,T,ApNum,ApNum,50,C,L,0,T,Iap66Date,Iap66Date,50,C,L,0,T,Iap66,Iap66,50,C,L,0,T,GcDate,GcDate,50,C,L,0,T,GC,GC,50,C,L,0,T,I20Date,I20Date,50,C,L,0,T,I20,I20,50,C,L,0,T,PpExpireOnD,PpExpireOnD,50,C,L,0,T,PpNum,PpNum,50,C,L,0,T,PobCountry,PobCountry,50,C,L,0,T,Employer,Employer,50,C,L,0,T,Attorney,Attorney,50,C,L,0,T,PobCountry,PobCountry,50,C,L,0,T,archivedcont,archivedcont,50,C,L,0,T,contactstatus,contactstatus,50,C,L,0,T,Docstatusstat,Docstatusstat,50,C,L,0,T,Docstatdesc,Docstatdesc,50,C,L,0,T,Dswg,Dswg,50,C,L,0,T,VisaExp,VisaExp,50,C,L,0,T,VisaType,VisaType,50,C,L,0,T,VisaStatus,VisaStatus,50,C,L,0,T"
GeneralInfo.doExport
%>