Convoluted process

[ppete]

Hi All,

I just want to get your opinion as to whether this process seems overly complicated, or do any of you have similar issues?

I press a button on an access form, this sets off a macro that opens a new excel application, opens an existing spreadsheet, runs a macro within this spreadsheet that opens up another spreadsheet formats it (moves columns, formats dates,deletes total subtotals) then saves it as something else.

The final spreadsheet is then imported into an access table and further 14 queries are ran on the data including make table, append and select queries. After this 3 reports are printed off.

I'd like to simplify things but I'm not quite sure how to go about it.

Pete

 

[TerpInMd]

Why not import the spreadsheet into the dB and manipulate it there instead of basically using Access to kick off the application?

 

[ppete]

Thanks for the reply Terp,

I didn't think that I would be able to do all the formatting that I needed to do in Access but looking at it now, I just might.

All the best,

Pete