[mso] Excel 2000 and Outlook 2000 questions

Hi,

I have two questions about Office 2000 from work.

Firstly, we've got a database system that uses Excel for its front-end that 
allows us to send emails through Outlook to acknowledge the receipt of an 
application document. This works fine, except that the security settings we 
have in place pop up warnings about the Excel code attempting to access the 
address book (which it has to do to verify email addresses), and then another 
about an application attempting to send email on our behalf: is this OK?

This is very annoying as Outlook 2000 is configured to make us wait several 
seconds at the second prompt before it enables the "Yes" button - this also 
eats into the time period that we can set for Outlook to grant access to the 
address book to Excel (max. 10 minutes it seems).

Is there any way that we can get rid of this? We'll probably have to ask the IT 
administrators to remove it, but if there is a way, that would be great.

Secondly, I've written some code in Visual Basic 6 in Word that allows us to 
complete a letter document with information from the same Excel database as 
mentioned above. Everything is fine, except that I need to express a time 
period as a number of years, and using a calculation formula, I can get the 
period in days.

I know that I can use the YEARFRAC worksheet function to do this in an Excel 
worksheet, but I can't get access to this function from VB. I've tried getting 
references to the workbook's add-ins, after checking that the Analysis Toolpak 
is available, but to no avail.

Any advice on this would be greatly appreciated.

Luckily, I don't need answers until Monday evening at the latest: we've got a 
bank holiday in the UK on Monday.

Thanks in advance and best regards,
Richard Watt
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: