Search results for query: *

I build simple business automation macros... I have been through three upgrades with Microsoft Office. With each offers new challenges on how the macros react in the new versions environment. In the past, I have simple set the default functions to the "lowest common denominator&quot...

Help.. I can't figure out why Excel is calculating this time function incorrectly. (see below) Fomrula: Time(Hour(((H14-C14)-(E14-D14)-(G14-F14),Minute(((H14-C14)-(E14-D14)-(G14-F14))),0)*24 C14=8:00 AM D14=10:00 AM E14=11:00 AM F14=2:30 PM G14=3:00 PM H14=5:30 PM the result on Excel is...

In the past I was able to customize my Excel and add new buttons to do repeative tasks. Moreover, when my Excel opened the new buttons would operate on macros that were tied to the application, not a specifc worksheet. I'm trying to recall how I accomplished this... specifically, if I create a...

I'm working on a VBA enabled spreadsheet and was hoping to use ToolTips to offer users help... can anyone offer away to use ToolTips (bubble help info that appears under a button after your mouse rests over it) with VBA.

I wish to setup a button on a spreadsheet that will act as a saveas command. Moreover, I want the button to offer the user the ability to save the active worksheet to a location they dictate. Thanks for any help.

The VBA script to submit an active worksheet through Microsoft Outlook is pretty easy: ActiveWorkbook.SendMail ("Recepiants Email address") Using this command, the activeworksheet is sent as an attachment with the subject of the email as the title of the active worksheet. Problems...

I have looked into data validation, but to tell conditionally that a formula in another cell is an error is proving impossible.

I am working on a spreadsheet that uses formulas. I hopeing there is a function or VBA macro to react if the the cell input causes an error in the formula cell. Moreover, I would love to display a msgbox or bubble notification if the user inputs incorrect iformation into a cell that causes...

I have designed a macro to run in Excel 97 to send an email from Excel to an outlook mailbox. It worked great until we upgraded to Office 2000. The new security alert that notifies users that Excel is sending an email has caused mass problems in my company. Is there any work-around to...

The situation you describe occurs because you have access to more than one profile in MS Outlook. When you use the Visual Basic for Applications document routing capabilities, there is no route method available to automatically select a particular e-mail profile...