AidanEnos
Nov 14th, 1999, 07:26 AM
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 :o)
AidanEnos
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 :o)
AidanEnos