DIM and SET how to ?

[Wade LEES]

Hi

i need help
i need to have a macro that will allow me to copy/create formulas
between two work books

the work book where the button containing the macro is placed will all ways have a different name. when the button is pushed it will open a book that will all ways have the same name and then copy info from it and the past it in the work where the macro button is

i know how to make the macro but its the set and the dim that i cannot get right pleas help
thank you
wade

[royUK]

something like

Please Login or Register  to view this content.

[Wade LEES]

must this be a sub all on its own or can i add to it like this

Please Login or Register  to view this content.

and it not working when i dothis

[karan]

Wade LEES,

Kindly modify your earlier post by writing the code in Code Tags so that it is easy to read. Refer Rule 3 of Forum Rules.

Thanks.

--Karan--

[Wade LEES]

Sorry is that better

[shg]

Please change the QUOTE tags to CODE tags.

[Wade LEES]

ok sorry about that i have changed and now know how to do use the code tags sorry once again

any ideas on my problem

[shg]

I don't know what you're trying to do.

[Wade LEES]

OK so the workbook that has the code below is found in a workbook that is called BULK120909 now but it will have many different names so the code i am trying to use below needs to understand that it must all ways return the info from the workbook that it opens back to the BULK120909 but as i said the BULK120909 will be called BULK150909 next week and so that means that if the macro records it as BULK120909 then when the name of the book changes the macro will no longer work and so i asked here and if you look above you will see the ROY gave me an answer which i adapted to my code but it is not working

Please Login or Register  to view this content.

please pleas pleas

thank you Wade

[royUK]

You said you had the basic code, but I don't believe you have. Much better to say what you want to do. As it is it's hard to folow what you are attempting. You need to specify sheets to work with.

You can't use the variable in the formula like that

[shg]

Maybe like this, but just guessing.

Please Login or Register  to view this content.

[Wade LEES]

Ok ROY

Here it is

in my work book called bulk120909 i have placed a button i need to attach a macro to.

the marco must when the button is pushed open a work book called
Mimmos Issue Sheets MONDAY.xls.xls
which is found in my C:\ drive and i have put this path in my workbook (bulk120909) on a sheet called BULK SHEETS in H2

it must then go to bulk120909 BULK SHEET I331 and insert a formula that will take the figer it findes in Mimmos Issue Sheets MONDAY.xls.xls on PIZZA SHEET 4p and sum that with the figer it findes on Mimmos Issue Sheets MONDAY.xls.xls PASTA SHEET P4 and then return the value to bulk120909 BULK SHEET I331


i need it to do this for about 2000 different entry's this is just one
it is basically taking numbers it finds on the other work book and placing their sum totals in the bulk120909 but as i said the bulk120909 will have a different name from week to week


here is the original code i made

Please Login or Register  to view this content.

thank you
Wade

[royUK]

Have you looked at Shg's suggestion?