Run Module within another database?

[cyborgoddess]

Well I have solved it to some extent. I am able to run my script without crashing and get the values I need. It just takes 2 - 3 hours, where I clocked it and getting it from Access to Excel & calculated takes under 3 minutes, if I can get it back into Access to resume my calculations, I can cut that down to 15 minutes.

 

[smercer]

if I can get it back into Access to resume my calculations, I can cut that down to 15 minutes.

I recommend doing that with a linked table, that way you do not have to inport the data all the time, and you do not have the 15 minute wait.

also do you really need to have the import the data in to excel? If you had a excell link you would be saving directly into excel on the fly.

In this way you would have a linked excel table for inputing data to sheet 1 and another to show the calculated results in sheet 2 for out put.

does this help? please respond.

 

[cyborgoddess]

Kind of ... I've thought about parts of the list (calculated 5 year annualized returns, for example) and bringing that back in - which is fine, but I do need to keep a list of the month by month returns. Maybe if I make a cross tab out of the cross tab I can convert it back?

 

[smercer]

I do need to keep a list of the month by month returns.

Then have a third sheet for saving the month by month returns. How the values are transfered could be done in either excel (via macro) or access (via a linked table and append query)

does that help?