Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by AlaskanDad

  1. AlaskanDad

    Automatic link updates in PPT Show?

    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!
  2. AlaskanDad

    Automatic link updates in PPT Show?

    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
  3. AlaskanDad

    Automatic link updates in PPT Show?

    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...
  4. AlaskanDad

    SP Newbie: Select (mult records) and Insert (same mult records)

    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...
  5. AlaskanDad

    SP Newbie: Select (mult records) and Insert (same mult records)

    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).
  6. AlaskanDad

    SP Newbie: Select (mult records) and Insert (same mult records)

    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...
  7. AlaskanDad

    Excel: Finding last day of the month in a calendar week

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

    Excel: Finding last day of the month in a calendar week

    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
  9. AlaskanDad

    Excel: Finding last day of the month in a calendar week

    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...
  10. AlaskanDad

    Splitting an Excel column into 2 columns

    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...
  11. AlaskanDad

    PowerPoint hyperlink to open PPT NOT as PPS

    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
  12. AlaskanDad

    PowerPoint hyperlink to open PPT NOT as PPS

    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"...
  13. AlaskanDad

    Outlook Performance

    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
  14. AlaskanDad

    EXCEL - Keep 1 row and 2 columns on every print page

    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
  15. AlaskanDad

    Lauding GoodLink!

    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...
See more

Part and Inventory Search

Back
Top