Hello,
I have taken on a new role and have never used VBA before. I can absolutely see that using VBA to automate some of the more repetitive tasks my new team do would be a great thing for me to do.
There is so much information on these and other boards and sites that putting together what I would like to do has become total overload so I though I would ask everything together in the hope that someone would be able to give me a working example.
Where I have taken things from various sites, it have run into issues I cannot solve.
So here goes.
I would like my team to be able to automatically:
From one button: Save a template .xlm file as a new file in a specified location with the file name in the format of "some text followed by the contents of cell A1 and the time now in hour and minute format"
From a second button: export a specific range within a sheet in that new file to a pdf of the same name and it be automatically emailed to a specific group of addresses with a preset title and preset text in the body of the email.
From a third button send a specific sheet
I have taken on a new role and have never used VBA before. I can absolutely see that using VBA to automate some of the more repetitive tasks my new team do would be a great thing for me to do.
There is so much information on these and other boards and sites that putting together what I would like to do has become total overload so I though I would ask everything together in the hope that someone would be able to give me a working example.
Where I have taken things from various sites, it have run into issues I cannot solve.
So here goes.
I would like my team to be able to automatically:
From one button: Save a template .xlm file as a new file in a specified location with the file name in the format of "some text followed by the contents of cell A1 and the time now in hour and minute format"
From a second button: export a specific range within a sheet in that new file to a pdf of the same name and it be automatically emailed to a specific group of addresses with a preset title and preset text in the body of the email.
From a third button send a specific sheet
in that new file to a pdf of the same name and it be automatically emailed to a specific group of addresses with a preset title and preset text in the body of the email
Thanks in advance.
Thanks in advance.