Use a macro in one workbook to change another workbook?

Hello,

I have designed a simple userform with a button that fires a macro. This macro creates multiple copies of workbook and save them in another folder.

As a part of this macro I want to open the copy, replace the data in two tabs with real values, delete the remaining tabs, save and close.

Can this be done?

Cheers

Could this not be doen when you create the new workbook?

You need to explain more fully

What your code does, probably see the code

This my first real attempt at doing some major VBA coding so please don't be too hard on me! I hope it makes sense but it does work perfectly fine.

Years_combo is the first combo box
Combobox1 is the second combo box

Please Login or Register  to view this content.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

You have potential problems with your code - you don't state the sheet to use in the code, so Range(whatever) will be on whichever sheet is active at the time.

Also, you don't need to select sheets & ranges, this will only slow your code.

By real values do you mean replace formulas with values?

See if this works, it replaces your run code on the userform

Please Login or Register  to view this content.