Dear Harpreet Try to download Microsoft Vba MSDN , It will provide best and
Hygienic help. Hope it Will Help. Happy to help :) Shyam On Thu, Mar 4, 2010 at 5:47 PM, Harpreet Gujral <harpreetguj...@gmail.com>wrote: > Its a good example for learning. > > Can you share any links or resource from where one can learn, how to use > this 'shell object', in a more advanced way? > > Thanks > > > Harpreet gujral > > Sent on my BlackBerry® from Vodafone Essar > ------------------------------ > *From: * rf1234 rf1234 <rfhyd1...@gmail.com> > *Date: *Thu, 4 Mar 2010 11:37:10 +0530 > *To: *<excel-macros@googlegroups.com> > *Cc: *<harpreetguj...@gmail.com> > *Subject: *Re: $$Excel-Macros$$ Shell Object > > Dear Harpreet > > You Can Communicate with. > 1.windows registry > 2.shell programme. > using shell object in vba. > > > > > > ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' > > Option Explicit > Const SW_SHOW = 1 > Const SW_SHOWMAXIMIZED = 3 > > Public Declare Function ShellExecute Lib "Shell32.dll" Alias > "ShellExecuteA"_ > (ByVal hwnd As Long,_ > ByVal lpOperation As String,_ > ByVal lpFile As String,_ > ByVal lpParameters As String, _ > ByVal lpDirectory As String,_ > ByVal nShowCmd As Long) As Long > > Sub RunYourProgram() > Dim RetVal As Long > On Error Resume Next > ''''''I AM OPENNING THE NOTEPAD.EXE PROGRAMME > ''''''YOU CAN OPEN ANY PROGRAMME OF YOUR CHOICE > ''''''YOU JUST HAVE TO GIVE THE FULL PATH FOR IT > ''''''AS I HAVE MENSION > ''''''C:\WINDOWS\system32\notepad.exe > > RetVal = ShellExecute(0, "open", "C:\WINDOWS\system32\notepad.exe", > "Open notepad Programme",_ > "", SW_SHOWMAXIMIZED) > End Sub > > > > > > ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' > > Hope it will help. > Happy To Help > :) > Shyam > > > > > > > > > On Thu, Mar 4, 2010 at 10:02 AM, Harpreet Gujral <harpreetguj...@gmail.com > > wrote: > >> Hi shyam, >> >> Actually I am very new to excel VBA, I have seen some codes which use >> shell object in order to make use of some other application. Idea is to >> learn how to use shell object >> >> Harpreet gujral >> >> Sent on my BlackBerry® from Vodafone Essar >> ------------------------------ >> *From: * rf1234 rf1234 <rfhyd1...@gmail.com> >> *Date: *Thu, 4 Mar 2010 00:22:07 +0530 >> *To: *<excel-macros@googlegroups.com> >> *Cc: *<harpreetguj...@gmail.com> >> *Subject: *Re: $$Excel-Macros$$ Shell Object >> >> Dear Harpreet Ji >> Please make us more clear about shell of vba,we can help when >> we got clear image about requirements. >> >> >> hope it will help. >> happy to help. >> :) >> shyam >> >> >> >> >> >> On Tue, Mar 2, 2010 at 12:37 AM, Christopher Luka < >> christopher.l...@gmail.com> wrote: >> >>> The Shell command allows you to run other programs from Excel VBA. For >>> example, you could type the following to open up Notepad in Windows: >>> >>> Shell "Notepad.exe" >>> >>> Make sense? >>> >>> Chris >>> >>> On Sun, Feb 28, 2010 at 10:45 AM, Harpreet Singh Gujral < >>> harpreetguj...@gmail.com> wrote: >>> >>>> Hi Group, >>>> >>>> Some of the VBA Macros use shell object in their codes. >>>> >>>> Can somebody help me understand what is it all about? >>>> >>>> Thanks >>>> >>>> Harpreet Gujral >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our Facebook Group @ >>>> http://www.facebook.com/group.php?gid=287779555678 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> HELP US GROW !! >>>> >>>> We reach over 6,800 subscribers worldwide and receive many nice notes >>>> about the learning and support from the group.Let friends and co-workers >>>> know they can subscribe to group at >>>> http://groups.google.com/group/excel-macros/subscribe >>>> >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our Facebook Group @ >>> http://www.facebook.com/group.php?gid=287779555678 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,800 subscribers worldwide and receive many nice notes >>> about the learning and support from the group.Let friends and co-workers >>> know they can subscribe to group at >>> http://groups.google.com/group/excel-macros/subscribe >>> >> >> > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
