Replies

Hi Hans… thanx for getting back to me so soon! I should have known better with the NoCustomization… I already ran into another problem with that… Thank you for pointing this out to me .

Sorry, I’m not getting this Option Explicit… I did type it in at the top of my module, but it gives me the following error: Compile Error: invalid inside procedure.

Private Sub Document_Open()
‘Creates the Numbering toolbar required to run
‘the Schemes module of this template
‘Recorded by Trish Krokosh, May 30, 2003

Option Explicit

Dim oCmdBar As Office.CommandBar
Dim oCmdBarButton As Office.CommandBarButton
Dim oCmdBarPop As Office.CommandBarPopup
Dim oCmdBarSubPop As Office.CommandBarButton
Dim objPicture As IPictureDisp

The procedure I want is Document_Open() or AutoOpen (). The examples which I have seen with Option Explicit change it from a Document_Open event to a General Declaration. How do I declare both?

Hi Hans… thanx over and over again for all your assistance to me!!!
With regard to your feedback:
1. For some stupid reason (I’m tooo inexperienced to figure it out) I cannot set the picture property under the commandbarbutton… I get this error msg: Run-time error ‘-2147467259(80004005); Method ‘Picture’ of object’_CommandBarButton failed.
I have changed the code to read as follows, and continue to have the same error msg that I had last week:

Dim objPicture As IPictureDisp

