M
mapoart
Hi,
I'm using pure ASP/VBscrtipt.
I spent days to looking for solution to take hyperlink cell from excel
file.
i'm using this kind of think to take the data out...
sFileConnectionString = "Driver={Microsoft Excel
Driver .xls)};DriverId=790;Dbq="&sFilePath&";DefaultDir="&sDataDir&";"
sFileSQL = "SELECT * FROM [" & sSheetName & "$]"
dim oFileCN, oFileRS, aSourceData
set oFileCN = server.createobject("ADODB.Connection")
oFileCN.Open sFileConnectionString
set oFileRS = oFileCN.Execute(sFileSQL)
if not oFileRS.EOF then
aSourceData = oFileRS.getRows()
end if
oFileRS.Close
set oFileRS = nothing
oFileCN.Close
set oFileCN = nothing
Could you help me?
Mapo
I'm using pure ASP/VBscrtipt.
I spent days to looking for solution to take hyperlink cell from excel
file.
i'm using this kind of think to take the data out...
sFileConnectionString = "Driver={Microsoft Excel
Driver .xls)};DriverId=790;Dbq="&sFilePath&";DefaultDir="&sDataDir&";"
sFileSQL = "SELECT * FROM [" & sSheetName & "$]"
dim oFileCN, oFileRS, aSourceData
set oFileCN = server.createobject("ADODB.Connection")
oFileCN.Open sFileConnectionString
set oFileRS = oFileCN.Execute(sFileSQL)
if not oFileRS.EOF then
aSourceData = oFileRS.getRows()
end if
oFileRS.Close
set oFileRS = nothing
oFileCN.Close
set oFileCN = nothing
Could you help me?
Mapo