create workbook

Hi All, forum newbie looking for some advice.... In simple terms: I have an Excel workbook ("report creation tool") which uses VBA to create multiple new workbooks and email each outputted workbook to a recipient. I want to add a button into each of the outputted workbooks which runs a macro...

HI All, I have a macro that splits the excel worksheets into different workbook, just wanted to check is there any way that we can create the separate workbook based on sheet name mentioned in master work sheet. example I have a workbook with more than 30 sheets and the first sheet is the...

Hi, i have some code that a) filters data from the table in one sheet into a group of new sheets named by the filter value b) creates a new workbook from these sheets The script does the above. The additional code has no effect that i can see. It doesnt stop it working, it just doesnt do...

Hi, I hope you can help me to solve an issue with this code, I´m using the following code to export the filtered data to a new workbook . ie. filter information added on sep 15 2018 and create the document then i have to select sep 16 and execute macro to export the info for that day and so...

I want to open a file and then interogate it to see if it contains data i need. If i find it I want to create a file to export the data there. I have 4 workbooks that i need to create. The source workbook has one sheet, and the portalworkbooks also. The source worksheet has a lot of line and...

I have a TEMPLATE workbook that has 106 cells (all in the same worksheet) that need to have data input in them. I have a separate DATA workbook with 3,000 rows of data, each row has 106 columns that correspond to the cells in the TEMPLATE workbook. I need to create 3,000 new workbooks that are...

I have created a pricing estimator in Excel. I want to be able to click on an ActiveX command button to generate a new Workbook and name it the client's name in Cell F3. On the same worksheet as the ActiveX command button, I have an estimate. Column A = Quantity Column B = Item Column C =...

Morning all, I am trying to create a new workbook but I dont want to save it so the workbook name will be book 'x'. What I need to do is refrence the new workbook something like Dim NewWB as workbook workbooks.add new workbook = NewWB Any help would be great.