problem opening workbook and assigning variable

[fredderf81]

good day all. i am trying to open a workbook, assign it a variable and use that variable later. here is what i have

Please Login or Register  to view this content.

when i try to activate it later on in another procedure using:

Please Login or Register  to view this content.

i receive an "Automation Error"

i have tried declaring it as a public variable, even a global variable and cannot get this to work.

all i'm really wanting to do is open a workbook (where the name will change depending on the book being opened), assign that workbook a variable name, and use it later in the code.

thanks!

[LJMetzger]

Hi,

Try defining it as a global variable in an ordinary code module such as Module1:

Please Login or Register  to view this content.

Lewis

[fredderf81]

thanks lewis, but i've tried that already :-/ i try to use something like this:

Please Login or Register  to view this content.

and i get that automation error again.

i have NO idea what i'm doing wrong. i will try to find a way around it after my headache goes away =)

[Norie]

Why are you opening the workbook twice?

This should open a workbook and create a variable that references it.

Please Login or Register  to view this content.

Once you have the variable referencing there's no need to activate the workbook, though it will automatically be the active workbook when you open it.

[fredderf81]

i'm sorry, i was just using that as an example...a better one would be the problem i'm running into now:

on a userform i have a button that does a few things, one is it assigns the value in cell D4 to a variable: dtest2

i have this code:

Please Login or Register  to view this content.

and thats where i'm getting my Automation error upon clicking the button.

edit** oh, and sorry Norie, yeah, i noticed that too, i deleted the 2nd line of code there opening the document twice....AND that definately fixed the problem *sigh* lol thanks!!!!

[Norie]

So this is solved?

[fredderf81]

i'm sorry!!! i usually close them...must have timed out the window. i will take care of it

[Norie]

fredder

I just wasn't sure if you had found a solution.