new workbook

I have some complicated VBA code to populate a 2-D array (250 by 366). When the array has been populated, I want to copy the array to another workbook. I believe there is a way to efficiently copy en masse with very simple code. Any thoughts?

Hi, I'm creating new files (over 40) based on a list. Column M On "Lookup" contains the list and new file names. Ideally the new file contains 1) A copied tab "Account_Risk_Assessment" 2) the original "Lookup" tab I've pieced together this from other forums... Sub accountlisting()...

Hi all--I have the need to save only the values from one sheet of a workbook, as .csv in a new workbook that is named according to the value in cell A2. The sheet is populated according to formulas. I have a nice, simple VBA doing everything right...except it copies the formulas over, and the...

Hi all. Long time listener, 1st time caller. I am still learning a lot every day with VBA, having only recently returning to a position that requires me to use it again, and I didnt know much before! I have a UserForm which is populating data entered into 'row 2' on 'sheet 1' which I need to...

<tbody> Acct. No Product Date Manager Business Unit Misc. 1 A JULY SUE EAST NEEDS UPDATED CONTACT INFO 2 A AUGUST BOB WEST 3 C JUNE MARY SOUTH 4 D JULY TIM NORTH 5 B JULY MARY WEST </tbody> <tbody> </tbody> I need input/guidance on a work problem. Another branch for our...

I am having a pivot table. I want to export the data to new work book when I click the data in the table. Please help .!!

Hello I have finished writing my code. After hitting a command button, it will select all visible sheets except two that I specified; and will create a new workbook with those selected sheets. Now, in that new workbook, when I try to save it; I get an error saying: " The following features...

Hello I want to copy all sheets in active workbook into a new workbook except one sheet called "Main". I have written the code but it only copies the sheets that typed inside array. I have a lot of hidden sheets so will take too much time naming each one. --> I basically want to select all...

Version: 2007 Hello Everyone, I have a workbook with a "Detail" and "Summary" worksheet. The data in each of these worksheets needs to be split up and grouped into separate tabs based on the value of a specific column (region). Then, the Summary and Detail worksheet for each region needs to be...

Hi There, Ive been asked to organize some daily data and it comes in large bulks of about 6000 rows a day. I need to organize this data into filtered worksheets so as I can send it to each specific area dealing with the reservations. I have been doing it manually for a while now but I know if I...

Hello! I have a question about this thing I'm working on. I'm trying to SaveAs a single sheet from one workbook to a new workbook as a .cvs file. It will always go to the same place with the same name and overwrite the current file. So far I have this here, but I'm getting errors where the...

Hi everyone, Recently I have started recording and editing macros. I am really new in this field and I am not able to find the solution for one of the latest macros I have recorded. When I run the macro below I get the following error message: Run-Time error '1004': Method...

hi there, I have one workbook with 50+ tabs and want to parse them out to a new workbook based on the specific cell "u2". Let's say out of 50+ tabs only 2 tabs have same number in cell "u2". I need the macro to pick these two tabs and copy to a new workbook. Here is the code I have so far...

Hi, I am trying to copy worksheets with specific names to a new workbook. I want to copy the worksheet from a master template workbook. My problem is that it creates a correctly named worksheet in a new workbook and then searches that new workbook for the sheet template name (which does not...

Hi All, I've not had much experience with VBA code, other than recording macros and editing them a little. What i would like to do is code a macro to copy the data (text only) of a whole worksheet into a blank worksheet in a different workbook, effectively allowing the user to "upload" the data...

Hello there, I was fortunate enough to find this code written by Joe4 which I customized just sligtly. But I am unable to save using .xlsm format. Any ideas? Saving .xlsx works fine. Thanks Sub Copy2_NewWB() Dim mySourceWB As Workbook Dim mySourceSheet As Worksheet Dim...

Hi everyone! Hope you can help me with this as I found a code to create new workbooks but I cant's seem to bring it together. I have a workbook to create folders based on some data I paste into a group of rows. For each row it creates a folder. I got this to work quite well but now I also want...

Good afternoon, all! Newb to VBA here and was hoping someone could help me out with a simple problem I have. I have a rather large spreadsheet that I'll simplify and break down below: <tbody> Merchant Customer Address1 Address2 Shop A Customer M Address M1 Address M2 Shop A Customer...

Afternoon geniuses for VBA, I have an issue with part of a code written to open an excel workbook, add info in, change the name based on information entered into a VBA userform, and save it into a new directory. This used to work, but since adding the lines denoted below with a £ at the...

Hi, I am looking to create a button on a worksheet which, when pressed, will unprotect, select a certain area of cells, copy, then open a new workbook and paste (special values, source column width) into the new workbook. The final code would have to re-protect the cells that had originally been...