Search results for query: *

Aviatrix and Skip, wow, thanks so much for your help. I've been modifying your code a bit Skip to get it where I want to be, and using the Record Macro option (what a fun tool) to really get things moving. One problem that seems to be coming up is that I can't merge cells very well, and I...

So, here's a problem for anyone who wants to tackle it. I'm wondering about the feasability of it, so let me know if you think its possible and any suggestions on how to approach it. I have a Template in Word 2002 that has a number of form fields for a user to enter data. There are set...

Thanks for the help Skip, but I'm still confused as to what value Vlookup is returning, since you're assigning the resulting value to vLookupVal and at the same time passing it into the function.

Yeah, I have a reference to Excel in my VB Editor. I tried making up a searching function of my own, but its painfully slow... Set cell = Excel.Cells For Each cell In Range("A1", "A6000") If cell.Value = lookThisUp Then finalcount = counter + 1 MsgBox...

Sorry for my late reply, I've been out of town. Wow, thanks for the help with this. I've got a problem though. I get the error "Method or data member not found" related to Application.VLookup. Is that something I need to write myself? or is it in the Excel object dll? Also...

Hello All, I've got what might be a really easy question. I don't know how to do it, so I really have no clue. I have a word document that is a form for the user to fill out. When they enter in data in one of the text fields, a macro runs. I would like the macro to do a few things: 1...

got it!!! if(numVal == searchNumber) instead of if(numVal = searchNumber) it was assigning the value rather than checking. Thank you SOOOO much for your help though, I never could have figured that one out on my own.

it has something to do with the line: nameVal = rootnode.childNodes(i+1).childNodes(1).childNodes(0).childNodes(0).nodeValue; when I took away the i+1, it always comes back with "name1"

hrm... having a little problem. It always finds the same value. I went back and used your example. If you set "searchNumber" = 3, it still comes back with name2, if you use 1, still name2.

wow... thank you so much Mark, you've been awesomely helpful! I'll give that a shot. Thank you again.

yeah, I guess I got a little excited typing! the cells are not specified by cellA or cellB, but there is more than one cell in each row. <worksheet> <table columncount=5> <row> <cell> <data>number</data> </cell> <cell>...

the xml doc was created by excel, but I'm cleaning it up now to get rid of all the useless crap. right now it looks like: <worksheet> <table columncount=5> <row> <cell> <data>number</data> </cell> </row> <row> <cell>...

thanks for the idea skills. The only problem is that i have upwards of 5000 entries to search through... and as much as I'd love to type those all in.... I was hoping to use my existing xml or excel document to contain the files.

Hey everybody, I'm rather new to the game, and I'm looking for a way to search through an XML document and display specific contents to a webpage. Basically the setup is I have an XML &quot;worksheet&quot; that has a bunch of columns and rows set up. I have one webpage where the user submits...

I have a list of information in an Excel worksheet that I would like to put into a drop down menu in Word. I know that there are subroutines that can be run when a user clicks, or changes, or does some other event, but how do I put stuff into the menu using code? Thanks for any help