Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.02 seconds.

  1. Thread: Link problems

    by bonriki
    Replies
    4
    Views
    209

    KritzX thanks Our IT tech did a registry edit...

    KritzX thanks
    Our IT tech did a registry edit and effectively did the same thing, but ran through suggestions as well.

    Worked a treat
  2. Thread: Link problems

    by bonriki
    Replies
    4
    Views
    209

    Link problems

    Hi
    WIN 7 Prof, MSO 2010
    A problem with links in emails has just arisen on my computer. If an email from internal or external contains a link I get this error message when the link is clicked....
  3. Replies
    3
    Views
    453

    Charles We don't need a table of contents so...

    Charles
    We don't need a table of contents so Andrews answer will do the trick
    Thanks for taking the time
  4. Replies
    3
    Views
    453

    Office 2013 page numbering

    We have a situation in Office 2013 where we have a document with a front page, section break and then the main text. We do not wish to number the front page but want the rest of the document numbered...
  5. Replies
    10
    Views
    984

    Andrew Thanks again. Will give it a try. We are...

    Andrew
    Thanks again.
    Will give it a try. We are working with our CRM people to try determine how we can prevent this from happening in the future
  6. Replies
    10
    Views
    984

    Paul That's pretty much what we have done. Just...

    Paul
    That's pretty much what we have done. Just trying to determine if there was a better way
  7. Replies
    10
    Views
    984

    Paul hi Thanks very much, again. I am sure that...

    Paul hi
    Thanks very much, again.
    I am sure that code will work fine. I have now been told that our real problem is that most of the documents with the old server reference are stored in our SQL...
  8. Replies
    10
    Views
    984

    Word searching for non-existent server

    Hi
    The problem we have is when we open some documents they have links to templates on a redundent server and it takes an age to determine that it cannot find that server.The documents eventually...
  9. Macro to print 2 areas from spreadhseet with different titles

    We have a requirement to print a landscape report from a spreadsheet that contains 2 titles B2:C5 & Q2:AK5 and 2 data areas Q2:AK45 & Q86:AK108

    Can do this fine for single areas where code has...
  10. Replies
    4
    Views
    551

    Thank you both Seems the problem is worse than...

    Thank you both
    Seems the problem is worse than first reported in that it appears to be quite random. Some templates are fine and others just will not behave.
    Not sure where to go here as thet are...
  11. Replies
    4
    Views
    551

    2010 macros in 2013

    Hi
    We have template documents that were first created in MSO'97, then converted to MSO'2010 but now with MSO'2013 the macros no longer what to work.
    Documents are created by picking a template from...
  12. Replies
    9
    Views
    692

    Thanks Maud Finally got it to run Kept failling...

    Thanks Maud
    Finally got it to run Kept failling with the code asking for the target file to be opened again
    Inserted error code "On error resume next" and works fine

    Thank you again
  13. Replies
    9
    Views
    692

    Maud hi I think I have got to the bottom of my...

    Maud hi
    I think I have got to the bottom of my problem.
    I asked if I could copy print areas when I shoulkd have asked "Can I copy named ranges" instead.

    I have attached a screen dump of a range...
  14. Replies
    9
    Views
    692

    Maud I still cannnot get this to work. Tried...

    Maud
    I still cannnot get this to work.
    Tried renaming and saving target file as .xslx. copying all the macros across ( The macros are the print commands that use the print areas), bot to no avail!
  15. Replies
    9
    Views
    692

    Maud hi We have a wb with 28 sheets and 64 print...

    Maud hi
    We have a wb with 28 sheets and 64 print areas defined. The data in the source and target files is essentially the same.
    Using the second code it appears to run OK but nothing happens
  16. Replies
    9
    Views
    692

    Copy print areas

    Excel 2010: How can we copy all the print areas from one workbook to another?
  17. Thread: Create report

    by bonriki
    Replies
    10
    Views
    589

    Yep That did it. Thanks again works great

    Yep
    That did it.
    Thanks again works great
  18. Thread: Create report

    by bonriki
    Replies
    10
    Views
    589

    Oh Retired one! Thanks for that I inserted a...

    Oh Retired one!
    Thanks for that
    I inserted a sheet named "Driver Training" but the macro dumped the retrieved data into the sheet I started from
  19. Thread: Create report

    by bonriki
    Replies
    10
    Views
    589

    Maud Thanks again Works a treat

    Maud
    Thanks again
    Works a treat
  20. Thread: Create report

    by bonriki
    Replies
    10
    Views
    589

    Just 2 columns which will be "Name" and "Date" in...

    Just 2 columns which will be "Name" and "Date" in a new worksheet
  21. Thread: Create report

    by bonriki
    Replies
    10
    Views
    589

    Create report

    I need to create a report that extracts the data from cells A1 and C24 in a 50 sheet workbook
  22. Thread: Repeat copy

    by bonriki
    Replies
    16
    Views
    884

    Steve Thanks for that. It works just fine with...

    Steve
    Thanks for that.
    It works just fine with that line of code added
  23. Thread: Repeat copy

    by bonriki
    Replies
    16
    Views
    884

    Maud Nearly there. Unfortunately there are...

    Maud
    Nearly there. Unfortunately there are several blocks that do not get the extra row code applied. This only shows up when the data in the full spreadsheet is treated.
    It seems to be quite...
  24. Thread: Repeat copy

    by bonriki
    Replies
    16
    Views
    884

    Maud Still can't seem to get the code to work....

    Maud
    Still can't seem to get the code to work. Attached is a stripped down version of the s/sheet.
    If you run TotalBlocks first and then the ExtraProgCode module the problem manifests itself
  25. Thread: Repeat copy

    by bonriki
    Replies
    16
    Views
    884

    Steve Not really. We data exported from our CRM...

    Steve
    Not really. We data exported from our CRM as per:
    36889

    What is required is to copy the last cell with the prog code in "E" down to the next blank cell in "E". Works fine for all except...
Results 1 to 25 of 476
Page 1 of 20 1 2 3 4