Search results for query: *

PHV, Perfect thank you. I tried that without the ,1 and it failed and then I confused myself even more. Thanks again

Hello, I need some help with my HTA. It creates a tsv file on the users desktop named "username" inventory.tsv using text entered. A second button creates an outlook email. The problem I am having is adding the tsv file as an attachment. Please explain how I can add the atachment using...

Thank you very much. That will do exactly what I need.

Hello, I found an almost perfect code for what I need here http://www.tek-tips.com/viewthread.cfm?qid=1519130 I need to search 1000's of documents for 1-800 phone numbers ( 5 different ones)and change them all to 1 new one. How can I modify this code with either wild cards or by placing all of...

Hello, Need some help please. I have 4 hta files that scan print server and filter results to only show printers for your city. They themselves work OK. What I would like to do is create a form in vb 2010 express and have a button for each city. When the button is clicked I would like it to...

Thanks Skip. will post it there

Hello, Need some help please. I have 4 hta files that scan print server and filter results to only show printers for your city. They themselves work OK. What I would like to do is create a form in vb 2010 express and have a button for each city. When the button is clicked I would like it to...

Thank you very much that is exactly what I was looking for. A Star for you

Needs some help adding to script please. I have users that get attachments in outlook on a daily basis. All of them have the exact same name. Once they hit the 100 attachment outlook gives an error and they cannot open any more with that name. Outlook stores the attachments in a randomly named...

Skip Watch window did not display anything However I changed Sheets(Split(r.Hyperlinks(1).SubAddress, "!")(0)).Range("B4").Copy to Sheets(Split(r.Hyperlinks(1).Name, "!")(0)).Range("B4").Copy and it works perfectly Sub Macro5() Dim r As Range With Sheets("TOC") For Each r In...

Skip. post 2 above the try this one works. it goes to each hyperlink and gets data and pastes it. I just have to end the loop when it hits a blank cell in column C. the second one, 1 post above errors with Runtime error 9: subscript out of range on line...

Skip. OK here is what is happening. macro is not following the hyperlink but is copying cell value from TOC sheet B4. happened to be same value as target in hyperlink.

Thanks again. Sorry for late reply. This works for target in C7. but it does not get cell value from target in C8 C9 and so on. If I am not explaining properly please let me know.

Skip, Thanks for response. The code you posted runs with out displaying an error but there is a small issue. It only pastes the value for from the first target into Column G. This is what the results look like Column C Column G test1 1 test2 1 test3 1 Test4 1 And...

Hello. I have a spreadsheet that gets added to weekly. the workbook has a table of contents page with hyperlinks to worksheets in book TOC sheet list worksheet names as hyperlinks starting in cell C7. I have a macro that will follow hyperlink and copy cell B4 from target and paste it on TOC...

Thanks Skip and kjv1611. I have never been disappointed with this site or its people.

Yes I did but could not get it to work in formula. kjv1611 link put me in the right direction. I just need to add another column, probably because I am a noob and just hacking my way around. I am heading to book store this weekend so I can do some reading. Thanks to both of you for helping

Needs some excel help please. I have a formula that will search column G looking for a city. when it finds city I need it to put a mailto hyperlink in column f. Here is what I have =IF(ISNUMBER(SEARCH("Albany",G:G )),"mailto:email1@123.com ","")&IF(ISNUMBER(SEARCH("CINCINNATI",G:G...

Thank you I will post there

Needs some excel help please. I have a formula that will search column G looking for a city. when it finds city I need it to put a mailto hyperlink in column f. Here is what I have =IF(ISNUMBER(SEARCH("Albany",G:G )),"mailto:email1@123.com ","")&IF(ISNUMBER(SEARCH("CINCINNATI",G:G...