how to make activesheet use my activated sheet

[dmcgov]

i have this routine that copies the module1 and userform1 from one spreadsheet to another.

but on this new project, its not working as expected. code below.

Please Login or Register  to view this content.

as you can see, im activating PO xx1, then i want the activesheet to pick up the name and copy over the modules and userforms.

can anyone assist?

[xlnitwit]

Hi,

That code is somewhat confusing! If you wish to import to the active workbook you must use

Please Login or Register  to view this content.

[dmcgov]

i got rid of all the comments, see code below:

Please Login or Register  to view this content.

when i run the code above, i get a run time error 60061, it says to look for form.log but i cant find it.

what can i do to make the code work right?

[xlnitwit]

That error would arise if you are trying to import the form into a workbook that already contains a form by that name.

[dmcgov]

yup, your right. that was the problem. thanks very much for that.

so i have one line in my macro that is not working right, see below:

Please Login or Register  to view this content.

how can i close my source workbook without having to save it?

[xlnitwit]

Close takes one optional argument for that very purpose

Please Login or Register  to view this content.

[dmcgov]

great, i like that. all on one line. perfect.

now i still have a problem in my macro, it is failing on this one line:

Please Login or Register  to view this content.

why wont it open PO xx1?

the error is: Run time error 9, subscript out of range.

[xlnitwit]

The syntax is actually

Please Login or Register  to view this content.

[dmcgov]

thanks xlnitwit. that fixed the issue.