$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Dear Sandeep, follow a link to an example of integration excel + access. And excel working with front-end Link: http://www.4shared.com/rar/z6j4vQEO/Excel-Access.html tks. regards. Basole. Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: > > Hi > > Kindly note that sql.request is functional in MS Excel 2007 but not in MS > Excel 2010. Could you please let me know any VBA code that would be a > substitute for sql.request. > If yes, Please let me know with the help of an example. > We use sql.request to transfer data from MS Access to MS Excel in version > 2007 > > > Thanks & regards, > *Sandeep Kumar Baranwal* > Business Analyst > Credit Risk Methodology & Wholesale Basel,Genpact > Gurgaon > India > Mob:-+91-8588802543 > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Hi Basole I am glad you understood my requirement. Kindly share the models that use excel to ms access with tables and indexes at your convenience. Looking forward to your generous help once again. Thanks & regards, *Sandeep Kumar Baranwal* Assistant Manager Credit Risk Methodology & Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 On Sat, Nov 9, 2013 at 8:44 AM, Basole wrote: > > Dear Sandeep, it seems to me that this code was used in excel 2003 with > connection via the "ODBC" nowadays use more connection "ADO" "DAO" etc.. > Well I have some models use excel to ms Access with tables and indexes, > which I will share with you. > > Regards, > > Basole. > > > > > > > Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar > Baranwal escreveu: >> >> Hi >> >> Kindly note that sql.request is functional in MS Excel 2007 but not in MS >> Excel 2010. Could you please let me know any VBA code that would be a >> substitute for sql.request. >> If yes, Please let me know with the help of an example. >> We use sql.request to transfer data from MS Access to MS Excel in version >> 2007 >> >> >> Thanks & regards, >> *Sandeep Kumar Baranwal* >> Business Analyst >> Credit Risk Methodology & Wholesale Basel,Genpact >> Gurgaon >> India >> Mob:-+91-8588802543 >> >> -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Dear Sandeep, it seems to me that this code was used in excel 2003 with connection via the "ODBC" nowadays use more connection "ADO" "DAO" etc.. Well I have some models use excel to ms Access with tables and indexes, which I will share with you. Regards, Basole. Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: > > Hi > > Kindly note that sql.request is functional in MS Excel 2007 but not in MS > Excel 2010. Could you please let me know any VBA code that would be a > substitute for sql.request. > If yes, Please let me know with the help of an example. > We use sql.request to transfer data from MS Access to MS Excel in version > 2007 > > > Thanks & regards, > *Sandeep Kumar Baranwal* > Business Analyst > Credit Risk Methodology & Wholesale Basel,Genpact > Gurgaon > India > Mob:-+91-8588802543 > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Rupesh Patil: Hi Expert. How generate PDF file using VBA. Thanks Hi Rupesh Patil, try this: Sub Creati_PDF() Dim Filepdf As String Filepdf = "C:\Temp\FileName.pdf" ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:=MyFullName, _ Quality:=xlQualityMinimum, IncludeDocProperties:=True, IgnorePrintAreas:=False, _ OpenAfterPublish:=True End Sub Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: > > Hi > > Kindly note that sql.request is functional in MS Excel 2007 but not in MS > Excel 2010. Could you please let me know any VBA code that would be a > substitute for sql.request. > If yes, Please let me know with the help of an example. > We use sql.request to transfer data from MS Access to MS Excel in version > 2007 > > > Thanks & regards, > *Sandeep Kumar Baranwal* > Business Analyst > Credit Risk Methodology & Wholesale Basel,Genpact > Gurgaon > India > Mob:-+91-8588802543 > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Hi Basole Though not observing the literal difference between recordset and querytables, I wanted to see if the same requirement be worked out using querytables in VBA code. In Plan1 (Sheet1) you made use of ADODB.Recordset. I would like to make use of querytables(index) Kindly refer to a piece of vba code (as an hypothetical example) and the link below: Dim qt As QueryTable sqlstring = "select 96Sales.totals from 96Sales where profit < 5" connstring = _ "ODBC;DSN=96SalesData;UID=Rep21;PWD=NUyHwYQI;Database=96Sales" With ActiveSheet.QueryTables.Add(Connection:=connstring, _ Destination:=Range("B1"), Sql:=sqlstring) .Refresh End With http://msdn.microsoft.com/en-us/library/office/aa174289(v=office.11).aspx For further details on query tables , please refer : http://msdn.microsoft.com/en-us/library/office/aa174288(v=office.11).aspx Thanks & regards, *Sandeep Kumar Baranwal* Assistant Manager Credit Risk Methodology & Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 On Fri, Nov 8, 2013 at 8:10 AM, Basole wrote: > Dear Sanddep, thank you for your kindness! > Sorry, but what is the difference between recordset and querry tables? > > > > > > > Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar > Baranwal escreveu: >> >> Hi >> >> Kindly note that sql.request is functional in MS Excel 2007 but not in MS >> Excel 2010. Could you please let me know any VBA code that would be a >> substitute for sql.request. >> If yes, Please let me know with the help of an example. >> We use sql.request to transfer data from MS Access to MS Excel in version >> 2007 >> >> >> Thanks & regards, >> *Sandeep Kumar Baranwal* >> Business Analyst >> Credit Risk Methodology & Wholesale Basel,Genpact >> Gurgaon >> India >> Mob:-+91-8588802543 >> >> -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Hi Expert. How generate PDF file using VBA. Thanks On Fri, Nov 8, 2013 at 8:10 AM, Basole wrote: > Dear Sanddep, thank you for your kindness! > Sorry, but what is the difference between recordset and querry tables? > > > > > > > Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar > Baranwal escreveu: >> >> Hi >> >> Kindly note that sql.request is functional in MS Excel 2007 but not in MS >> Excel 2010. Could you please let me know any VBA code that would be a >> substitute for sql.request. >> If yes, Please let me know with the help of an example. >> We use sql.request to transfer data from MS Access to MS Excel in version >> 2007 >> >> >> Thanks & regards, >> *Sandeep Kumar Baranwal* >> Business Analyst >> Credit Risk Methodology & Wholesale Basel,Genpact >> Gurgaon >> India >> Mob:-+91-8588802543 >> >> -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > -- Thanks and Regards, Rp. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Dear Sanddep, thank you for your kindness! Sorry, but what is the difference between recordset and querry tables? Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: > > Hi > > Kindly note that sql.request is functional in MS Excel 2007 but not in MS > Excel 2010. Could you please let me know any VBA code that would be a > substitute for sql.request. > If yes, Please let me know with the help of an example. > We use sql.request to transfer data from MS Access to MS Excel in version > 2007 > > > Thanks & regards, > *Sandeep Kumar Baranwal* > Business Analyst > Credit Risk Methodology & Wholesale Basel,Genpact > Gurgaon > India > Mob:-+91-8588802543 > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Hi Basole Please accept my thanks for the links. I will go through them and would let you know if I have any issue and see their applicability in my risk domain. For the time being, the VBA code is running well so far. I want to work on a variant of it. Could it be possible for you to work on the same requirement for importing data from MS Access to MS Excel using querytables ? The version that you helped me with, uses recordset. I want to use querytables instead. Thanks & regards, *Sandeep Kumar Baranwal* Assistant Manager Credit Risk Methodology & Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 On Thu, Nov 7, 2013 at 8:39 AM, Basole wrote: > > Thank you. when you need to let me know. Take a look at this link, and has > several good choices of courses and tutorials VBA: > > > http://www.mrexcel.com/forum/general-excel-discussion-other-questions/698256-online-visual-basic-applications-course.html > > another option this great book: > > http://www.4shared.com/rar/pfq_GUuR/excel_2010_vba_and_macros.html > > thanks, > > regards > > Basole. > > > > > > Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar > Baranwal escreveu: >> >> Hi >> >> Kindly note that sql.request is functional in MS Excel 2007 but not in MS >> Excel 2010. Could you please let me know any VBA code that would be a >> substitute for sql.request. >> If yes, Please let me know with the help of an example. >> We use sql.request to transfer data from MS Access to MS Excel in version >> 2007 >> >> >> Thanks & regards, >> *Sandeep Kumar Baranwal* >> Business Analyst >> Credit Risk Methodology & Wholesale Basel,Genpact >> Gurgaon >> India >> Mob:-+91-8588802543 >> >> -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Thank you. when you need to let me know. Take a look at this link, and has several good choices of courses and tutorials VBA: http://www.mrexcel.com/forum/general-excel-discussion-other-questions/698256-online-visual-basic-applications-course.html another option this great book: http://www.4shared.com/rar/pfq_GUuR/excel_2010_vba_and_macros.html thanks, regards Basole. Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: > > Hi > > Kindly note that sql.request is functional in MS Excel 2007 but not in MS > Excel 2010. Could you please let me know any VBA code that would be a > substitute for sql.request. > If yes, Please let me know with the help of an example. > We use sql.request to transfer data from MS Access to MS Excel in version > 2007 > > > Thanks & regards, > *Sandeep Kumar Baranwal* > Business Analyst > Credit Risk Methodology & Wholesale Basel,Genpact > Gurgaon > India > Mob:-+91-8588802543 > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Hi Basole Thanks a lot for your guidance and help. It's really appreciated. So far, I have not come across any error. Will try this VBA code on some more systems. Will let you know if I come across anything related to this or otherwise. Could you please suggest on the courses or study material that would enhance my ability to optimize my skills at VBA excel ? It would be really great of you if you allow me to grow with VBA excel under your guidance. Thanks & regards, *Sandeep Kumar Baranwal* Business Analyst Credit Risk Methodology & Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 On Wed, Nov 6, 2013 at 7:33 AM, Basole wrote: > hi Sandeep,try it now with the attached > I added a function that checks if the file path exists, the module 1 > also added to check the file type Access (mdb) or (accdb) for use with the > provider Microsoft.ACE.OLEDB.12.0. > > If there is any related error, it is recommended to download the file: > Database Engine 2010 > download here: > http://www.microsoft.com/en-us/download/details.aspx?id=13255 > > Any questions I am available. > > rs. > > Basole. > > > > Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar > Baranwal escreveu: >> >> Hi >> >> Kindly note that sql.request is functional in MS Excel 2007 but not in MS >> Excel 2010. Could you please let me know any VBA code that would be a >> substitute for sql.request. >> If yes, Please let me know with the help of an example. >> We use sql.request to transfer data from MS Access to MS Excel in version >> 2007 >> >> >> Thanks & regards, >> *Sandeep Kumar Baranwal* >> Business Analyst >> Credit Risk Methodology & Wholesale Basel,Genpact >> Gurgaon >> India >> Mob:-+91-8588802543 >> >> -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
hi Sandeep,try it now with the attached I added a function that checks if the file path exists, the module 1 also added to check the file type Access (mdb) or (accdb) for use with the provider Microsoft.ACE.OLEDB.12.0. If there is any related error, it is recommended to download the file: Database Engine 2010 download here: http://www.microsoft.com/en-us/download/details.aspx?id=13255 Any questions I am available. rs. Basole. Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: > > Hi > > Kindly note that sql.request is functional in MS Excel 2007 but not in MS > Excel 2010. Could you please let me know any VBA code that would be a > substitute for sql.request. > If yes, Please let me know with the help of an example. > We use sql.request to transfer data from MS Access to MS Excel in version > 2007 > > > Thanks & regards, > *Sandeep Kumar Baranwal* > Business Analyst > Credit Risk Methodology & Wholesale Basel,Genpact > Gurgaon > India > Mob:-+91-8588802543 > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. ImportAccess1-ACE OLEDB 12.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Hi Sandeep, I did some tests and did not check any problem with "cx.connectar". also made some changes to make the sheet cleaner. changes path and table name can make in the code. as the extension "mdb" and "accdb" - this code works perfectly. Just change the file name in the path. Any questions I am available. Basole Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: > > Hi > > Kindly note that sql.request is functional in MS Excel 2007 but not in MS > Excel 2010. Could you please let me know any VBA code that would be a > substitute for sql.request. > If yes, Please let me know with the help of an example. > We use sql.request to transfer data from MS Access to MS Excel in version > 2007 > > > Thanks & regards, > *Sandeep Kumar Baranwal* > Business Analyst > Credit Risk Methodology & Wholesale Basel,Genpact > Gurgaon > India > Mob:-+91-8588802543 > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. ImportAccess1-changed.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Hi Sandeep, what is the error message that appears? Basole. Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: > > Hi > > Kindly note that sql.request is functional in MS Excel 2007 but not in MS > Excel 2010. Could you please let me know any VBA code that would be a > substitute for sql.request. > If yes, Please let me know with the help of an example. > We use sql.request to transfer data from MS Access to MS Excel in version > 2007 > > > Thanks & regards, > *Sandeep Kumar Baranwal* > Business Analyst > Credit Risk Methodology & Wholesale Basel,Genpact > Gurgaon > India > Mob:-+91-8588802543 > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Hi Basole Thanks for the file. Just wanted to continue with the discussion. Actually , I am trying on an another version of this VBA using worksheet_calculate, just to, do away with the shape "Import" and use dropdown list in MS Excel (based on Primary key of MS Access) and import data from MS Access. The problem now faced , is related to cx.connectar. Could you resolve this ? Thanks & regards, *Sandeep Kumar Baranwal* Assistant Manager Credit Risk Methodology & Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 On Fri, Jul 19, 2013 at 8:17 PM, Basole wrote: > Hi Sandeep, > > See this example attached > > Rs. > > Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar > Baranwal escreveu: > >> Hi >> >> Kindly note that sql.request is functional in MS Excel 2007 but not in MS >> Excel 2010. Could you please let me know any VBA code that would be a >> substitute for sql.request. >> If yes, Please let me know with the help of an example. >> We use sql.request to transfer data from MS Access to MS Excel in version >> 2007 >> >> >> Thanks & regards, >> *Sandeep Kumar Baranwal* >> Business Analyst >> Credit Risk Methodology & Wholesale Basel,Genpact >> Gurgaon >> India >> Mob:-+91-8588802543 >> >> -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Hi Sandeep, has to do with what you need. I need to know:: The database access is within the SQL server? tks. and rgs. On Wednesday, July 17, 2013 11:48:43 AM UTC-3, Sandeep Kumar Baranwal wrote: > > Hi > > Kindly note that sql.request is functional in MS Excel 2007 but not in MS > Excel 2010. Could you please let me know any VBA code that would be a > substitute for sql.request. > If yes, Please let me know with the help of an example. > We use sql.request to transfer data from MS Access to MS Excel in version > 2007 > > > Thanks & regards, > *Sandeep Kumar Baranwal* > Business Analyst > Credit Risk Methodology & Wholesale Basel,Genpact > Gurgaon > India > Mob:-+91-8588802543 > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Hi Basole Suppose MS Access has a table containing two columns X & Y where X(1,1,1,2,2,3,3,3) and correspondingly Y(23,34,45,67,34,56,67,87) and dropdown in MS Excel is created as per based on X values (1,2,3). I wanted to know if there is a VBA code on the basis of which if I select say, 1 from the dropdown box in MS Excel, I have data (23,34,45) imported from MS access to MS Excel. Similarly if I choose 2 from dropdown box , I have (67,34) imported from MS Access to MS Excel. Thanks & regards, *Sandeep Kumar Baranwal* Business Analyst Credit Risk Methodology & Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 On Thu, Jul 18, 2013 at 10:12 PM, Basole wrote: > Please can attach example > > tks. > > > > Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar > Baranwal escreveu: >> >> Hi >> >> Kindly note that sql.request is functional in MS Excel 2007 but not in MS >> Excel 2010. Could you please let me know any VBA code that would be a >> substitute for sql.request. >> If yes, Please let me know with the help of an example. >> We use sql.request to transfer data from MS Access to MS Excel in version >> 2007 >> >> >> Thanks & regards, >> *Sandeep Kumar Baranwal* >> Business Analyst >> Credit Risk Methodology & Wholesale Basel,Genpact >> Gurgaon >> India >> Mob:-+91-8588802543 >> >> -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Please can attach example tks. Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: > > Hi > > Kindly note that sql.request is functional in MS Excel 2007 but not in MS > Excel 2010. Could you please let me know any VBA code that would be a > substitute for sql.request. > If yes, Please let me know with the help of an example. > We use sql.request to transfer data from MS Access to MS Excel in version > 2007 > > > Thanks & regards, > *Sandeep Kumar Baranwal* > Business Analyst > Credit Risk Methodology & Wholesale Basel,Genpact > Gurgaon > India > Mob:-+91-8588802543 > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Hi Basole Thanks for sharing the VBA code for importing data from MS Access to MS Excel . I need an another favor from you. Kindly re-modify the VBA code so that only selected data is imported from MS Access to MS Excel , based on the variable value selected from the dropdown created in the excel sheet. Thanks & regards, *Sandeep Kumar Baranwal* Business Analyst Credit Risk Methodology & Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 On Thu, Jul 18, 2013 at 9:08 AM, Sandeep Kumar Baranwal < sandeepkumarbaran...@gmail.com> wrote: > Hi > > I am not able to access the ImportAccess.zip folder that you have send > across. Please look into the issue. > > Thanks & regards, > *Sandeep Kumar Baranwal* > Business Analyst > Credit Risk Methodology & Wholesale Basel,Genpact > Gurgaon > India > Mob:-+91-8588802543 > > > > On Wed, Jul 17, 2013 at 8:59 PM, Basole wrote: > >> Pls, see the attached if that is what you need >> >> Bs. >> >> >> Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar >> Baranwal escreveu: >>> >>> Hi >>> >>> Kindly note that sql.request is functional in MS Excel 2007 but not in >>> MS Excel 2010. Could you please let me know any VBA code that would be a >>> substitute for sql.request. >>> If yes, Please let me know with the help of an example. >>> We use sql.request to transfer data from MS Access to MS Excel in >>> version 2007 >>> >>> >>> Thanks & regards, >>> *Sandeep Kumar Baranwal* >>> Business Analyst >>> Credit Risk Methodology & Wholesale Basel,Genpact >>> Gurgaon >>> India >>> Mob:-+91-8588802543 >>> >>> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Hi I am not able to access the ImportAccess.zip folder that you have send across. Please look into the issue. Thanks & regards, *Sandeep Kumar Baranwal* Business Analyst Credit Risk Methodology & Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 On Wed, Jul 17, 2013 at 8:59 PM, Basole wrote: > Pls, see the attached if that is what you need > > Bs. > > > Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar > Baranwal escreveu: >> >> Hi >> >> Kindly note that sql.request is functional in MS Excel 2007 but not in MS >> Excel 2010. Could you please let me know any VBA code that would be a >> substitute for sql.request. >> If yes, Please let me know with the help of an example. >> We use sql.request to transfer data from MS Access to MS Excel in version >> 2007 >> >> >> Thanks & regards, >> *Sandeep Kumar Baranwal* >> Business Analyst >> Credit Risk Methodology & Wholesale Basel,Genpact >> Gurgaon >> India >> Mob:-+91-8588802543 >> >> -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.