Shyam, Do you have the link to download MSDN VBA library
Thanks Harpreet Gujral On Thu, Mar 4, 2010 at 5:57 PM, rf1234 rf1234 <rfhyd1...@gmail.com> wrote: > 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
