ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Write Contents of TextBox to new Workbook (https://www.excelbanter.com/excel-discussion-misc-queries/14185-write-contents-textbox-new-workbook.html)

Andy Tallent

Write Contents of TextBox to new Workbook
 
Hi,

I am trying to get a macro to write the contents of multiple textboxes to a
new workbook. The idea is that the macro would open up a new workbook, write
the contents of the textbox to a named cell range and then save the new
workbook with the name of say range "A1" in the new workbook. Is this
possible.

Many thanks as always.
--
Andy Tallent


All times are GMT +1. The time now is 12:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com