Search:

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

Page 1 of 12 1 2 3 4

Search: Search took 0.02 seconds.

  1. Hi The command line "winword /mfile1" cetainly...

    Hi

    The command line "winword /mfile1" cetainly opens my last used file.
    Office 2010.
    G
  2. Learn to use the tools you have before re-inventing the tools you have

    Hi
    You have been given excellent advice by some of the most knowledgeable people in the sphere.

    Take 10 deep breaths and have a coffee or whatever.

    Power in Word is derived from templates and...
  3. Replies
    3
    Views
    154

    Printing problems with table

    Hi Phil
    I just printed page 3 without problem.
    I did however change a setting to Show all revisions Inline rather than in balloons.

    I then reset to print with balloons and all was well.

    I...
  4. [SOLVED] Sample document as test subject

    Hi again
    I have attached a document that I tested the routine against.
    Too simple it seems.
    Geof
  5. [SOLVED] Hi Just tested your sample. Epic fail. The...

    Hi
    Just tested your sample.
    Epic fail.
    The chewing gum and No. 8 wire does not like the nested brackets .
    I knew about the nested brackets.

    It would be more work than its worth to make the...
  6. [SOLVED] Proof Of Concept

    Hi Shelley
    I have taken your request to mean that you want to Insert fields at the positions of the content enclosed in square brackets.
    The routine I have posted is a proof of concept. The code is...
  7. [SOLVED] Shelley Can you post a silly sample doc ? Geof

    Shelley
    Can you post a silly sample doc ?
    Geof
  8. [SOLVED] Hi Wow, omg. Thousands of docs quick ...

    Hi


    Wow, omg.
    Thousands of docs <> quick

    He / she/ his / hers, their, their's, our. That must be a long list of optional terms.

    Pay macropod.
  9. Unc

    Hi
    UNC = universal naming convention.
    A convention whereby the path explicitly references the computer name \\computername\share\filepath
    Note the leading double slash.

    This link might help.
    ...
  10. Replies
    2
    Views
    158

    Hi edeldrige I believe that you must have...

    Hi edeldrige
    I believe that you must have minimised the ribbon.
    Press CTRL +F1.
    Hope it helps
    Geof
  11. Hi Darren More details please. I am sure we...

    Hi Darren
    More details please.
    I am sure we have all seen too many 'documents from hell' to offer a quick solution.

    So how many documents roughly?
    Is there a common template? Other than...
  12. Replies
    7
    Views
    1,143

    Sample Cross Tab Query

    Hi
    Database :NorthWind 2007.
    Query Source: Product Sales Category, a query in the database

    The accompanying sql is from a xTab query against an existing query in NorthWind 2007
    I used the...
  13. Establish a known good point

    Hi Jaggi

    We have to get to a point that we know is working.

    But first : - Are you 100% confident there is not a dialog awaiting your response hiding in a background window? Nothing new on the...
  14. Thanks, I missed that. Dohl.

    Thanks, I missed that. Dohl.
  15. Hello Jaggi I used the following stripped down...

    Hello Jaggi

    I used the following stripped down version of your code. Very simple.
    I have hard coded a path for simplicity. Converted docs are saved to the same location.
    If I have two word...
  16. Hi Jaggi Please comment out on error resume...

    Hi Jaggi

    Please comment out on error resume next.
    Run the macro again to see the error dialog.
    G
  17. Hi I will admit to be confounded. I didn't...

    Hi

    I will admit to be confounded. I didn't give you a hope in Hades of getting close.

    Do you actually see a .pdf created in addition to the .dot(?)
    If so all bets are off. What happens with
    ...
  18. Replies
    6
    Views
    466

    Hi Maud Space Mid String Thanks for the...

    Hi Maud

    Space Mid String
    Thanks for the advice on substitute() v Trim().
    I was thinking that it was necessary to preserve the space mid string in that Post Code.
    I wondered how it might mess...
  19. Validation on Open

    Hi
    I thought there would have been a method to refresh the validation. I can't find one.

    I started playing around trying to test if the current cell had validation applied and if not then apply...
  20. Replies
    5
    Views
    537

    Hi I found this link...

    Hi
    I found this link and thought it might help you.

    I ran the code on Office 2010 and created a reminder OK. I commented out a line that references a nextbusinessday function. Read his page.

    I...
  21. Replies
    7
    Views
    1,143

    Hi I think that the pivot views on tables and...

    Hi
    I think that the pivot views on tables and the ability to create pivot queries in Access might help.

    Then there is the ability to export to Excel and use the Pivot table functionality within...
  22. Hi The following line in you code means that...

    Hi

    The following line in you code means that the routine has to open the document. Password required !!


    Set d = Application.Documents.Open(oFile.Path)


    Do all the documents have the same...
  23. Replies
    6
    Views
    466

    Sample to generaste URL

    Hi

    Here is a simple example


    Sub makeURL()
    Dim sURL As String
    sURL = Range("a2")
    sURL = sURL & Range("a3")
    sURL = sURL & Range("a4")
  24. Replies
    6
    Views
    466

    Hi The vba Trim() function might work for you...

    Hi

    The vba Trim() function might work for you in place of the substitute expression.
    Put something in A1 that contains spaces fore and aft then run this.


    Sub testTrim()
    Dim sNew As...
  25. Replies
    3
    Views
    232

    Hi I have office 2010 and they are in ...

    Hi

    I have office 2010 and they are in
    C:\Program Files\Microsoft Office\Office14\1033\QuickStyles

    Just a guess try C:\Program Files\Microsoft Office\Office15\1033\QuickStyles.

    Cheers
    G
Results 1 to 25 of 296
Page 1 of 12 1 2 3 4