Search results for query: *

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

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?

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

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

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?

Does anyone know how to apply and remove filters against Outlook folders using VBA?

Can anyone tell me how I can tell when the last key pressed was the Delete key in Excel? I can work out when a change has occurred and when a selection has changed via Worksheet_Change and Worksheet_SelectionChange, and can deduce which cell I was in before if the last key was the enter key...

Does anyone know how to use the KillTimer API? I have used SetTimer API from User32.dll to create a timer object on a VBA form, but when I hide the form the timer still keeps running. I tried calling KillTimer with the timer object's windows handle (returned by SetTimer) as the first...

A question for the windows gurus. Is there a way to interrogate windows to find out what windows are currently open? If I know the title of a window, I can access it using the VBA.Appactivate method. However, what if I don't know it's title? Is there a way to obtain the title of all...

I'm using Excel97, and have created a floating command bar containing a single control. I want the control to display as Text Only (Always), not as an icon. Any ideas? This is what I have so far: Application.CommandBars.Add Name:="Module1", Position:=msoBarFloating, temporary:=False With...

Has anyone managed to successfully change district using Connector in MIMS OE 4.3.1.2? My code runs successfully and produces no errors, but I end up in the same district that I started in. I have provided a bit of my function code. Am I doing something wrong? ...... Private Function...

Does anyone know how to retrieve Purchase Order and Purchase Order Item data via Connector? I've had a look at all the available classes and it has me stumped. You can retrieve purchase order data related to requisitions using the "REQUISITION.Fetch" and...

I frequently use Excel VBA to drive non-GUI MIMS (via MSOs and the 3270 emulator's Screen object), and would like to access data through the use of MSKs instead of scraping it off the screens. Can anyone point me towards some documentation on how MSKs work and how I can access them through VBA...