Automating Microsoft Excel

[SHAWTY721]

I am trying to automate a process in order to make a monthly routine less time consuming. I have an Excel spreadsheet and an Access database. The spreadsheet contains formulas that calculate values for different fields based on values that are in other fields. The calculation all starts with the field that I am trying to automate to pull the information right from the Access database. Currently the users have to enter the information manually which is the majority of the process. I have thought about using the 'Import External Data' feature that is in Microsoft Excel, but I was wondering is there another way to accomplish this goal. I also need to be able to filter the information based on which company, department, location number, and account the information belongs to.

 

[AnotherHiggins]

Turn on your macro recorder (Tools > Macro > Record New Macro), then use the Import External Data. You can edit the query that is pulling the data and do your filtering there.

Post the code that is generated and we can help you clean it up.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

I'd make a slightly different suggestion.

First ADD the querytable.

THEN turn on your macro recorder, and record EDITING the query and RETURNING data to Excel.

The resulting code is closer to what you will need.

Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}