I suspect you'll be waiting quite a while. adding a "browse button" is quite confusing. You might as well say: "I'd like to add a "take the dog for a walk" button" Because you can't do that with Access either.
the problem is that YOU know what you mean by "browse" but no one else does. What we can GUESS from your question is that: A) You have an MS-Access2007 database. B) You have an Excel 2007 workbook. C) You'd like to GET data from the Ms-Access database INTO the Excel2007 file. D) You want a button to do it. Now, what do you need help with? Writing a macro to retrieve data from MS-Access? Defining which data elements to retrieve? Or assigning the macro you already have to a button? Or do you just want to take the dog for a walk and start over when you get back? (just kidding) Paul ________________________________ From: Chanti-Hyderabad <ramesh1...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Mon, December 7, 2009 5:11:04 AM Subject: $$Excel-Macros$$ Re: Add brwose button to MS Excel to retrieve data from MS Access 2007 Hi Gurus, Awaiting for your help..Thanks On Dec 1, 5:23 pm, Chanti-Hyderabad <ramesh1...@gmail.com> wrote: > Hi Excel Gurus, > > Hope this new post find you all well. > > I would like to add a 'Browse button' (command button) to my excel > 2007 file, which should pull the data from MS Access 2007. > > I hope its a bit confusing request, please do let me know if you need > any further clarification. > > Regards--- -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
