Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Thanks for the reply, Never made mention of the...

    Thanks for the reply, Never made mention of the version. I'm using Office 2010
  2. Thanks for the help. It now comes up with error...

    Thanks for the help. It now comes up with error code 445, object does not support this action

    The folowing code is highlighted


    With Application.FileSearch
  3. Thanks for the help My apologies. I had to...

    Thanks for the help

    My apologies. I had to leave in a hurry to go to a function and uploaded the workbook not realising at the time that the workbook Macros were password protected. I have now...
  4. Thanks for the reply. I agree that it is...

    Thanks for the reply.

    I agree that it is easier to have a macro open up the files one by one. Once the file is open the data needs to be refreshed (See Refresh button) and updated with the...
  5. I want to open all workbooks in c:\pull and well...

    I want to open all workbooks in c:\pull and well and its the sub-folders where its contains in the name "ACCNTS (P)" for eg BR1 ACCNTS (P) using a macro

    I will then update these one at a time
  6. Thanks for the reply. I am looking to open up all...

    Thanks for the reply. I am looking to open up all files in c:\pull and its sub-foldfers for eg c:\pull\tbbr1 where there are files that contain the name accnts (p)
  7. Hi Guys Thanks for the info- most appreciated

    Hi Guys

    Thanks for the info- most appreciated
  8. Thread: Library

    by HowardC
    Replies
    1
    Views
    46

    Library

    Is there a way to increase the number files in the Library (using Windows 7) for easy access?. I have tried to include a folder but the system wont allow any more files to appear in the library
  9. Replies
    4
    Views
    107

    Hi Guys Thanks for the help. I have now...

    Hi Guys

    Thanks for the help. I have now changed my setting to celcius
  10. Replies
    10
    Views
    198

    Hi Martin Thanks very much for your...

    Hi Martin

    Thanks very much for your constructive feedback. I will make use of a professional programmer to assist me on this one. I'm getting very close to getting the
    result I want , but just...
  11. Replies
    4
    Views
    107

    Temperature on Calendar

    I have the temperature in Farenheit that appears at the top on my Calendar in Outlook 2013. I would like to know how to change this to Celcius
  12. Replies
    10
    Views
    198

    Hi RG I think that the code would have to...

    Hi RG

    I think that the code would have to include a variable to declare the subfolder and then set the sub-folder something along this code below, which needs to be tweaked


    Sub Open_Files()...
  13. Replies
    10
    Views
    198

    Hi RG Have resolved part of the problem. If I...

    Hi RG

    Have resolved part of the problem. If I copy the files into the pull directory, and then run the macro, then the xls workbooks open. What I need is for all the workbooks containing ACCNTS...
  14. Replies
    10
    Views
    198

    Hi RG Still can't get it right. Have attached...

    Hi RG

    Still can't get it right. Have attached workbook to up files in C:\pull as well as subfolder for eg Pull\TBBR1 as well as file to be opened

    It would be appreciated if you could test and...
  15. Replies
    10
    Views
    198

    Hi RG When running your macro, I get run time...

    Hi RG

    When running your macro, I get run time error "cannot find C:\pull\file name.xls .... and the code below was highlighted


    Workbooks.Open zFSpec

    What I need to do is to open up...
  16. Replies
    10
    Views
    198

    Opening up files in folder and sub-folder

    I have a list of file names on all the files on sheet "workspace"


    into sheet "workspace" for workbooks containing in the name ACCNTS (P).xls for eg Br1 ACCNTS (P).xls

    I then want to use a...
  17. Utility to ensure memory utilitised efficiently

    I am looking for a utility to ensure that memory is utilized efficiently i.e a memory optimiser
  18. I have attached a workbook which I tried to adapt...

    I have attached a workbook which I tried to adapt from a Workbook Zeddy assisted me a few months to move files from a directory and sub-directories to another folder

    I now want to open all XLS...
  19. Macro to open up specified Files in Directory and Sub-directory

    I have several files in directory c:\pull as well as several sub-folders in this directory starting with TB for eg TBBR1, TBBr2 etc

    What I want to do is to open up all the XLS files that contains...
  20. Hi Steve Thanks-this works perfectly Howard

    Hi Steve

    Thanks-this works perfectly

    Howard
  21. Have Steve Have done so, but still don't get...

    Have Steve Have done so, but still don't get correct solution

    See attached file with my Formula in B2, where I am trying to compute the values greater than 60 days where the values are > 0 and...
  22. Hi Steve I have a similar Calculation on a...

    Hi Steve

    I have a similar Calculation on a Pivot Table, but now need to calculate the ageing 60-90, 90-120 , > 120

    It would be appreciated if you could assist me
  23. Hi RG Not sure what to do-have seen your...

    Hi RG

    Not sure what to do-have seen your link.

    Have you had a look at my screen shot "run time error 1004-cannot run the macro 'Auto_update!'

    It is only the code below that is causing the...
  24. Opening up all files in folder and then running Macro in opened workbooks

    I have a macro that opens up several files in one folder and then select the macro Auto_Update () in each of these workbooks

    However, I get a run time error 1004 and the following code is...
  25. Replies
    8
    Views
    189

    Hi Andrew Just to let you know that I have...

    Hi Andrew

    Just to let you know that I have resolved the problem, buy approaching it is small steps

    Once again thanks for pointing me in the right direction. It took me a while, but I am almost...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4