Formatting Macro for New Workbook

[MrPartial]

I receive a daily data dump every morning from our billing team that contains all clients that were invoiced/printed the prior day). It comes in the form of a new workbook. I have a macro that formats the data to my liking.

What is the best way of executing this macro every time I receive the new worksheet? I currently have the code saved in a .txt, open up VBA, insert a new module, copy paste, then run the macro.

Must be an easier way.


Thanks guys!

[Trimdaddy]

Create your own template. Set it up with your VBA and test it by copying and pasting the sheet(s) you'll be running the macro on. Whenever you get a new data dump, copy and paste it into your template, run your macro, and "Save As" that days date. Then you'll always have your unmodified template ready for the next days data dump.

[Richard Buttrey]

Hi,

Why not just put the VBA macro code in a module in your Personal.xlsm workbook and run the macro from there?

[MrPartial]

Hi,

Why not just put the VBA macro code in a module in your Personal.xlsm workbook and run the macro from there?

Hi. So you mean having a separate workbook named Personal.xlsm, opening it up (everyday?), and having my data dump workbook run the macro from Personal.xlsm?

Sorry, I'm just getting into VBA / macros.

Thanks.

[Richard Buttrey]

Hi,

It's even easier than that. The Personal Workbook (once it's been set up) will open automatically every time you open the Excel Application.

To start the Personal workbook just start recording any simple macro and choose to save it in the Personal Macro Workbook. Once that's been set up you can delete the macro in the VBE where you'll find the Personal.xlsb workbook listed and from now on it will always be present without you needing to do anything.

Here's an article about it.

http://office.microsoft.com/en-gb/ex...102174076.aspx

[MrPartial]

I'll look at it today. Thanks

[MrPartial]

Solved thanks! Never knew about the .xlsb hidden book.

Thanks guys.