Dim XyzRs As ADODB.Recordset
What happens to this line of code? In another workbook, it is okay to Dim inside userform, but why I am not able to Dim inside a module (a different workbook, XyzRs is also a different name)?
Thanks.
Dim XyzRs As ADODB.Recordset
What happens to this line of code? In another workbook, it is okay to Dim inside userform, but why I am not able to Dim inside a module (a different workbook, XyzRs is also a different name)?
Thanks.
Set a reference to the "Microsoft ActiveX Data Objects x.0 Library" .
Check or Add an Object Library Reference
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks