Wednesday, June 27, 2007

Office 2007

As I use Office 2007 1 will document issues that arise, new ways of doing things.



VBA Macros



Opened my access database that apparently contains VBA macros. You are given an option




  • Help Protect

  • Enable Content

Note if you enable content then it is for this session only. The next time you open the database you will be prompted again.


There seems to be two ways of handling this



  • Changing access permisions for all macros

  • Adding the location of your database to the trusted locations

Macro Permissions



  • Disable all macros without notification

  • Disable all macros with notification (default setting)

  • Disable all macros except digitally signed macros

  • Enable all macros

Trusted Locations


Here you can add the directory location of the database. This would then give you greater security because you could leave the default macro permissions but not have to enable macro permissions for databases that you had created or came from a trusted location.


There is an option not ticked and not recomended "allow trusted locations on my network". Why I am not sure. However I save my database to a network drive so that it is backed up.


** Will have to investigate further **

Star Stream

The shortcut for this would have to be changed from office to office12

Would also need this to be a trusted location

System Requirements


and processor
500 megahertz (MHz) processor or higher
Memory
256 megabyte (MB) RAM or higher1
Hard disk
2 gigabyte (GB); a portion of this disk space will be freed after installation if the original download package is removed from the hard drive.
Drive
CD-ROM or DVD drive
Display
1024x768 or higher resolution monitor
Operating system
Microsoft Windows XP with Service Pack (SP) 2, Windows Server 2003 with SP1, or later operating system2
Other
Certain inking features require running Microsoft Windows XP Tablet PC Edition or later. Speech recognition functionality requires a close-talk microphone and audio output device. Information Rights Management features require access to a Windows 2003 Server with SP1 or later running Windows Rights Management Services.Connectivity to Microsoft Exchange Server 2000 or later is required for certain advanced functionality in Outlook 2007. Instant Search requires Microsoft Windows Desktop Search 3.0. Dynamic Calendars require server connectivity.Connectivity to Microsoft Windows Server 2003 with SP1 or later running Microsoft Windows SharePoint Services or Office SharePoint Server 2007 is required for certain advanced collaboration functionality. PowerPoint Slide Library requires Office SharePoint Server 2007.Internet Explorer 6.0 or later, 32 bit browser only. Internet functionality requires Internet access (fees may apply).
Additional
Actual requirements and product functionality may vary based on your system configuration and operating system.

Folder Locations and Save Options

Folder Locations set to network drive. Drop autsave time to 5 mins. This will need to be checked for all apps.

Personal Folder

I removed Ofice 2000 from Personal Assistants PC. Installed 2007. When I started up Outlook it automatically migrated the Personal Folder (which must not have been deleted when office was removed) into the new version. However there was now two Personal Folders in Outlook. I just closed one and it was OK. I will need to investigate as she may have imported her backup copy from her network drive without realising it had already been done.

No comments: