Datadownload

[Guest.Visitor]

Tahair, It's not necessary to post a problem more than once, if someone knows the answer or can help, they will. If the original post becomes stagnant (unanswered more than a week later, you could follow up to the original and ask for any ideas). Bill

[Guest.Visitor]

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

[Guest.Visitor]

You can try putting the library name in the ODBC setup and then just reference the table name in the SQL statement. The odbc driver allows for multiple libraries to be referenced.