Hello Prakash,
I believe you can use the Windows Image Acquisition 2.0 library. http://www.microsoft.com/download/en/details.aspx?DisplayLang=en <http://www.microsoft.com/download/en/details.aspx?DisplayLang=en&id=18287> &id=18287 It includes a help file and samples in VB6 and VBScript. VB6 code requires little modification to work in VBA/Excel, but any forms would have to be redesigned. There is also a free VB6 Webcam application code at http://planetcodes.blogspot.com/2010/04/webcam-using-vb60.html. It is the source code to a small program that captures snapshots from a webcam and saves them to disk. It will need a little customizing to put the filename/link on your worksheet. The VB6 code should be compatible with Excel, but you can't import the forms directly. You can import the BAS file as a module, and open the FRM files in a text editor like notepad to view the code used. Take a look at the links and let us know how much help you still need. Asa Some other references: . http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/1e9eebcb-5abe-40 4d-882b-5cb302b771e4 . http://www.mrexcel.com/forum/showthread.php?t=502775 . http://www.codeproject.com/Articles/13389/Accessing-WebCam-in-Visual-Basic-6 . http://www.access-programmers.co.uk/forums/showthread.php?t=201902 . -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prakash Gusain Sent: Wednesday, February 08, 2012 9:22 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Capture Image using VBA You can use any excel file. I just want to trigger the webcam using VBA. Hope you guys can help me provide the solution. On Feb 8, 11:14 pm, NOORAIN ANSARI < <mailto:noorain.ans...@gmail.com> noorain.ans...@gmail.com> wrote: > Dear Prakash, > > Please share a sample workbook with excel macro group > > On Wed, Feb 8, 2012 at 8:04 PM, Prakash Gusain < <mailto:gusainprak...@gmail.com> gusainprak...@gmail.com>wrote: > > > > > I want to capture an image and save to specified location in system > > using vba. Also need the file address in the active cell. > > > Thank you in advance for your help. > > > -- > > FORUM RULES (986+ members already BANNED for violation) > > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > > will not get quick attention or may not be answered. > > > 2) Don't post a question in the thread of another member. > > > 3) Don't post questions regarding breaking or bypassing any security > > measure. > > > 4) Acknowledge the responses you receive, good or bad. > > > 5) Cross-promotion of, or links to, forums competitive to this forum in > > signatures are prohibited. > > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > > owners and members are not responsible for any loss. > > > ---------------------------------------------------------------------------- -------------------------- > > To post to this group, send email to <mailto:excel-macros@googlegroups.com> excel-macros@googlegroups.com > > -- > Thanks & regards, > Noorain Ansari > ** < <http://excelmacroworld.blogspot.com/> http://excelmacroworld.blogspot.com/>*http://noorainansari.com/* > *http://excelmacroworld.blogspot.com/*< <http://excelmacroworld.blogspot.com/> http://excelmacroworld.blogspot.com/> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to <mailto:excel-macros@googlegroups.com> excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
