Convert a Excel Module to Access Module 1

[SaturnSeven]

I have written a excel module that extracts a query from a database to a excel sheet(via ActiveSheet.QueryTables.Add) then does some calculation, formating, pivot tables etc.

I would like to put this onto the database so it can be run by other users.

I.e Instead of running a excel procedure that connects to access and then formats in excel. Run a Access procedure that "exports" data to excel and then formats.

What's the best way forward ?

Any help would be greatfully recieved.

 

[rubbernilly]

Here is a thread with information on manipulating data into Excel:

thread705-1137319

I'm sure there are other ways, but this would be a start.

 

[SkipVought]

Hi,

And what would be the benefit of doing it from Access?


Skip,

_{[red]Be Advised![/red]
A wee deranged psychic may be runnin' around out there!
SMALL MEDUIM @ LARGE}

 

[SaturnSeven]

The reason for doing it is so that it can sit along sit other reports in the database and by accessable by other users. I can not create the report using access only.