Macro reading from another workbook

Msdtitus

New Member
Joined
Aug 31, 2010
Messages
35
Hi there

I have asked by my department head to automate the manner in which the production reports are being collated. I then created a macro that reads information form multiple workbooks and compiles them on another work book.

Some background info:
  • The multiple work books are for the workers. They then update there productivity daily
  • This then needs to be copied on to the team leaders sheet which he can then use to report on his teams performance
  • This is all located in one folder with the team leaders names
  • There are multiple teams with multiple workers


It runs flawlessly however I have encountered a few problems which could hamper the automation of the File namely:

  1. If the workers work book is open, the code does not execute
  2. If the workers work book is renamed, then the code does not execute.

So I'm hoping you can assist me on the following

  1. A code which will still execute even if the workers sheet is currently open.
  2. A code which will execute in alphabetically order based on a specific folder
E.g if he workers files are saved in folder A then regardless of the name of the sheet, the code will open the files in alphabetical order and proceeded to past it beneath each other on the targeted sheet( i know this might not be possible and i will have to change the code manually to the agents names)

I hope I have included sufficient detail for you to assist me

regards
Masood
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Msdtitus

New Member
Joined
Aug 31, 2010
Messages
35
I would really like some assistance with the above question if anyone has any ideas how to do so I would highly appreciate it
 

Watch MrExcel Video

Forum statistics

Threads
1,128,088
Messages
5,628,594
Members
416,326
Latest member
NinaChristal

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top