Hi,

That idea worked great! Thanks for that....I'm gonna have to construct
one super huge file but its a neat way of getting the job done!

For anyone (like myself) completely new to this stuff, heres how I did
it...

Sub UpdateExtSheet1()
' Open External Sheet
Workbooks.Open Filename:="G:\sheet1.xls"
Windows("sheet1.xls").Activate
' Macro I wish to run goes here
---------------------
' Macro ended

' Save and close external sheet

ActiveWorkbook.Save
ActiveWindow.Close


Thanks again
Keilan