Hey all,

I'm writing a macro in MSExcel `97 and what I want to do is have the macro prompt the user for a sub directory.

I want it to default to c:\temp and prompt to get the user to c:\temp\november\110199

Then the macro will open a few files, and do some cutting and pasting and close all the files (this I already have done and works).

Next I want it to use the previous input and open the next day's directory (c:\temp\november\110299) and do the same thing.

Finally after it does this 5 times I want it to promt for input on 2 specific cells and then do a screen shot and save that to a new excel file (the screen shot part works fine as does the new file).

It's just the propmt boxes I don't know how to do.

Thanks all )

AidanEnos