Hello, This is my first post, Im not very good at writing macros but pretty good at following and copying other peoples hard work.
My aim is to either use some kind of macro express software or ideally perform this as an excel VBA macro.
I currently have a xls worksheet which has 55 commandbuttons on it. Each button simply opens a database.xls (worksheet) and date/time stamps a cell so we know this particular file has been processed.
After clicking commandbutton1 which opens my file i need to click another commandbutton1 within that file which will run some code and call a macro. The macro will close and save that file which will take me back to my switch board, ready to click commandbutton2...... etc etc 50 times this takes approximately 2 hours per day.
Any software, code, advice or recommendations will be gratefully received.
Thanks MarkO
Bookmarks