Search:

Type: Posts; User: adelie; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    5
    Views
    2,785

    Re: Help with Run-Time Error 1004 (Excel 2003)

    I am trying to work on this right now to see if we can get a "sanitized" version of the spreadsheet for you and others to look at.
  2. Replies
    5
    Views
    2,785

    Re: Help with Run-Time Error 1004 (Excel 2003)

    In answer to question 1:

    This is the line that it stopped at in the VBA editor:

    ActiveSheet.PivotTables("SummaryPT").PivotFields("Division").CurrentPage =...
  3. Replies
    5
    Views
    2,785

    Help with Run-Time Error 1004 (Excel 2003)

    Sorry about the original post - our smart defense system did not like the use of a certain word in my original message so it delayed the sending of the message. Here is the message in full:

    We are...
  4. Re: Open a workbook to a specific worksheet (Excel 2003)

    Thanks again Hans - I will try this code snippet with my client.
  5. Open a workbook to a specific worksheet (Excel 2003)

    A client has created a workbook with several worksheet tabs. One of these tabs is a table of contents with hyperlinks to the other tabs using named range labels.

    What she wants to have happen is...
  6. Re: Spell checking reverts to multiple languages (Word 2003 - Service Pack

    Thanks Hans - we will look into this possible fix.
  7. Spell checking reverts to multiple languages (Word 2003 - Service Pack 3)

    We have a user that has set their default spell checking to English U.K. When she runs the spell check procedure over "certain" documents it seems to revert to English U.S. France, etc. What might be...
  8. Re: Copy and Paste Word documents Destroys Formatt

    We are completely reformatting the users Windows 2000 computer and installing a new scripted unattended Windows PE installlation of Windows XP.

    To the "best of my knowledge" user machines are...
  9. Re: Copy and Paste Word documents Destroys Formatting (Word 2003 )

    Sorry for the confusion about the duplicate posting - will not happen again.

    Yes I am a bit baffled at why the problems with the move to Windows XP - that is the only change in the mix -...
  10. Copy and Paste Word documents Destroys Formatting (Word 2003 )

    We are using WIndows 2000 and Office 2003 at present.

    Some of our users are required to open up a Word 2003 document, Select All, Copy and then Paste the text into a Lotus Notes database (the...
  11. Copy and Paste Word documents Destroys Formatting (XP Service Realse 2)

    We are using WIndows 2000 and Office 2003 at present.

    Some of our users are required to open up a Word 2003 document, Select All, Copy and then Paste the text into a Lotus Notes database (the...
  12. Re: Pushing and Poking data from a Word Form to Excel (Word 2003)

    Thanks so very much Hans.

    I have downloaded the Automation tutorial and the great auto2000.chm help file. The code snippets in this help file are exactly what I need to get started!

    Thanks...
  13. Pushing and Poking data from a Word Form to Excel (Word 2003)

    We have a client who has created a Microsoft Word form template to capture risk investment information from managers in our organization (see attachment).

    Managers will fill this document in and...
  14. Allow Users to Select Display Behaviour - Balloons (Word 2003)

    We are trying to find a way to allow our users to change the default display behaviour of comment / review balloons in Microsoft Word 2003.

    We want users to be able to change the default setting...
  15. Re: 'Phantom' Autonew macro - how to stop this (Wo

    Thanks again - I read a similar post by Cindy Meister on these phantom fillin fileds. I have located these fields and dealt with them!

    Much appreciated!
  16. 'Phantom' Autonew macro - how to stop this (Word 2003)

    The attached zip file has a word template included. When I create a new document based on this template, I get a Microsoft Office dialog box popping up with an OK and Cancel button. I for the life of...
  17. Re: Creating dynamic cross-reference links (Word 2000)

    Thank you so very much Macropod! - your steps are wonderful.

    I think we have a good start on getting this task done!
  18. Creating dynamic cross-reference links (Word 2000)

    We have a client that has created a Word 2000 template for his office. This template will make reference to sections of text that look something like this:

    "As you can see in Exhibit (XXX) the...
  19. Re: Tab settings not changing in Word 2003 (Word 2003)

    Thanks again - I used the small vba code snippet and it solved the users problem
  20. Tab settings not changing in Word 2003 (Word 2003)

    We recently upgraded a user from Word 2000 to Word 2003.

    The tab setting units do not appear to be working correctly.

    They seem to be fixed in something called "ch units".

    No matter what...
  21. Replies
    2
    Views
    397

    Lockdown autocorrect entries (Word 2000)

    We have a request from our Executive Committee to modify users autocorrect.acl file in Microsoft Word 2000.

    What they want to do is to input some new entries that "cannot" be edited or changed by...
  22. Replies
    8
    Views
    693

    Re: Modify File Save Command (Word 2000)

    Thanks to all who replied to this post.

    I finally figured out some code that would work:

    Sub FileSaveAs()
    CommandBars("PCG Metadata Assistant").Visible = True
    Application.Run...
  23. Replies
    8
    Views
    693

    Re: Modify File Save Command (Word 2000)

    This is my code now:

    Sub FileSave()
    With Dialogs(wdDialogFileSaveAs)
    Select Case .Display
    Case 0 ' Cancel
    ' No need to do anything on Cancel
    '...
  24. Replies
    8
    Views
    693

    Re: Modify File Save Command (Word 2000)

    It looks like the macro name is "ShowMetaCleaner".

    I tried .Execute ShowMetaCleaner but this error out.

    Any thoughts
  25. Replies
    8
    Views
    693

    Re: Modify File Save Command (Word 2000)

    Thanks for the post of your code snippet.

    One additional question. See your code snippet below. On the .Execute line I have added my question between the < ... > symbols.




    Sub FileSave()...
Results 1 to 25 of 39
Page 1 of 2 1 2