This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
First in a list of questions no doubt...
I have tried many solutions I have seen on the net and none of them seem to help me figure out this extremely simple function...
What code do I need for a macro, to apply to a button to import file 'Quote Template.xltm' into a workbook AFTER a sheet called 'Quotes', and BEFORE a sheet called 'QuotesEnd' and then all subsequent imported templates to follow on one after another in succession.
The template file location is L:\Quote Template
Thank you for any help
Luke
NEXT QUESTION WILL BE: How to pull customer details to the newly imported quote template from the 'Clients' page using the clients reference number...
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
So there is no way to import another sheet into a workbook?
If that is the case, is there a VBA to duplicate a page that exists within the workbook?
You can't. A template is designed to create a new file.
Do so and copy the created sheet(s) from the new file into your existing file.
Andreas.