C
c mateland
Excel 2003
WinXP
IrfanView 3.99 (an image viewer)
IE 6
CoolPDF (a print driver for PDF creation)
In an Excel workbook, I enter details of online transactions that I
perform over the Web. When a confirmation page appears in IE, I
printscreen, open IrfanView and paste the screenshot, then I save the
graphic into a specific folder. I want to automate this using Excel
VBA, but would like others' thoughts on the best approach. Here's the
scenario and variables I'll have in place:
- In a worksheet, I have a list of records, each being a transaction.
- The active cell will be in the targeted record when excecuting the
routine from an insheet button.
- When excecuting the routine, the IE confirmation window is the
previous task window.
- The path string for saving the image for that record is in column J.
- Upon click of the button, I want a screencapture of the confirmation
window saved where specified.
I'm trying to avoid sendkeys, but will use them if necessary. I toyed
with getting IE to print as PDF (choosing CoolPDF as printer) and save
as specified, but unsuccessful. I also experiemented with printscreen
and paste into a workbook then print that as PDF and save it, which
was pretty successful, but I didn't care much for the quality.
Anyway, before I spin my wheels in the wrong direction, I'd like to
know any thoughts.
Thanks,
Chuck
WinXP
IrfanView 3.99 (an image viewer)
IE 6
CoolPDF (a print driver for PDF creation)
In an Excel workbook, I enter details of online transactions that I
perform over the Web. When a confirmation page appears in IE, I
printscreen, open IrfanView and paste the screenshot, then I save the
graphic into a specific folder. I want to automate this using Excel
VBA, but would like others' thoughts on the best approach. Here's the
scenario and variables I'll have in place:
- In a worksheet, I have a list of records, each being a transaction.
- The active cell will be in the targeted record when excecuting the
routine from an insheet button.
- When excecuting the routine, the IE confirmation window is the
previous task window.
- The path string for saving the image for that record is in column J.
- Upon click of the button, I want a screencapture of the confirmation
window saved where specified.
I'm trying to avoid sendkeys, but will use them if necessary. I toyed
with getting IE to print as PDF (choosing CoolPDF as printer) and save
as specified, but unsuccessful. I also experiemented with printscreen
and paste into a workbook then print that as PDF and save it, which
was pretty successful, but I didn't care much for the quality.
Anyway, before I spin my wheels in the wrong direction, I'd like to
know any thoughts.
Thanks,
Chuck