Running Fireworks from Access

  • Thread starter Thread starter Antonio
  • Start date Start date
A

Antonio

I am developing an ASP web site using Access. I am using a routine in
VBA to pick photos and instert their path in the database. The routine
also copies the photo to the images folder. At that point I would like
the module to run a function that would open fireworks, run a script
that would resize the chosen photo as a thumbnail, place the resized
photo in another folder and close fireworks.
The only piece missing is how to call the Fireworks routine from
MSAccess.

Any help available?
 
Antonio said:
I am developing an ASP web site using Access. I am using a routine in
VBA to pick photos and instert their path in the database. The routine
also copies the photo to the images folder. At that point I would like
the module to run a function that would open fireworks, run a script
that would resize the chosen photo as a thumbnail, place the resized
photo in another folder and close fireworks.
The only piece missing is how to call the Fireworks routine from
MSAccess.

Any help available?
Click to expand...

Not much, it seems. Is Fireworks an automation server? Or does it have
command-line options that can be used to start it and run a specified
script?
 
There may be alternatives to automating Fireworks. The article at the
following URL describes a VB6 solution to creating thumbnails . I haven't
tried it myself, but it looks as though it could probably be adapted to work
with VBA. It uses a third-party image processing library called FreeImage,
but it is a free, open-source library. The first of the two links to the
page where the library can be downloaded (the one with the text 'FreeImage')
seems to be broken, but the second one (with the text 'features') will get
you there.

http://www.cgi-interactive-uk.com/screen_capture_VB6_thumbnail_creation.html
 
Brendan Reynolds said:
There may be alternatives to automating Fireworks. The article at the
following URL describes a VB6 solution to creating thumbnails . I
haven't tried it myself, but it looks as though it could probably be
adapted to work with VBA. It uses a third-party image processing
library called FreeImage, but it is a free, open-source library. The
first of the two links to the page where the library can be
downloaded (the one with the text 'FreeImage') seems to be broken,
but the second one (with the text 'features') will get you there.
Click to expand...
http://www.cgi-interactive-uk.com/screen_capture_VB6_thumbnail_creation.html

Now that you mention it, IrfanView can be run in batch mode, so I
believe it could be used to do such a conversion.
 
Back
Top