Tweaking existing VBA code...

[Von Pookie]

...however, I don't know how to write VBA code. What I'm using, I got help with from here.

(I had all of this typed already, but apparently my login expired...grr...anyway...)

The code I'm currently using opens 2 separate workbooks and prompts for the others to open.

I usually start entering information in a certain workbook every time. How can I set it to switch to this one workbook after it opens the one I select?

Thanks!

 

[Dave Hawley]

Hi Christy


I suspected as much! I think you will find that there is no Workbook open by the name of
"Main Directory.xls" or you have miss-spelt the name?





Workbooks("Main Directory.xls").Activate

 

[Von Pookie]

Nope, the name's spelled correctly...but that is one of the files that it should open on its own first.

It automatically opens that file and one other, then prompts for the third. I just want it to switch back to that one after it opens the one the user selects to open, and before it closes the workbook with the macro. As it is, it will stay on the last book opened. I use the main directory.xls first.

It's no big deal if I can't get this to work, I was just trying to simplify it a little further.

Thanks again,

 

[Von Pookie]

Woohoo! I managed to get it to work!

Trial and error is a pain in the butt!

Thanks,
_________________
Kristy

"There are two means of refuge from the miseries of life: music and cats." - Albert Schweitzer
This message was edited by Von Pookie on 2002-04-04 13:25

 

[Dave Hawley]

Kristy


What was the problem?

 

[Von Pookie]

I honestly don't know. I just started moving things around.