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

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