Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-07 Thread Sandeep Kumar Baranwal
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 o

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-07 Thread Rupesh Patil
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

$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-07 Thread Basole
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 >

Re: $$Excel-Macros$$ Need PDF to Excel Converter.....

2013-11-07 Thread Indrajit $nai
Ravinder, you are the best, you always help me out from the critical situations. Hats off to you!!! and it's really amazing. If I need any further clarification / modification, definitely I'll get back to you, hope you wouldn't mind. :) Thanks & Regards, Indrajit On Thu, Nov 7, 2013 at 4:0

Re: $$Excel-Macros$$ Re: Complicated Formula (automatic add back)

2013-11-07 Thread itware2008
Hello Amar, Perhaps this is what you want. Otherwise, please explain your goal with more detail. Best regards, Terça-feira, 8 de Outubro de 2013 13:18:32 UTC+1, amar takale escreveu: > > Dear Ravinderji, > > Thanks very much for great guidance for UDF VBA coding,I change little bit > in excel

$$Excel-Macros$$ Re: total Fridays in a range

2013-11-07 Thread itware2008
Please take a look at the enclosed file. You are able to select from the drop-down box the weekday you are looking for, below you find the number of occurrences for the weekday you had chosen. Cheers. Terça-feira, 1 de Outubro de 2013 15:18:15 UTC+1, asd...@gmail.com escreveu: > > vba returns

Re: $$Excel-Macros$$ loop to copy items one by one

2013-11-07 Thread Hilary Lomotey
thanks for looking into this for me very grateful On Thu, Nov 7, 2013 at 6:15 AM, Ravinder wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (ravinderexcelgr...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ How to retrieve multiple or single data from a single column like (A1) to different required columns like (D1, D2, D3 .....)

2013-11-07 Thread MRafique Ujjan
Dear Sir, now I have attached a worksheet which shows all the allowances with their special code too. Please fix my problem & sorry for inconvenience. On Thursday, November 7, 2013 3:13:35 PM UTC+5, ravinder negi wrote: > > Actually there are lots of allowance and every employ getting different

RE: $$Excel-Macros$$ How to retrieve multiple or single data from a single column like (A1) to different required columns like (D1, D2, D3 .....)

2013-11-07 Thread Ravinder
Actually there are lots of allowance and every employ getting different allowances, pls provide the maximum heading of allowances then I can fix it... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of MRafique Ujjan Sent: Thursday, November 07, 2013 3:29 PM