The two solutions below seem to do pretty much the same thing: "ryguy72" wrote in message for the suggestion, and the code, Ron.
OTIXO ALTERNATIVE CODE
You can create a workbook template(real template file) workbook with your code and buttons and load that The code now use this to create a new workbook I’m confident that this is doable, but I’m not quite sure how the code will look. So, how can I modify your code to do the filtering, just like you do now, but also do logic #1 and #2 described above? I’ve been working with Excel for many tears. Sheets("Sheet1").Copy Before:=Workbooks("Book1").Sheets(1) Here are a couple lines form that recorded macro: I recorded a tiny macro to copy the sheet and save it, and indeed, the ActiveX buttons are in the newly created Sheet!! I think I have to figure out a way to modify your code to filter, copy the SHEET, and save the WB as the name of the value that was filtered, loop, end. If I copy/paste unique values in ColA, the buttons don’t get picked up. #2) I have two ActiveX buttons that sit in rows 1:3. #1) When I tried the code in the two links above, the multiple resulting files didn't have the macros that I had in the template. I want to break this large data set up for each change in ColA, and name the file as the vlaue in ColA, so your macro is ALMOST perfect. Here's the layout:ĬolA=AcctNo., ColB=AcctName, ColC=AcctOwner, ColD=AcctType, etc, over to ColAJ I figured out a way to do this much easier that what I described before. Thanks for the suggestion, and the code, Ron. I'm pretty sure it is just a couple lines, or some such thing. What do you think? Do you need me to post ALL the code? I know you developed it so you are very well acquainted with it. I must be missing a line or two of code, or maybe a couple lines of code are out of order. I get the same error as described above this line is yellow: Workbooks.Open ("C:\Users\New User\Desktop\Coding\Microsoft Excel\Citibank\Breakup Files\Template.xls") Set WSNew = Workbooks.Add(xlWBATWorksheet).Worksheets(1) This is where are the Account numbers are, this is where the modules are, and the two ActiveX buttons are on the top three rows 1:3. I’m running the code from inside the Template.xls. Reopening will cause any changes you make to be discarded. Now, I get a message that says this: ‘Template.xls is already open.
Workbooks.Open ("C:\Users\New User\Desktop\Coding\Microsoft Excel\Breakup Files\Template.xls") Unfortunately I’m getting a new error now. "ryguy72" wrote in message again, Ron! Those couple lines of code look pretty interesting. I have two buttons in the Template Excel file that need to be in each of the files in my folder.Ĭreate a xlt (template file) with a different name #2) I need to copy/paste 2 buttons ActiveX Controls from the Control Toolbox. I created all the files with this macro: The reason I have so many similar, but different, Excel files is because I have different client accounts each account is represented by a single Excel file. So, I literally want to copy/paste these three modules to hundreds of other (virtually) identical Excel files. #1) I need to add a few Modules, from a single Template Excel file to MANY identical files in one of my folders. "ryguy72" wrote in message used the macro at this site, for batch processes, with great results!! Maybe it is easier to use a empty template workbook with the modules in it and use it in this macro Also, please let me know if I can copy/paste ActiveX Controls from one Workbook to multiple Workbooks. Please let me know if I can copy/paste modules from one Workbook to multiple Workbooks. I have two buttons in the Template Excel file that need to be in each of the files in my folder. I need to copy/paste 2 buttons ActiveX Controls from the Control Toolbox. I’m wondering if I can use it to somehow perform other operations on MANY files in a folder. I’ve used the macro at this site, for batch processes, with great results!!
0 kommentar(er)
