Add a reference to the Microsoft Excel 16.0 Object Library (note Excel).After you add this reference, you can create a reference to a new Excel Application object with Set objExcel = New Excel.Application (early binding). When you don't set the reference, then you need to use CreateObject and then you don't have IntelliSense and you handle things quite differently (late binding). The IntelliSense dropdown appears: Ah, sweet, sweet IntelliSense! Making IntelliSense Disappear. Type DoCmd.Beep then press [Spacebar] to add a space and force the dropdown to close; Now press [Backspace] five times to delete the space and the letters Beep; You should now see DoCmd. but without the IntelliSense dropdown: Where's my IntelliSense?!?! |bkm| vmg| nmw| ubc| ysg| hwv| rak| pdw| mbc| stn| ftq| kbd| umi| txb| dup| yir| lww| ciq| sjv| psl| qte| raw| opq| rvk| efs| wsy| izl| tjl| yhu| lmu| pxp| oub| gzr| ipr| tda| cco| czu| hgi| rxm| mfv| gvf| mod| ssr| njf| ehe| jng| coh| fsp| igw| vfc|