Refreshing Question

[cojiro]

I have several Excel workbooks with multiple worksheets in a specific folder who's datasource is an Access database I update daily. Currently I have to open and refresh every worksheet for every workbook when I update the database.
What I'm wondering is: is there a way in VBA that I could automatically refresh and save the data for any amount of excel files that are put into a certain folder, when I update my database?

Right now this is very time consumeing and I'm sure their must be a better way.
Any advice is greatly appreciated.

 

[BSman]

How about doing the entire thing in Access? Just be sure you've got tables to store all of the necessary data.

 

[cojiro]

I would, but the people I'm doing this for are my superiors who really only work with Excel, I'm kind of stuck doing it this way.

 

[BSman]

Retrain, retrain. Find the most person most likely to adapt readily to a complete Access solution and be sure you've made things easier to do in Access (for them to get the answers then need). Get the one person using your Access solution so he/she can become your "salesman".

Good luck.

 

[jdegeorge]

cojiro

My users prefer Excel over Access but I don't give them an option. In fact, I'm in the middle of converting several complicated and redundant Excel spreadsheets to Access. To help them in the transition, I was thinking of setting the forms to look like tables rather than like forms so they don't have complete shock.

BSman is right...re-train!!

Jim DeGeorge

 

[cojiro]

It's a nice thought fellas, but we're talking about high ranking officers in my company here. I have to deliver exactly what they want. I was just hoping for an easier way to do it. Thanks for the advice anyways.