Hi, i have a little problem that i am not sure of how to solve.

I have an access database running, which eventually is giving m
reports. These reports are built to look like the original reports
which were excel reports.

These access reports are pretty uncomfortable though, and so i woul
like to create excel reports out of the database in access.

So I thought about taking the old excel files, exporting the list wit
the results (only the numbers, not any formating or so) in a new shee
in that excel file, and linking all data in the excel report to th
sheet with the info. I would then hide the excel sheet, and all I'
have to do, is to export the data in the future in that hiden sheet an
zoom, i got the report in excel. I thought this to be a pretty goo
way, but maybe one of u knows a better one too.

Now the thing is, I don't want to keep the excel file around. Like
want a button in the access database "create excel report", which the
in VBA starts excel, creates a new workbook and creates the report tha
i described above.

However, I don't want to enter all the formating info etc. manually i
VBA skript.

So what I hope to be possible is to open the old excel file an
excecute a function like "simulate buildup of this page in VBA". Th
result should be a makro that constructs a new excel file that look
exactly like that one, specifying all the colors, fonts, texts, etc...

Does something like this exist? Is there a way to do it? Or am I jus
way off? What is the best way to adress such a problem?

Thanks for reading this, anyho

--
Message posted from http://www.ExcelForum.com