Create an image in VBA

  • Thread starter Thread starter aclelland
  • Start date Start date
A

aclelland

Hiya,

I have been given a task to do which involves generating a graph
inside Access 2003 using VBA. I then have to output the image as a
jpg, gif or bmp.

I'm just in the early stage of planning this and I really have no idea
which direction to go in at the moment because I have never done any
image creation in VBA.

Any suggestions of tutorials, tools or modules which may help will be
appreciated

Thanks,
Alan
 
Hiya,

I have been given a task to do which involves generating a graph
inside Access 2003 using VBA. I then have to output the image as a
jpg, gif or bmp.

I'm just in the early stage of planning this and I really have no idea
which direction to go in at the moment because I have never done any
image creation in VBA.

Any suggestions of tutorials, tools or modules which may help will be
appreciated

Thanks,
Alan
Click to expand...

VBA was not designed to do this kind of thing. However, there are ActiveXgraph
libraries you might be able to use. I don't know if any of these will save a
graph as a file, though. One good one (expensive, but very professional) is
called "Lead Tools" (or is it "Leed Tools"??)

At worst, it is always possible to use the native Windows GDI functions and file
creation API's to do it. But you need to know how to use them, and they can get
tricky, especially with the new Windows Vista.
 
Back
Top