Recent content by Lourry

Thank you again Loomah! Thanks for letting me know how to modify the code to make it unique if the decision was made to show less data. However, when I run the program, I receive: Run-time error '1004': ShowAllData method of Worksheet class failed Then it highlights the .ShowAllData line in...

Yes it worked! Thank you Loomah! Is it easy to show on the result page which datasheet it came from? Perhaps just add the name of the datasheet to the first cell of each row in the "Results" page so the datasheets are not modified? Again, thanks a lot for your Excel expertise! -Lory

Is there a way to only insert the row once to "Results" if the value happens to be in more than one column but the same row? Thanks for your help!

OH, i changed it to a string and it worked! Also, I changed lookat:=xlWhole to lookat:=xlPart so it does not match whole value in cell. THANK YOU SO SO MUCH LOOMAH!! :-)

Thanks Loomah!! Yes i am looking for the search data anywhere in the dataset not a specified column. Is there a way to put that code in a button_click()? I tried to do that but it seems to complain about the "ByVal Target as Range". Thanks again for your help.

Hi, Just want to clarify that the search toolbar is basically a cell where the user types in the "string" they want to search for in the data worksheets within the workbook. Thanks again, Lory

Hi, I have a large excel workbook consisting of 2 worksheets (which later on we may add more). Is there a way to have a search toolbar on the first worksheet letting the user type in a search string that will query all the rows in data worksheets and display it in the "results" worksheet...

Hi, I have configured my SSG520 to send a SNMP trap when it detects a link down, however, the trap that is sent looks like: Enterprise: .1.3.6.1.4.1.3224; Generic: 2; Specific: 0; Variables: [1] mgmt.mib-2.interfaces.ifTable.ifEntry.ifIndex.4 (Integer): 4 [2]...

Thanks a lot ArkM!!!

Hello all, Will anyone be able to give me a list of all the commands that I can use with HTTP 1.1 servers? (example: GET) Thanks a lot. Lory

THanks SantaMufasa!! It works perfectly now. Thanks again : )

The script works...however, there is still a couple problems. Since my table has about 200 columns, my select statement is very very long. I cannot do select * because I need the fields in a specific order. So I've got this SELECT statement that looks like: SELECT 'BAND "'||field1||'"...

Thanks JaggieBunnet and SantaMufasa for your quick replies! Yes, this is exactly what I need. Thank you so much. I'll give this a try and if I have further questions I'll let you know. Thanks again :)

Hello all, I'm new to Oracle and need to output all the records from an Oracle table to an ASCII file. The problem is I need to format the ASCII file in a certain way... Each record has to start with the word BAND in uppercase letters then the first name field, last name field, address field...

Thanks Craig0201 and Ed2020!! :) It works perfectly! You guys are genius! Thanks again for all the help.