Reports in Excel
 

Hello All,

I have some data in Excel and i have created a customised
form in VBA for the users to select the data based on some
criterias.Once they select the options, the program
searches for the data that meets the query and after that
it needs to prepare one report which can be sent to
somebody.

The report has to be in a readable format like a HTML
page. Initially i was tempted to use Access reports option
(which can be exported to a html file!!) but my source
data cannot be exported to Access due to its structure.

The one option that comes to mind is, making the VBA
program to generate one html page dynamically.. but i want
some images also to be put in..(which won't work when send
out to somebody!!!).

I hope i made my case clear here.

Could someone please help me in solving this case..I want
to prepare a report dynamically which can then be sent
out..the report format has to be in readable format..no
conditions...pdf..html...anything..but not another excel
file!!

Many thanks
Sri