I'm fairly new to vba and am learning just now so any help is
appreciated. Ive written various macros that take information from a
workbook containing a form, however ive just realised that the form
is being saved under different names before the macros are going to
be run and that all my macros begin with activating the workbook
name ("Master.xls"). How do i get them to work when i don't know the
name the workbook will be saved under. Is their a way to select the
name of the worksheet and insert it into the macro before running,
that way it will work with any of the saved workbooks.
If I haven't explained it well enough please let me know.