Search the Community
Showing results for tags 'help'.
So i'm trying to make this macro look up a user id number from the text file and display the name associated to it. If the number doesn't exist, it works correctly. If it finds the number it displays the whole file. Any ideas on how to make it just display the person that is associated to it? Also I want to do the same with acronyms, will the same method still work I appreciate the help Thanks
I am trying to open my different accounts and I have them in order of website link, Login, and Password. I want to create a macro to open all the Links and insert password and emails. However it takes so long to go to each cell to copy that I want to copy the full column and split by new line. Is this possible and if not whats a proficient way to go about this?
Hi all, I am trying to create a macro to help out with work. I have very basic programming knowledge from a few high school classes and I have seen this topic sort of addressed a few times (Cory always brought up Regex), but I want to see if I am not going about this the right way. I have a bunch of text on a web page that gets highlighted with crtl+a and then saved to a variable. I can then read variable and use "if variable contains xyz, variable2 = A. From there I can I just keep searching for key phrases from the text and setting them into new variables. This works fine for things that are "multiple choice" so to speak, but will not work for things like people's names, since it will be completely random what the name is. To get around this, I tried the approach of having the mouse click in selected spots where the words I am looking for will be and copying to clipboard, then setting variable from clipboard. This doesn't work all the time because little discrepancies in the changing web page make it so that I am always off by a few (or sometimes many) pixels. Any ideas here? I was thinking about revisiting my first approach when I just search for phrases in the variable... something like "if variable contains "FIRST NAME: *********" where the ***s are the person's actual name. I would only want to store this info into a new variable though, and not all the extraneous text in the variable. Can this be done? TIA, Mike