Guest.Visitor
01-01-2003, 01:18 AM
I request for help regarding problem being faced when using VBA Macro to download data from AS/400 to Excel2000. Part of the code is given below: --------------------------------------------------------------------- Sub stuffcells(sSql As String, sSheetname As String, sCell As String) Dim colcount As Integer Dim colidx As Integer Set cmmysqlcmd.ActiveConnection = CNMYAS400 cmmysqlcmd.CommandText = sSql Set rsmyrecset = cmmysqlcmd.Execute() -------------------------------------------------------------------- In the variable 'ssql' if we use "." (dot) to separate library and filename, then we get error message = EXCEL caused an invalid page fault in module MSADO15.DLL at 015f:1f449851. And if we use "/" to separate library and filename, then we get error message = Run-time error '-2147467259 (80004005)' CWBDB0036 - Server returned SQL Error. Kindly help. Regards: Tahair Quraishi