Search results for query: *

Hello, I want to be able to calculate the IRR (Internal Rate of Return) and Net Present Value (NPV) for some figures entered into Web Page - Someone must have done this before. Anyone got any Code that does this? Thanks Grippen

Hi, I have designed froms in Outlook, each with VBScript code attached. I did this in Outlook 2000 and everything was working fine across the organisation. Some people have moved to Outlook 2002 and now the script will not run - can I\how do I tell the users to change security settings to get...

Hi, I have designed froms in Outlook, each with VBScript code attached. I did this in Outlook 2000 and everything was working fine across the organisation. Some people have moved to Outlook 2002 and now the script will not run - can I\how do I tell the users to change security settings to get...

Hi, I'm using VBScript in Outlook to write to a rich text email Message Body. How do\Can I format the fonts, Underline, add Bold change colors etc. in the VB Script Code? Code I have works fine and looks like...... MessageString = "Text I Want to Add" & chr(13) & "More Text on...

Hi, I'm using VBScript in Outlook to write to a rich text email Message Body. How do\Can I format the fonts, Underline, add Bold change colors etc. in the VB Script Code? Code I have works fine and looks like...... MessageString = "Text I Want to Add" & chr(13) & "More Text on...

Has anyone got example VB Script Code that will show a Progress Bar on a Custom Outlook Form while the form executes a long For...Next loop? Thanks

Hi, I have some Code in Outlook to output data to Excel. I get the data out fine with the code below and the user is left with viewing the Excel Sheet as I want. However, when the User closes the Excel File, Windows says that Excel is still open (even though I can't see it) and I get errors on...

Hi, I have been designing a Form in Outlook. I have added an area to add notes and attachments to the form - trouble is the "Notes" field I add in design mode has an attachment already in it (i'm still in design mode at this stage). I can't work out any way to select the attachment...

Hello, I have an Excel File attachment in an outlook form. What I want to know is how I open it using VBScript in the form so I can see it and manipulate values etc? I want to do something like.. Set myFinModel = Item.Attachments(1) myFinModel.Display end sub but...

Hello, Simple One - I have an Excel File attachment in an outlook form. How do I open it so I can see it and manipulate values etc? I want to do something like.. Set myFinModel = Item.Attachments(1) myFinModel.Display end sub but ".Display" and ".Open" are not...

Hello, Nobody seems to know how to help me - can you? - Third time lucky! I am in an Outlook Form and want to set a User_Defined Field to a value in another "DataRecord" form. The DataRecord Form is an Outlook "Document Form" based on Excel. The code below works - it...

Hello, I have an Outlook "Office Document" Form collecting data from people. The "Office Document" form is based on Excel. Does anyone know how to write data to cells in the form from data in another Form. Putting it another way, I want to do as the code below does, but...

Hello, I have an Outlook "Office Document" Form collecting data from people. The "Office Document" form is based on Excel. Does anyone know how to write data to cells in the form from data in another Form. Putting it another way, I want to do as the code below does, but...

Hi, I'm in an Outlook Form. I want to log a new Contact in a form ("IPM.Contact.Account contact") and put it in a sub-folder and then set some of the fields within the Contact record based on data in the form I'm in. I create the form OK by using .... Set oCurrentFolder =...

Hi, I'm having problems with VB SCript Sintax with using "Restrict" function. I get the following script working fine.... Set myItems = oCurrentFolder.Items Set myRestrictItems = myItems.Restrict ("[Op Title] = 'Fred'") For Each myItem In myRestrictItems myItem.Display...

Hi, I'm having problems with Sintax with using "Restrict" I get the following script working fine.... Set myItems = oCurrentFolder.Items Set myRestrictItems = myItems.Restrict ("[Op Title] = 'Fred'") For Each myItem In myRestrictItems myItem.Display Next But I want to...

I have created a new form called "ConData", containing details of personal contacts in Outlook. The new form is based on the default "Contacts" form but has extra "user-defined" fields added. I want to open "ConData" from a commandbutton in another form...

Question: I have a VBScript Sub-Routine in Outlook that's taking 30secs or so. How do I change the mouse pointer to an hour glass while my PC is thinking? - I'm sure this questions been asked before but I can't find it!

Try this - 1) Delete the rows you want to delete. 2)Ensure highlighted cell is back to the top of the page 3)Create a copy of the sheet (i.e. Menu: Edit\Move or Copy Sheet...\Create a copy) The newly created identical sheet should now not refernce the croll bar down to row 65000

I have created a new form, containing details of personal contacts in Outlook. The new form is based on the default "Contacts" form but has extra "user-defined" fields. Question: What's the easiset way I can "import" my existing contact data (currently in the...