Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't assign to Array .GetRows in Excel 97
Thank you in advance. Any help will be extremely appreciated; this project has to be turned in by tomorrow.
I developed a macro in Excel 2000. It uses ADO to connect to Access db. Before handing it in to the client I wanted to test this macro in office 97 (that's the version client is using). The following line of code generates compile error "Can't assign to array" : arrCountries = oRSCountries.GetRows() arrCountries is Dimmed as Dim arrCountries() As Variant The same code works under Excel 2000. I have ADO 2.7 Reference check in both. What can be the problem? Any ideas? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't assign to Array .GetRows in Excel 97
did you try ?
dim arrCountries as variant (note it's NOT dimmed as an array) keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "?B?TGVubg==?=" wrote: Thank you in advance. Any help will be extremely appreciated; this project has to be turned in by tomorrow. I developed a macro in Excel 2000. It uses ADO to connect to Access db. Before handing it in to the client I wanted to test this macro in office 97 (that's the version client is using). The following line of code generates compile error "Can't assign to array" : arrCountries = oRSCountries.GetRows() arrCountries is Dimmed as Dim arrCountries() As Variant The same code works under Excel 2000. I have ADO 2.7 Reference check in both. What can be the problem? Any ideas? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't assign to Array .GetRows in Excel 97
It did it!!!! Thanks a lot KeepItCool, you are Cool!
"keepITcool" wrote: did you try ? dim arrCountries as variant (note it's NOT dimmed as an array) keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "?B?TGVubg==?=" wrote: Thank you in advance. Any help will be extremely appreciated; this project has to be turned in by tomorrow. I developed a macro in Excel 2000. It uses ADO to connect to Access db. Before handing it in to the client I wanted to test this macro in office 97 (that's the version client is using). The following line of code generates compile error "Can't assign to array" : arrCountries = oRSCountries.GetRows() arrCountries is Dimmed as Dim arrCountries() As Variant The same code works under Excel 2000. I have ADO 2.7 Reference check in both. What can be the problem? Any ideas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign Values to array | Excel Discussion (Misc queries) | |||
Can't assign to Array .GetRows in Excel 97 | Excel Programming | |||
How do I assign values to an array? | Excel Programming | |||
Possible to assign an array to a SeriesCollection | Excel Programming | |||
ADO slow recordset getrows | Excel Programming |