To simplify a little...
Replace the consecutive ScrollRow commands with the last one used...

ActiveWindow.ScrollRow = 12
ActiveWindow.ScrollRow = 11
ActiveWindow.ScrollRow = 10
ActiveWindow.ScrollRow = 9
ActiveWindow.ScrollRow = 8
ActiveWindow.ScrollRow = 7
ActiveWindow.ScrollRow = 6
ActiveWindow.ScrollRow = 5
ActiveWindow.ScrollRow = 4
ActiveWindow.ScrollRow = 3
ActiveWindow.ScrollRow = 2
ActiveWindow.ScrollRow = 1
'---
can be replaced with...
ActiveWindow.ScrollRow = 1
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware




wrote in message
Hello all. So this is what I'm trying to do. I have an excel
spreadsheet that I export from a program, creating a text file. This
file I have to open in excel, and then copy and paste sections into a
worksheet that contains three sheets. In this second spreadsheet,
there is a macro that runs certain checks and then makes the file into
an XML.

What I am attempting to do is create a macro that will look in a
folder on my desktop that contains around 10 of these exported text
files, run it through the copy and paste macro that i have created,
and then run the macro in the second spreadsheet. I would then like
to save both the second spreadsheet I've pasted on and the XML file.

So what I have done so far is listed below. I managed to make a
window pop up to select the files i want to run through the macro.
What I would actually prefer to do is just look in a folder and run
ALL files in there that are excel spreadsheets. I then run the copy
paste macro and select the XML macro to run and then things just sort
of stop. As i run the macro, it stops to prompt me to name the XML
file. What I would love to do (and have attempted) is to name the
file automatically a cell from the Second Workbook. I cant figure out
how to get around this propmt and name it automatically.

I would really appreciate if someone would look at what I've done. Im
really new at this and im sure theres alot of cleaning up to do. I may
have made this way more complicated then it needs to be. Thanks in
advance for your help!

-snip-

THANKS!