Re: $$Excel-Macros$$ Capture Image using VBA
working with images !!! please, see ; http://www.youtube.com/watch?v=B1qUrTKsnGocontext=C3697427ADOEgsToPDskKiaWsIL-0TfBoVlGZ-qD8u add ins by chilexcel, Hyperlink to do with ListFolder in this group 2012/2/9 Prakash Gusain gusainprak...@gmail.com 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 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 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 excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.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 excel-macros@googlegroups.com -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- 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
RE: $$Excel-Macros$$ Capture Image using VBA
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=enid=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.comwrote: 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
RE: $$Excel-Macros$$ Capture Image using VBA
P.S. You may also want to see: Windows Image Aquisition Automation Layer (MSDN Reference) http://msdn.microsoft.com/en-us/library/ms630827%28v=vs.85%29.aspx Getting Started with Samples (MSDN) http://msdn.microsoft.com/en-us/library/ms630818%28VS.85%29.aspx Shared Samples (MSDN) http://msdn.microsoft.com/en-us/library/ms630826%28v=vs.85%29.aspx Asa From: Asa Rossoff [mailto:a...@lovetour.info] Sent: Thursday, February 09, 2012 10:18 AM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Capture Image using VBA 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=enid=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.comwrote: 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
Re: $$Excel-Macros$$ Capture Image using VBA
Dear Prakash, Please share a sample workbook with excel macro group On Wed, Feb 8, 2012 at 8:04 PM, Prakash Gusain gusainprak...@gmail.comwrote: 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 excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.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 excel-macros@googlegroups.com
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 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 gusainprak...@gmail.comwrote: 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 excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.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 excel-macros@googlegroups.com