Search:

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

Page 1 of 12 1 2 3 4

Search: Search took 0.03 seconds.

  1. Establish a known good point

    Hi Jaggi

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

    Please place the following minimalist code into a new module in a new macro enabled document.


    Sub jaggiTest2()
    Dim fs As Object...
  2. Thanks, I missed that. Dohl.

    Thanks, I missed that. Dohl.
  3. 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...
  4. 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
  5. 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
    ...
  6. Replies
    6
    Views
    376

    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...
  7. 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...
  8. Replies
    5
    Views
    236

    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...
  9. Replies
    1
    Views
    110

    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...
  10. 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...
  11. Replies
    6
    Views
    376

    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")
  12. Replies
    6
    Views
    376

    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...
  13. Replies
    3
    Views
    187

    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
  14. Date arithmetic to find day number

    Hi sbdale
    Welcome to the world of date arithmetic.
    You need to understand that excel treats dates as serial numbers. (Capt Kirk says star date 42214)
    We mere mortals need dates formatted to show...
  15. Hi You could try the F5 key. Select the...

    Hi

    You could try the F5 key.
    Select the option for visible cells.

    Make sure you have the data selected first though.

    Without knowing your exact intentions I would suggest that you read up...
  16. Hi or this =C2-DATE(YEAR(C2),1,1)+1 Then...

    Hi
    or this

    =C2-DATE(YEAR(C2),1,1)+1


    Then there is =DatedIf function.
    =DatedIf(date1, date2, intervalType)

    Cheers
  17. Problem needing to close and reopen database

    Hi


    I am wondering if you need to close a recordset or the database in the code.
    In the published excerpt there are DIM statements for database and dao.recordset


    something like
  18. Dohl .. my bad. Wrong thread:mad: G

    Dohl .. my bad.
    Wrong thread:mad:
    G
  19. Building the consolidation

    Hello
    That is excellent.
    I created this using only the consolidate tool on the data tab, data tools group.
    Each of the 4 worksheets will have references to the supporting workbooks and worksheets....
  20. Hello again Thank you for your explanation. I...

    Hello again
    Thank you for your explanation.

    I have attached a sample destination workbook.
    Does it look the way you like it?

    44202


    Geof
  21. Creating a sum with VBA

    Hello again
    Unfortunately I cannot help much further.

    The lines of code below show two methods of summing a range under VBA. It is only a very simple example. The data needs to be integer.
    The...
  22. Consolidations

    Hi
    Could the following steps work for you. It is a process you have to make clear for a programmer anyway.


    Consolidate each of the 5 sets of 12 into single workbooks of 4 worksheets. Each of...
  23. Hi Yes you can perform the consolidation without...

    Hi
    Yes you can perform the consolidation without links to the source. This can then be emailed.

    I am wondering now about whether this will suit your needs. How many files and worksheets are you...
  24. Replies
    14
    Views
    1,059

    Using multiple rows in query grid.

    Hi
    To construct logical OR use multiple rows in your query grid.

    Continuing with my horse analogy.
    The accompanying screenshot, though simple, demonstrates this effect.
    44189
    This is the...
  25. Hello Have you considered the built in ability...

    Hello
    Have you considered the built in ability for excel to consolidate data from multiple sources.

    This is found on the ribbon int the Data Tab, Data tools group, consolidate button.

    If the...
Results 1 to 25 of 284
Page 1 of 12 1 2 3 4