Recent content by RonRepp

Hi all: I know OL isn't everyone's fave...mine either. I pieced together some nifty code (below) that takes the msgs from an OL2010 folder, saves it to the hard drive in whatever format the client wants, and then saves the attachments in a separate file. From there, it logs all filenames in...

Instead of just inserting the row into SS, why not create a Stored Procedure with the Trigger built into that? Then your XL form calls the Stored Procedure and provides the data to insert. SQL Server will do the rest. Ron Repp If gray hair is a sign of wisdom, then I'm a genius. My newest...

Combo: Thanks for your reply. Yes, that is what I planned to do, because I need the data to show on the spreadsheet like a crosstab report. I'm given a spreadsheet with the email addresses (all in Column A) and the client wants all the opt-out statuses in line with the email address. I did...

Hi Skip: Thanks for the thought. I don't use the Watch Window a lot, but I was using the Immediate Window with Debug.Print on the variables to see them change. I removed them before I posted the code. I did take your advice, though, but still prefer the Immediate Window. You've helped me too...

Hi all: I'm having a slight logic problem that I cannot figure out. What the client wants is to find out if the email address is active or not, and since the DB may (and does) contain more than one status for opting out, I'm forced to return the values width-wise instead of like a table. The...

PHV: Good call on the resume err remark and the trim statements. Ron Repp If gray hair is a sign of wisdom, then I'm a genius. My newest novel: Wooden Warriors http://www.repproductions.net

Thanks, PHV: I put the error resume remark in there because there is a row (somewhere in the 22 pages) that makes the code halt. I've tried trapping it, but it just takes me to the Next k remark. Ron Repp If gray hair is a sign of wisdom, then I'm a genius. My newest novel: Wooden Warriors...

Hi, Skip: I've tweaked it some, but am beginning to believe that I need to add more arrays. I'm not good w/arrays, but... The code--when this was originally posted--would take the first paragraph and insert it into a row of Excel. Not really what I wanted, since I wanted it setup in a NACSZ...

Current Resident Current Resident Current Resident 629 MAIN STREET 618 MAIN STREET 123 MAIN STREET MONTELLO WI 53949 MONTELLO WI 53949 MONTELLO WI 53949 I have a list in Word (above) that my client wants me to put into Excel. The problem is that it isn't setup on a label...

Excellent. Thanks Skip. I think I should stick with writing over coding. Ron Repp If gray hair is a sign of wisdom, then I'm a genius. My newest novel: Wooden Warriors http://www.repproductions.net

From Dictionary.com: wend [wend] verb, wend·ed or ( Archaic ) went; wend·ing. verb (used with object) 1. to pursue or direct (one's way). verb (used without object) 2. to proceed or go. Thus, you are "going" "while" something is happening. You could also have used something like this: (old...

Skip: Sorry, I missed the last portion of what you said. I replace the <li> tags with • before it ever hits the slide. Same with the other tags like <li=small circle> tag. This HTML is in Excel, and w/help from PHV, Combo and StrongM, actually could paste the HTML on the slide, but it's not...

Here you go. I eliminate the <li>, <ul> and their end tags before it goes onto a PowerPoint slide. <li><b>Paint Condition</b> - Check the condition of the paint on each drum. Reject the drum if it needs to be painted <li><b>Dents</b> - Check the number and depth of dents on each drum. As a...

dgillz: PHV is correct. The .bof means "beginning of file"; the .eof means "end of file". The .MoveNext moves the recordset to the next qualifying record. Ron Repp If gray hair is a sign of wisdom, then I'm a genius. My newest novel: Wooden Warriors http://www.repproductions.net

Hi, Skip: I want to find the HTML tags (<b>, </b>) and then bold the text between them, then remove the tags. It only works for the first instance. After that, it bolds substrings that don't have the tags. There may be several instances of BOLD within the text. Ron Repp If gray hair is a...