User GetOpenFileName method for the same. attached is an example workbook
_________________________________________________________________________________________________ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know." --- On Fri, 29/8/08, nani <[EMAIL PROTECTED]> wrote: From: nani <[EMAIL PROTECTED]> Subject: $$Excel-Macros$$ Re: creating powerpoint presentation To: "MS Excel & VBA Macros" <excel-macros@googlegroups.com> Date: Friday, 29 August, 2008, 1:15 PM Thanks for your help. i have one more question... i just want to browse folders and select one excle file, without any predefined file name in program itself. Thanks, GK On Aug 28, 5:34 am, Alokeshwar Tiwary <[EMAIL PROTECTED]> wrote: > Opening Power Point is easy: > > Sub OpenPPT() > Application.ActivateMicrosoftApp xlMicrosoftPowerPoint > End Sub > > _________________________________________________________________________________________________ > "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know." > > --- On Tue, 26/8/08, nani <[EMAIL PROTECTED]> wrote: > > From: nani <[EMAIL PROTECTED]> > Subject: $$Excel-Macros$$ creating powerpoint presentation > To: "MS Excel & VBA Macros" <excel-macros@googlegroups.com> > Date: Tuesday, 26 August, 2008, 10:18 PM > > Hi All, > > i just want to create simple power point presentation through vba. > > if i click Run, one blank ppt should open. > > can anybody give write it for me? > > Thanks, > GK > > Add more friends to your messenger and enjoy! Go tohttp://in.messenger.yahoo.com/invite/ Get an email ID as [EMAIL PROTECTED] or [EMAIL PROTECTED] Click here http://in.promos.yahoo.com/address --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
New Microsoft Excel Worksheet.xls
Description: MS-Excel spreadsheet
