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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Is Access or Word running
I'm writing a VBA class module that both Access 2000 and Word 2000 will use. How do I detect if it's Access or Word that's running the code? I want to conditionally compile code based on which one is running it. #If (Access is running) Then Dim shRegistry As New WshShell strInstallPath =...- DocPoster
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
GetObject with IE doesn't work
Searched tons of threads and MS KB articles, but can't figure out why I'm having this problem. Others have posted the following code, but they don't seem to get the error message 429, "ActiveX component can't create object" like I do. Dim appIE As Object Set appIE = GetObject(...- DocPoster
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Determining if Autocomplete tooltips for Autotext is on
In the AutoText settings in Word (Tools menu, AutoCorrect, AutoText tab), there is a “Show AutoComplete tip for AutoText and dates” checkbox. I want to check this setting in VBA, but there doesn't seem to be a property for it. I checked the AutoTextEntry, AutoTextEntries, and even AutoCorrect...- DocPoster
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
