Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Passing variables from Child (Word) to Parent (Excel)

    This is just excellent. I've now transferred all of the code to Excel which makes it much easier to work with. I have made a few adaptions to your code but thank you soooo much for setting me on the...
  2. Re: Passing variables from Child (Word) to Parent (Excel)

    If it was not overwritten, then the following should say "Incomplete"


    '' updates utilities sheet
    With Sheets("Utilities")
    .Cells(7, 2).Value = Application.UserName & " " & Now
    ...
  3. Re: Passing variables from Child (Word) to Parent (Excel)

    I have answered the first part of this by using Application.Activate if the msgbox appears at all.

    Still havent worked out how to tell from Excel what the result of the Yes/No question is.
  4. Re: Passing variables from Child (Word) to Parent (Excel)

    And another question, I'm sorry but this happens when you find someone helpful!!!

    How would I have all the code in Excel? This would negate my need to pass a variable between applications. If its...
  5. Re: Passing variables from Child (Word) to Parent (Excel)

    Excellent, that works now. However.... It doesnt bring up the VB question to the front of the screen if its already created. How do I do this?

    And also, how can I tell what the answer is to that...
  6. Re: Passing variables from Child (Word) to Parent (Excel)

    Thanks for this Macropod but it doesnt seem to create any files at the end. And I still dont know how to pass the boolean/variable back to Excel.
  7. Passing variables from Child (Word) to Parent (Excel)

    Hello, I have spent all last week on this and I just can't figure it out. I have an Excel macro which passes some variables to a word sub which works great. What I am then trying to do is pass a...
  8. Re: Passing variables from Child (Word) to Parent (Excel)

    Hi Norie, still struggling with this, can you point me in the right direction?
  9. How to show if open in browser or Excel application?

    I'm looking for a way to show if a file is open in a browser or if it is open in the excel application.
    Or alternatively, a way of ensuring the file opens in the application.

    My reasoning is...
  10. Re: Passing variables from Child (Word) to Parent (Excel)

    Hi Norie, I'm not sure how to do that, can you point me in the right direction please?
  11. Passing variables from Child (Word) to Parent (Excel)

    Hello, I have spent all day on this and I just can't figure it out. I have an Excel macro which passes some variables to a word sub which works great. What I am then trying to do is pass a Boolean...
  12. Replies
    4
    Views
    114

    Re: Calculating points based on time

    This is great - Thanks for that. Just wondering if you know a calculation for weight thats similar.IE

    Actual and guess weight - last cell has a calculation which shows as points (spot on, 50...
  13. Replies
    4
    Views
    114

    Calculating points based on time

    I'm trying to get a formula that calculates points up to a maximum of 50 depending on how many minutes a result is. IE

    Cell A2 has an actual time in it
    Cell B2 has a guess time in it
    Cell C2 has...
  14. VBA to open selected calendar item and add recipient

    Hello, I am looking for some Code to put in Outlook so that I am able to select a few calendar items (or all) and add a new recipient (Which is a room). I think I then need to send the calendar...
  15. VBA to open selected calendar item and add recipient

    Hello, I am looking for some Code to put in Outlook so that I am able to select a few calendar items (or all) and add a new recipient (Which is a room). I think I then need to send the calendar...
  16. Replies
    4
    Views
    167

    Re: Leading zero in header with vba

    You will have to amend the part where it says


    .PrintOut From:=J, To:=J

    You can edit it out if you dont want it to print.
  17. Replies
    4
    Views
    167

    Re: Leading zero in header with vba

    The below link has a bit of VBA which should do this.

    https://excel.tips.net/T003055_Leading_Zeros_in_Page_Numbers.html
  18. Replies
    6
    Views
    303

    Re: What does =" mean

    Does it end in " too? If so, it could mean that there is a calculation in the cell. Can you paste an entire cells details?
  19. Replies
    2
    Views
    177

    Re: save and close after idle vba

    I used the code from the below link and it works great!

    https://www.extendoffice.com/documents/excel/3921-excel-save-and-close-workbook-after-inactivity.html
  20. Re: VBA to Schedule Running of Macro Based on Current Time and Environ ("username")

    Only a few months out of date....

    This explains how to do this just in case anyone is looking.

    https://www.mrexcel.com/forum/excel-questions/48654-running-macros-specific-time.html
  21. Replies
    15
    Views
    855

    Re: Insert word file object at bookmark

    Macropod, you are being rather rude. I have tried it. This is a learning site. Telling me the fault is mine when you know very little about what I'm doing says more about you then it does about me.
  22. Replies
    15
    Views
    855

    Re: Insert word file object at bookmark

    Yeah, that leaves the formatting of the document in a terrible state which is unusable. From having a look round, I don't think that this can be done reliably time after time without turning each...
  23. Replies
    15
    Views
    855

    Re: Insert word file object at bookmark

    Thats it! Fantastic.

    As a side note, if I wanted to place the contents of the file instead of the actual file, how would I do this without the formatting being awful? I'm assuming it's something...
  24. Replies
    15
    Views
    855

    Re: Insert word file object at bookmark

    I've now changed it to


    With wdDoc

    .Bookmarks("AccountID").Range.Text = AccID
    .Bookmarks("ServiceType").Range.Text = Serv
    .Bookmarks("ClientName").Range.Text = clName
    ...
  25. Replies
    15
    Views
    855

    Re: Insert word file object at bookmark

    I appreciate you tidying it up. I would have done it when I got everything working. However, this still doesnt do what I need it to. It pastes the actual content of the document into the file which...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4