Automated processing

I have used excel in it's basic form for many years but have rarely ventured into VBA programmng. I have been asked to automate the processing of a weekly excel report that arrives in a given format (which I can't change):

1) the file comes in with two worksheets.
2) I'm supposed to write something to take data from the second sheet (name should be fixed), produce a third sheet and then email that sheet to a specific person.

My questions are: how are macros managed on excel? - what process should I use to associate an incoming spreadsheet with a prewritten macro?

I hope someome out there knows what I am talking about!

Macros involve the automation of certain steps done manually in excel. You can have a separate macro file which will ask you to open the report and do the required steps and provide it to you.

If you need further help, attach a sample workbook (ensure that all sensitive data is removed) and let me know what you need automated and maybe i can help you out.

Originally Posted by arlu1201

Macros involve the automation of certain steps done manually in excel. You can have a separate macro file which will ask you to open the report and do the required steps and provide it to you.

If you need further help, attach a sample workbook (ensure that all sensitive data is removed) and let me know what you need automated and maybe i can help you out.

OK - I thought macros were associated with a particular spreadsheet but if they can be written generically, then great! Could you show me a simple bit of code to prompt the user for a worksheet please?

Like this -

Please Login or Register  to view this content.

Originally Posted by arlu1201

Like this -

Please Login or Register  to view this content.

Thank You - I don't understand a word of it, but thank you!

Its very simple. The code asks the user to provide the path to the file through the Open dialog box that comes up. The code checks if the user has not selected anything by comparing it to a blank. If the user has not selected, it asks to select again. If the user has selected, it opens the file.