Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Many thanks RetiredGeek I'll do it like that....

    Many thanks RetiredGeek

    I'll do it like that.

    :)

    LL
  2. Almost there RetiredGeek! This code copy the...

    Almost there RetiredGeek!

    This code copy the excel files in the first directory "Working Files" :) but doens't copy the excel files inside of the subfolders.

    The source folder structure is like...
  3. Hi Berton, I'm using only Excel 2007 with...

    Hi Berton,

    I'm using only Excel 2007 with .xlsx format.

    And if I use FileExt = "*.xlsx", the error is the same...

    Any ideas?

    Many thanks in advance
  4. Hi Maudibe Yes, that is very stange becuase I...

    Hi Maudibe

    Yes, that is very stange becuase I have lost of excel files in the folder.

    Even if I change the line code to FileExt = "*.xlsx", I get the same error!

    What is stange is that if I...
  5. Thanks for the tip Maudibe but I've those...

    Thanks for the tip Maudibe but I've those configurations as you indicate and I still have the error.... :(

    Any other idea?

    Tks

    LL
  6. Hi Steve, Doesn't work as well... I'm getting...

    Hi Steve,

    Doesn't work as well... I'm getting the same error 53 "File not found".


    LL
  7. Copy excel files and folder structure from subfolders with vba

    Hi,

    I need to backup a folder structure with the excel files (all the other extensions aren't to copy) from a location to another.

    I'm using the following code, that work just fine for ALL...
  8. Sorry Maudibe but I didn't see the 2nd post :( ...

    Sorry Maudibe but I didn't see the 2nd post :(

    But works jst fine :D

    Many thanks for your help.


    LL
  9. Thanks for the info Maudibe The copy process...

    Thanks for the info Maudibe

    The copy process is ok but the paste is not.

    Meaning:
    1) copy the filtered rows from the 1st sheet and paste it ok in sheet MKT starting on cell A1
    2) copy the...
  10. Hi Steve, Thanks for the reply. The...

    Hi Steve,

    Thanks for the reply.

    The filtered rows from each sheet is to paste in the sheet "MKT", starting in cell B8.

    I've tried the following code:

    For Each wTarget In Worksheets ...
  11. Copy filtered rows from several sheets to one sheet

    Hello,

    I have a file with several sheets with filters and I need to copy the filtered rows (according the filter applied) from all sheet to one sheet only.

    The code that I'm using is:...
  12. **SOLVED** Super!! It work's just perfect :D ...

    **SOLVED**

    Super!! It work's just perfect :D

    Many, many thanks Steve

    Regards

    LL
  13. If you telm me the code to copy from source and...

    If you telm me the code to copy from source and paste it on target I think that I can you it for all the other values.

    Yes, the technician will be always in J3.

    The code should tranfer only the...
  14. The values to be copied from the source (Tech...

    The values to be copied from the source (Tech code, Total A - 1, Total A - 2, Act 1, Act 2, Result 1, Result 2, etc) will be paste in to the target file in the correspondent lines.

    There will be a...
  15. I need to copy the source from each day (day 1...

    I need to copy the source from each day (day 1 and others) in to the target.

    The target file will have a sheet "day 1" will the source data from all technician, side by side in each column.


    LL
  16. Hi Steve, Thank you for getting back to me. ...

    Hi Steve,

    Thank you for getting back to me.

    Please find attached 2 woorkbooks:

    1) "Source_Workbook.xlsx"
    - Where I have the data to copy from
    - I will have 1 file for each...
  17. Copy different columns from several files to 1 single column in 1 file

    Hello,

    I have several workbooks in severeal folders and I need to copy some ranges in different columns from each one of those files to ONE file only.

    I'have 2 problems:
    1) The data (the...
  18. It works! Many thanks Rory :cool: LL

    It works!

    Many thanks Rory

    :cool:


    LL
  19. Hi Steve, Sorry... but I'm getting the same...

    Hi Steve,

    Sorry... but I'm getting the same error "Unable to set the Locked property of the Style class" :(

    Any other ideas?

    Thanks

    LL
  20. Hello Rory, It works just fine for a single...

    Hello Rory,

    It works just fine for a single file :D but I'm need to apply it for several files in different folders and I'm getting the error message "Unable to set the Locked property of the...
  21. How can I modify the "Normal" Cells Style using VBA?

    Hello,

    How can I modify the "Normal" Cells Style using VBA?

    The parameter that I need to modify is in:
    - Normal Style
    - Modify
    - Format button
    - Protection tab
    - Uncheck option...
  22. Replies
    2
    Views
    261

    Super! :D Many thanks Steve LL

    Super! :D

    Many thanks Steve


    LL
  23. Replies
    2
    Views
    261

    Change some sheets in several files

    Hi,

    How can I update some sheets (not all) from several excel files, saved in differente locations (subfolders)?

    In the code below everything it's working but is updating ALL the sheets. How...
  24. Replies
    0
    Views
    237

    Save email attachments to disk

    Hello,

    I need to save attachments to disk from the Inbox for all emails with a specific word in subsject - using a outllok rule.

    Because the files attached in the emails have the same name in...
  25. This is PERFECT!! :D Million thanks Steve LL

    This is PERFECT!! :D

    Million thanks Steve

    LL
Results 1 to 25 of 32
Page 1 of 2 1 2