Search results for query: *

Solved! (posting for posterity's sake) http://skp.mvps.org/updtlinks.htm Found this great add-in from Shyam Pillai to do just what I wanted. It's the one I referenced in my original post but I had to drop my macro security settings to accept it. Works like a charm now!

Skip, I do know how to automatically update my link every time the .ppt file is opened. However, I want the automatic updates to happen while the .pps file is running. I don't want to have to open and close the file each time to show an update. This should be an ongoing, stand-alone process. Rob

This one has been throwing me for a loop... I know how to properly embed a linked range of Excel cells into a PPT slide AND how to set the link to automatically update whenever I open the file. However, what I'd LIKE to do is to have a .PPS file constantly looping with slides that would show...

FOUND THE ANSWER! (and it was much easier than I thought) ALTER PROCEDURE autoemail_scheduledemails @scheddate datetime = null AS SET NOCOUNT ON IF @scheddate IS NULL BEGIN SET @scheddate = GetDate() END Select numMsgSchedule, txtMsgTitle, txtMsgSubject, ...otherstuff... From...

Thanks for the follow up question. The UNION brings together two lists: individual e-mail and category e-mail. I want to send out both. The INSERT is to only record the category e-mail (the ones with the 0).

Hello all! I used to be a big contributor in the MS Office section and you all have helped so much in this, the ASP, and HTML/CSS forums that I can't begin to thank everyone. I'm trying my hand at a complicated (for me, anyway) SP. I've searched through the site and haven't found anything that...

Tony, You were right! I prefer your elegant solution over mine. Rob

Tony, Thanks for the clarification! I wasn't aware of any of the functions in the Analysis TookPak. Unfortunately, your month to month check falls apart on week 17 of this year: 17 4/24/2005 4/30/2005 That week does have the end of month in it but the two months are identical. Rob

I've put together a quick solution for you: Try this: Cell A1: 1/1/2005 (this will be used to establish the beginning of the year) Week # Week start Week end EOM? 1 1/2/2005 1/8/2005 FALSE 2 1/9/2005 1/15/2005 FALSE 3 1/16/2005...

Here ya go: Column B Column C Column D 59Q7A =LEFT(B1,FIND("Q",B1,1)-1) =MID(B1,FIND("Q",B1,1),100) 255Q66OTH 255 Q66OTH 271Q67OTH 271 Q67OTH 277Q72 277 Q72 302Q78A 302 Q78A Of course, you'll then have to do a copy...paste special, values to get the new columns to keep their...

Combo, Now that's what I'm talking about!!!! It worked perfectly albeit a warning comes up about opening files. It is EXACTLY what I wanted. Thank you very much. Star for you. Rob

I'm creating a .pps table of contents for several documents in our project. The hyperlinks I've created do a great job of opening the documents in their native application so we can work on them. The problem I have is all of the .ppt documents open in presentation mode instead of "working"...

On these same lines, is Word the only option for getting HTML capable emails? I like using Century Gothic as my font and I've got a banner in my signature line. Could I still get this without the burden of Word? I've got the same problem of crippling resources. Thanks, Rob

Now, I'M looking forward to your solution as well! I came up with one but it would only have the repeating columns on the right hand side as necessary. Not terribly elegant. Rob

Just had to share this. We were a BlackBerry-only shop after a long fight to get them in here. I lobbied for, and won, entry of the Treo. Now we use both systems with BES and GoodLink, respectively. Whenever we have to add new licenses for BES, we're completely shut out when we use up our...

Well, now! I think we've hit upon one of the two reasons I come to Tek-Tips! I'm a giver on this forum as I can make Excel (and others) sing. I'm a taker on the ASP and HTML forums as I'm a dummy whose wife asked him to make a major website (with no training). I, too, love putting out others'...

Skip, I think this needs to be it's own forum: Data Cleaners Anonymous My current job has nothing directly to do with data cleaning (I'm in Purchasing) but I really enjoy when I have to grab mangled up data from SAP and make sense of it. My co-workers can't or will spend a week working on it...

Funny enough, yes. I've even got my three year old into the habit. Splash! "Oops!!!" "Daddy, we have an opportunity!" I used to be a management consultant and it amazed me as to how many days were spent by "smart-types" in cleaning data. There's huge money in the time alone. I gave them a...

Skip, Sorry to imply that the customer hadn't been served at all. I was just looking for raw data to carve through (as ugly as it may be). I just have a "thing" for cleaning up really ugly data. I prefer it to be right in the first place but I get a thrill out of fixing broke stuff. :) (Maybe...

Darren, Could you post some sample code for me to take a look at? What do you have and what do you want it to look like? This patient is bleeding. We can't just tell them they shouldn't be. Let's stop the bleeding AND teach them how to do it the right way. I don't believe in telling someone...