Hi,

I have a very large Excel spreadsheet with formulas all calculated through a macro file. I've brought the file into Access and can play around with it just fine. However, when I want to make a change and re-run the macro, is there a way to do this all within Access? I don't want to have to go back to Excel each time, re-run the macro, re-import the spreadsheet, and start all over with my queries. Any tips for a new-to-macros, new-to-Access gal?

Thanks!

Welcome to the forum.

What are the macros doing exactly? Are you wanting to replicate the macros that you used to do in Excel in Access? Or will you be continuing to pull data from Excel?

Access and Excel are very different beasts. In Access you would normally create queries to derive calculations and normally you would not store them - just calculate the formulas when needed.

Chris

The macros are calculating the data that I'm summing in Access. Basically, for each individual butterfly, I have a set of behaviors and a time associated with the start of each behavior. The macros are calculating the time spent in each behavior--a butterfly might start flying at 1:03, then land at 1:05, then fly from 1:06-1:07. So the macros tell me that first the butterfly spent 2 minutes flying, then 1 minute sitting, then one minute flying. I'm using Access to sum all these: for one butterfly, how much time was spent sitting vs flying. Does that make ANY sense? So if I find a mistake in Access and need to tweak one of the rows of behavior, I need to re-run the macro and get the new time values then re-import into Access. This process is actually a good way for me to check for errors, but it sure takes a while. I guess I was looking for an easy way to just put the whole dataset in Access and run the macros there without having to go back to Excel, but that might be pushing it :)

Thanks for trying to understand this jibberish!!