I'm trying to find the row and column of a checkbox within a table. When I click on the checkbox, I want to know what row and column I am in. Any ideas?
I build an db just like that and then some! Here is my function:
Function getLoggedOn(sComputer)
On Error Resume Next
counter = 0
If sComputer <> "" Then
If ping(sComputer) = True Then
Set objWMIService = GetObject("winmgmts:{impersonationLevel=impersonate}!\\" &...
haha. error occurs on the sourcedoc.Close statement. I kinda of have it figured out by opening the document visible=false and readonly=true. Not even using sourcedoc.close anymore. Hopefully it doesn't cause any issues down the road.
Word 2010
Hi, in my VBA I'm opening a external word doc to get some text:
Set sourcedoc = Application.Documents.Open(sFile)
Once I get the text, I try to close this document:
oFFld("Text2").Result = sourcedoc.Range
sourcedoc.Close
I'm getting an error message "Runtime error 4198. Command...
I have a textbox. I want it to trigger on lostfocus, copy text from another word document, paste into a field or replace a designated text pattern in current document. I have it working using a command button click but textbox lostfocus does not work. And you are right, it seems like a focus...
I've got some VBA code to copy and paste in word. Using a button and the click event, this code works wonderfully. Using a textbox and the lostfocus event, the code errors out at Selection.HomeKey saying "Method 'HomeKey' of object 'Selection' failed". When I comment out Selection.Homekey, the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.