Set objPicture1 = stdole.StdFunctions.LoadPicture(“c:atk imagesrestartno.bmp”)
Set oCmdBarButton = oCmdBar.Controls.Add(msoControlButton, Before:=11)
With oCmdBarButton
.Picture = objPicture1
.Visible = True
.Caption = “Restart Numbering”
.BeginGroup = True
.OnAction = “RestartNo”
.TooltipText = “Restart Numbering”
End With
I found an KB Article ( http://support.microsoft.com/?kbid=286460%5B/url%5D ) that explains that the IPictureDisp interface cannot be marshalled across process boundaries… I have no clue what this means … So if I create the dummy bar and copyface/pasteface it works fine? Can you explain what I am doing wrong or what this means?
2. I did include the Option Explicit as you suggested… I read up on it and was unaware of it’s importance. The only problem is that the commandbar runs on an AutoOpen event and Option Explicit is stored under general declarations. Should I be doing something different?
3. I did include the CustomizationContext.Active Document as you suggested… I do not want the toolbar to be stored in Normal… only when the template attaches.
4. I did get my msobuttonup/down state working using your suggested Select Case statement (not used before)… I ended up performing a ‘call’ procedure under the Select Case to run the macro for the selected numbering scheme:

Select Case CommandBars.ActionControl.Tag
Case “SchemeArticleNo1”
Call SchemeArticleNo1
Is this correct?

Once again Hans, thank you for all your help… I would be lost without you!

Hi Towana… I’ve included a link to MS KB Article which explains the location of Word’s User/Registry Options… this link will take you to the Summary of Word Options (common ones, ie., autotext, autocorrect, macros, etc.) http://support.microsoft.com/default.aspx?…en-us;289294#17%5B/url%5D
Most of the user’s customization (toolbars, autotext, macros, styles) is found in their normal.dot, with the exception of Autocorrect (the above link explains how to move Autocorrect between computers – networks – end of article) and Custom Dictionary is a file under your profile ApplicationMicrosoftProofCustom.dic.
I usually advise company’s to back up the user’s entire profile before changing the operating system so that much of the user’s customization can be recovered, if required (you do need quite a bit of space to do this!) and then delete after about a month. This type of backup should capture even Windows customization (i.e., Favorites, Desktop Shortcuts, etc.). Copying this information back to the user profile after installation of new OS and Apps will reinforce their previous versions customization.
As for training material, I have yet to find a good book… hopefully someone else out there will suggest something so that I too can use! Good luck… trish

In Word 2002, there is a new feature for the Ruler which is Autohide… it is enabled by unchecking View, Ruler. If you place your cursor near the area where the ruler usually displays, it will appear. This automation occurs when “Provide feedback with animation” option under Tools/Options/General is turned on. If, however, the Ruler is turned on by default, under View, Ruler, then the problem could be due to some corruption in the WordData key in the Registry. Take a look at this article for instructions on recreating the Data key: http://www.mvps.org/word/FAQs/AppErrors/MissingMenusEtc.htm%5B/url%5D
Hope this helps and good luck!

Hi Hans… well I ended up creating a toolbar from code – oh my gosh – I have figured out how to do almost everything, with the exception of this .state = msobuttonup/down/mixed! Cannot believe that this feature has me pickled… I’ve included the code that creates the toolbar which is an AutoOpen event on the template (so when the template attaches, the toolbar is created). The toolbar has customized images on it and I’m creating a ‘dummy’ toolbar to create these images from files (new XP IPictureDisp – member of Stdole library) and the using .copyface and .pasteface to change image (I could not figure out how to include in the commandbarbutton statement)… STILL LEARNING… Anyhow, back to the .state – what I’m looking for is IF the user selects the item on the dropdown menu, I want a checkmark placed next to the item. IF the user selects another menu item, I want the checkmark to move and appear next to the last item that they have selected. I’m also confused if this state is run here or in a different location (as a Function??). I’ve attached the code… If you have any suggestions/ideas with regard to my code, I would love to hear… thanx in advance… trish

There is no way to change the default snooze time. Send your suggestions to mswish@microsoft.com

Go to Tools, Options, Preferences tab and under the Calendar, change the default reminder time to 30 minutes.

Also, when a .pst goes corrupt, usually it has maxed out in size… with the version that you are on Outlook 97 (if I remember correctly – that was a long time ago), the max size for a .pst file is 200,000 KB or 200 MG (in newer versions it has increased to 2 GB). If you exceed this size and use the scanpst, it will truncate items (I’m unsure of whether it is by date, etc.). The Lost and Found feature is part of the Scanpst process (in MS KB http://support.microsoft.com/default.aspx?…kb;en-us;171371%5B/url%5D ): In your Folder List, the following recovered folders should be displayed: Recovered personal folders,
Calendar, Contacts, Deleted Items, Inbox, Journal, Notes, Outbox, Sent Items, Tasks. These folders are usually empty because the folders are part of a rebuilt .pst file. A Lost and Found folder should also be displayed. This folder contains the folders and items that the Inbox Repair Tool recovered. Any items that are absent are beyond repair.

If the case was that your .pst was oversize, try to Archive future psts into subject matters, i.e., I archive every year into its own .pst to ensure I do not surpass the oversize limit. If you set the archive on the top folder, i.e., Personal Folder (Trish), and click on File, Archive… select the date you wish to archive up to and type in a filename/path (i.e., 2002 Archive.pst), it will archive all folders (exception – Contacts). Performing this yearly should help you get organized with more current info in the top level PST and old information in the archived ones. P.S. I usually rename the .pst in the Folder List to include a Z at the beginning so they appear in alpha order at the bottom of my folder list. To do so, right-click on the Archive folder, click on Properties, then the Advanced… button and change name of .pst here. Good luck… trish

I had this happen to a user just the other day… and they were playing with the Dictionary and somehow defaulted the wrong items. Go to Tools, Language, Set Language… ensure that the proper language is set, i.e., English (U.S.). ALSO, ensure that the option Do not check Spelling or Grammar IS UNCHECKED. If it is checked, simply unchecking and clicking OK does not affect anything. You need to uncheck, click on the Default… button and then click OK. Hope this helps… trish

Hi Ed… I’m assuming that you are copying the area of the XL worksheet and then pasting it into Word, using Paste, Special? First of all with Paste Special, the default format is HTML Format – which makes your XL an HTML Table. If you choose Microsoft Excel Worksheet Object, it will invoke Excel to ‘open’ when you double-click on the object (you are in a subset of Excel). To enable the the Display as Icon options, you would have performed a ‘Paste Link’. Do you actually want to perform a Paste Link – wherein the data in the Excel spreadsheet is changed – the embedded object in Word will also change? Either way, if you choose to Link or not to Link, all the ‘worksheets’ in your Excel workbook will appear once you invoke the object. When this happens without linking the sheet, it is referred to as ‘Metadata’ and the extra information (worksheets) should be deleted from the embedded object (will not affect the original Excel document) – simply right-click on extra worksheets and Delete or select unwanted information from the current worksheet and Delete. With regard to the filename/path showing for your document, when you perform the PasteSpecial, Paste Link, Display as Icon, there is an option directly underneath the pictured icon which gives you the ability to change the icon and name which is displayed, Change Icon… button. Caption is the area which redefines the name of the Icon. Hope this helped a bit… feel free to reply with your comments… good luck… trish

As I mentioned above… you can also create an icon on your toolbar to complete the File, New, Choose Form… then pick the form from the list… you will need to write a quick VBA statement… pretty easy to do and you don’t really need to understand VBA to figure it out… I’ve again attached the link to MS KB Article… http://support.microsoft.com/default.aspx?…kb;en-us;290803%5B/url%5D … yours may look like this:

Sub DisplayForm()
Set myFolder = Session.GetDefaultFolder(olFolderInbox)
Set myItem = myFolder.Items.Add(“IPM.Note.Chuck”)
myItem.Display
End Sub

Variable in the Subject? Sounds like you need a MailMerge if you require variables and still the Subject field will be a hard one to develop. With regard to forms/templates, here’s a pretty good site to start… http://www.slipstick.com/dev/formpub.htm%5B/url%5D . Forms can be very flaky… templates are just useless (in my opinion!)… Good luck!

I’m not sure if I understand your question, if you are looking for info on .pst files, I have included MS KB Article explaining the usage http://support.microsoft.com/default.aspx?…kb;en-us;287456%5B/url%5D ; however, if you require more indepth information regarding .psts, could you be more indepth of your question? I have also attached a webpage which discusses many topics with regard to Outlook… http://www.slipstick.com/outlook/%5B/url%5D . Feel free to ask more about .psts… I have vast experience with them.

I’m thinking that you are referring to different domains? If so, no it is not possible, the information needs to stay on the same Exchange Server!

Hi Chuck… I opened your form and everything is working fine with the exception that the fields are tooo long and when you need to type in them the scroll bar is advancing forward to that area of the form – could this be the ‘inaccessible’ you were speaking of? – Not seeing the To: CC: Subject, etc. fields? Anyhow, I thought about this a little more and felt that the Category field should be placed above the message body area. I quickly created this form and changed the tabbing order, etc. for you. Open it up and go to Tools, Forms, Design this Form… then Publish the form – will ask for a name of the Form, default location – Personal Forms Library. If you wish to use this form, File, New, Choose Form, and select the Personal Forms Library (default) and the Form should be there. Test the form by sending it to yourself… to view the Categories you set, add the Categories field to your Inbox (right click on headers (Subject, Received, etc.) and pick Field Chooser, click and drag Categories to the desired location. Hope this helps! Good luck… trish