Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    4
    Views
    181

    Thanks for the info Guys

    Thanks for the info Guys
  2. Replies
    4
    Views
    181

    Message Help us protect your account

    I have Windows 8 operating system

    When I tried logging into Skype, I get the following message

    Help us protect your account

    We detected something unusual and need to verify your account....
  3. Replies
    0
    Views
    369

    Increasing the number of libraries

    I have several libraries created on Windows 7. However, when trying to create a new library nothing happends. I guess I have reached the maximum level. Is there a way to increase the number of...
  4. Thanks Maud, never thought of this. Have amended...

    Thanks Maud, never thought of this. Have amended code and it works perfectly
  5. Macro to copy data , except where = sum appears

    I have code to copy the Data in Col F (closing Balances) and to paste value these in Col C (Opening Balances) from row 3 onwards, except where the data contains an = sum formula. Where there is an ...
  6. Hi Guys Thanks for your input, much appreciated

    Hi Guys

    Thanks for your input, much appreciated
  7. Hi Maud Agree 100%. I'm going to use your...

    Hi Maud

    Agree 100%. I'm going to use your suggestion by placing an apostrophe in front of the section as mentioned by you
  8. Hi Maud The source files were developed by...

    Hi Maud

    The source files were developed by someone else so I did not want to amend their code, but I will ask the person to put an apostrophe in front of their code as this is the easiest way
  9. Thanks for pointing this out Maud. I was hoping...

    Thanks for pointing this out Maud. I was hoping that there may be another way. I will put an apostrophe in front of the message Box for all the files containing this message box statement
  10. Hi Guys Sorry for the confusion caused See...

    Hi Guys

    Sorry for the confusion caused

    See code below from original workbook which generates the message box in the source workbook. When calling this from the destination workbook, I want OK...
  11. Hi RG Thanks for the help. I used your code...

    Hi RG

    Thanks for the help. I used your code and called it from within my macro using application.run "DisplayMsgBox", but the message box still appears and I have to select the "OK" button to...
  12. Thanks for the info Maud, however the message box...

    Thanks for the info Maud, however the message box with the OK button still appears
  13. Code to automatically accept OK button without clicking it

    I have a macro that opens several files and activates a particular macro that brings up a message box that prompts the user the "OK" button

    I would like code to would automatically accept the "OK"...
  14. Replies
    7
    Views
    295

    Thanks for your input dguillett

    Thanks for your input dguillett
  15. Replies
    7
    Views
    295

    Hi Maud Thanks for the help and your input

    Hi Maud

    Thanks for the help and your input
  16. Replies
    7
    Views
    295

    Macro to open Files

    I have a spreadsheet, where I want to open all the files that are listed on sheet "workspace" in a folder called C:\Pull as well as the sub-folders

    I have tried to write code to do this -see code...
  17. Thread: Library

    by HowardC
    Replies
    2
    Views
    244

    Thanks for the reply. Much appreciated

    Thanks for the reply. Much appreciated
  18. Thanks for the useful link, much appreciated

    Thanks for the useful link, much appreciated
  19. Macro to copy data from one folder to another

    I have a workbook that contains a macro to copy files from one folder to another. I would like the code amended so that if the file in the destination folder already exits, it must not overwrite the...
  20. Replies
    5
    Views
    237

    Thanks for the help chaps

    Thanks for the help chaps
  21. Replies
    5
    Views
    237

    Set Default Folder when opening Files

    I am using Windows 8 and Office 2013

    I would like to know how to set a default folder when opening up files using Office 2013
  22. Replies
    3
    Views
    174

    Thanks for the advice

    Thanks for the advice
  23. Replies
    3
    Views
    174

    Managed to sort out my macro by breaking it down...

    Managed to sort out my macro by breaking it down into two sections


    Sub Print_Income_Statement()
    Sheets("Income Statement").Select

    Dim LastRow As Long
    LastRow = Sheets("Income...
  24. Replies
    3
    Views
    174

    Print Macro with seperate headers

    I have a macro to print a worksheet.

    When printing I want "revenue" Cell A2 to print in the header from A3 to A27 and "Costs" A28 to print in he header thereafter

    See Attached file containing...
  25. Thanks for the help , much appreciated

    Thanks for the help , much appreciated
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4