Recent content by ssmgr

Thanks Peter. After I submitted the post, I googled "convert .pps to .ppt" and found the same information you just provided. So simple when you know what to do ..... Steve

Gurus I have been handed a CD which contains a MS-Powerpoint Slide Show (.pps) file. I'd like to be able to edit some of the slides in the .PPS file and put a few of the slides into a new presentation. Is there any way to open a .PPS file in an editable format (in other words, open it as a...

WinblowsMe, I never thought of using Windows API calls to detect the spell checking window. I assume I'll need to declare a variable win_wnd of type long. Thanks once again for your assistance, and have a purple star.

Cluless Chris, I'm using .Display and Sendkeys instead of .Send to avoid getting the XP security alert dialogue box that warns when a program is attempting to send an email. .Display and Sendkeys works fine if there are no spelling errors - the user that's updating Excel will generate...

Here 'tis: Private Sub sendemail(regno As String, unitname As String, surname1 As String, initial1 As String, course1 As String, location1 As String, date1 As String, traincost As Currency, travelcost As Currency, rowno As Long) Dim objol As New...

ClulessChris & Andrzejek, Thanks for the advice. I already had the code to send an email from Excel, and the body of that email contains the contents of various Excel cells. However, I am coming unstuck if the contents of those Excel cells contain words that aren't in the dictionary (such as...

I'd like to be able to send an email from Excel, but don't want the spell checker to fire up. Is there a way to turn spell checking off?

Thanks for the information. I had recently checked the FAQs and didn't see these posts. The third option actually works well so I'll give it a try.

I am attempting to send an email from within Microsoft Office Excel 2003 via VBA. Operating system is XP Professional Desktop. Dim OL As Outlook.Application Dim Folder1 As Outlook.MAPIFolder Dim olMailItem As Outlook.MailItem Dim ToContact As Outlook.Recipient Set OL = New Outlook.Application...

Thanks very much CMP. That's exactly the information I was looking for, and I think it deserves a star. Steve

The online MS-Outlook application allows you to create an appointment in the calendar, invite attendees, and email the invitation. The email actually updates the attendee's calendar. However, I can't work out how to do that in VBA. I can create and send and email using VBA, and I can create an...

Does anyone know how I can find all Distribution and Address lists for a given user? I've been playing around with AddressList / AddressLists and AddressEntry / AddressEntries, but I'm a bit lost. Any advice would be appreciated. Steve

Thanks for that Geoff, I'd never considered doing something as simple as declaring global range variables and setting them to the selected cells. A well-deserved star has gone your way. Steve

Is there any way to detect the last key pressed in a worksheet? I would like to put some code inside a Worksheet.SelectionChange sub to ascertain whether the user pressed Enter, Tab, Left/Right/Up/Down arrows, or clicked on the newly selected cell with a mouse. I see that there are mechanisms...

Does anyone know how to apply/remover filters against Outlook folders using VB/VBA?