Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ActiveX component can't create object
You need a reference in your code to Microsoft Scripting Runtime: C:\WINDOWS\System32\scrrun.dll- kriss669
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Which DLL or OCX controls DoCmd.TransferSpreadsheet
This will also occur if you try to save the spreadsheet with an .xlt extension rather than .xls- kriss669
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
