vajpaca
10-22-2012, 12:48 AM
Hi everyone,
I have been using Excel 2007 and VBA for sometime, I have designed a few excel macros which I use for my work.
I need help in finding a solution to one problem, I am stuck with and unable to find a solution to... which is.....
I have a form containing many images which requires data to be filled before using of the same. I have all the required data in Excel file...
I need to fill 1500 of these forms, which overwise will require manual filling after getting photocopy of the form.
I can scan the form into a PDF/Image file... as may be required.
I need to know is there a way where I can use the scanned image/PDF and overlap data from excel files over it in the background and send the same to printer for printing a filled form.
OR
Can we prepare a custom report in VBA which has the scanned image and data is overlapped there and printed
OR
Can we print the data directly on pre-printed blank forms (by arranging data accordingly)
This would be of great help, if anyone can guide me...
Thanks in advance for your efforts.....
I have been using Excel 2007 and VBA for sometime, I have designed a few excel macros which I use for my work.
I need help in finding a solution to one problem, I am stuck with and unable to find a solution to... which is.....
I have a form containing many images which requires data to be filled before using of the same. I have all the required data in Excel file...
I need to fill 1500 of these forms, which overwise will require manual filling after getting photocopy of the form.
I can scan the form into a PDF/Image file... as may be required.
I need to know is there a way where I can use the scanned image/PDF and overlap data from excel files over it in the background and send the same to printer for printing a filled form.
OR
Can we prepare a custom report in VBA which has the scanned image and data is overlapped there and printed
OR
Can we print the data directly on pre-printed blank forms (by arranging data accordingly)
This would be of great help, if anyone can guide me...
Thanks in advance for your efforts.....