Tyler5061
01-10-2014, 01:39 PM
Hi All!
I've been trying to find a macro solution to solve the following:
Create New File Based Off of template
Name that file based off of Cell B2
Open the newly created file (Regardless of what computer is viewing)
Submit Button (Via email or direct upload link)
What Im feeling is there will need to be a host sheet with a button macro that will create a sub routine to create the new file and save in a default location on their computer. Then After that sub runs in that first macro, another sub kicks in within the same macro that opens this newly created excel file. Then in the template it created from there should be a macro to open outlook and have a message ready to go with the active sheet as an attachment. Either that or a macro that saves the active sheet and use a service for a direct upload URL.
Any thoughts as to how this could be done would be greatly appreciated!
I've been trying to find a macro solution to solve the following:
Create New File Based Off of template
Name that file based off of Cell B2
Open the newly created file (Regardless of what computer is viewing)
Submit Button (Via email or direct upload link)
What Im feeling is there will need to be a host sheet with a button macro that will create a sub routine to create the new file and save in a default location on their computer. Then After that sub runs in that first macro, another sub kicks in within the same macro that opens this newly created excel file. Then in the template it created from there should be a macro to open outlook and have a message ready to go with the active sheet as an attachment. Either that or a macro that saves the active sheet and use a service for a direct upload URL.
Any thoughts as to how this could be done would be greatly appreciated!