Hi, I am also agree with that. If u want to manipulate Excel by getting data from Access, U need to be clear about your needs or expectation. For example I have just created a Staff Database Tool in Excel, which retrives its data from Access Database. I can help u with codes, if it helps.
Regards, Deepak Rai On Mon, Dec 7, 2009 at 6:44 PM, Paul Schreiner <schreiner_p...@att.net>wrote: > 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 > -- Thanks, Deepak Rai -- ---------------------------------------------------------------------------------- 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
