I'm a bit new to macros and my boss is looking for a macro to auto import from a xls file automacitcally generated every 2 hours. I want to import this data, make a pivot table, and have it automatically update every 2 hours without having to open the generated file everytime. is this possible? 
thanks!
thanks!