Search results for query: *

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 =...

Thank you so much; that's exactly what I needed. I'm going to post a solution to my problem using some of that code. What I really wanted to do was look for an existing browser with a specific URL and automate it; i.e., hook into it rather than open a new browser.

Perhaps the PUT statement will work better for you. This example is from Excel VBA help (though I added the .txt extension). I tried it and all records were written without linefeeds, although it's unreadable in Notepad. Type Record ' Define user-defined type. ID As Integer Name As...

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(...

Perfect! Thanks so much. (And thank YOU, Microsoft, for putting it in such an intuitive place.)

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...