Help with Linking

[mkerstei]

I need to do three things, if you can answer any of them that would be great.

First, is there a way to make a macro that goes directly to the "Open File" screen? What about linking it to a folder name?

Second: I have a worksheet set up to pull information from a second sheet, which needs to be imported first. All the equations return #REF until the text file is imported, which is named Sheet1 by default. I wrote all my equations to pull from Sheet1, but if a new sheet gets imported, I need it to pull from that sheet, Sheet2 (default). My equations won't change to Sheet2, or Sheet3, or whichever, is there a way I can do this?

Third. I am trying to set up a summary sheet that pulls from separate workbooks. Is there any way or macro that will let this summary book automatically pull the same cells from ANY new excel file put in the folder? If not, is there a way to have the summary page automatically update off of the workbooks put into it every time it opens?

Let me know if you think of anything...thanks.

[eider]

Re 2d item, you could try copying the data from sheet 2 to sheet 1. If you
want to keep sheet 1 data, copy it to another sheet first.

"mkerstei" wrote:

>
> I need to do three things, if you can answer any of them that would be
> great.
>
> First, is there a way to make a macro that goes directly to the "Open
> File" screen? What about linking it to a folder name?
>
> Second: I have a worksheet set up to pull information from a second
> sheet, which needs to be imported first. All the equations return #REF
> until the text file is imported, which is named Sheet1 by default. I
> wrote all my equations to pull from Sheet1, but if a new sheet gets
> imported, I need it to pull from that sheet, Sheet2 (default). My
> equations won't change to Sheet2, or Sheet3, or whichever, is there a
> way I can do this?
>
> Third. I am trying to set up a summary sheet that pulls from separate
> workbooks. Is there any way or macro that will let this summary book
> automatically pull the same cells from ANY new excel file put in the
> folder? If not, is there a way to have the summary page automatically
> update off of the workbooks put into it every time it opens?
>
> Let me know if you think of anything...thanks.
>
>
> --
> mkerstei
> ------------------------------------------------------------------------
> mkerstei's Profile: http://www.excelforum.com/member.php...o&userid=25688
> View this thread: http://www.excelforum.com/showthread...hreadid=392164
>
>