Re: $$Excel-Macros$$ Data extract from website & update Automatically

Dear price, Any solution, Pls? A lots of Appreciate the help. Regards Amar On Thu, Jan 31, 2013 at 5:55 PM, amar takale wrote: > Hi All Experts, > Can anybody tell me any website (Example: Nseindia.com) page Data > extract in excel as it same view format (at least data extract that’s > suffi

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member Jan'13

Dear Champ Prince, Congratulations my friend, well done and keep it up Thanks for your contribution in our group. Regards Amar On Sun, Feb 3, 2013 at 6:22 AM, NOORAIN ANSARI wrote: > Congrats Prince babu > > > > On Sun, Feb 3, 2013 at 6:03 AM, Bé Trần Văn wrote: > >> Prince is grea

Re: $$Excel-Macros$$ Re: Unhide some sheets starting from a specificsheet number *

Thanks prince its working nicely except that for the purpoze of what I want to do I don't want an input box but want to hard code the number instead in the code. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Prince Sender: excel-macros@googlegroup

RE: $$Excel-Macros$$ Re: Unhide some sheets starting from a specific sheet number

Is it possible to have a macro that will first give list of all the sheet names & then gives 2 option hide or unhide? Best Regards, Amit Desai +91 98672 32534 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prince Sent: 03 February 2013 22:05 To: excel-ma

$$Excel-Macros$$ Re: Prince Kumar - Most Helpful Member Jan'13

Thanks to every one for their wishes. (: Regards Prince On Saturday, February 2, 2013 11:49:07 AM UTC+5:30, Ayush Jain wrote: > > > Dear members, > > Prince Kumar has been selected as 'Most Helpful Member' for the month of > Jan'13. He has posted 103 posts last month and helped forum members thr

$$Excel-Macros$$ Re: Unhide some sheets starting from a specific sheet number

Hi Hilary, Please See the attachment. Regards prince On Sunday, February 3, 2013 3:28:11 PM UTC+5:30, hilary lomotey wrote: > > Hello experts > > Assuimg I have 10 sheets in a workbook. And I want to unhide the 7th sheet > up to the last sheet Kindly help with vba code to do that. So technical

Re: $$Excel-Macros$$ Need your advise - MS Access 2007 drop down list Macro

why don't you use top command with SQL Read top statement here http://www.w3schools.com/sql/sql_top.asp Regards Ashish On Sun, Feb 3, 2013 at 3:30 PM, rekha siri wrote: > hi All, > > Please assist the below query . > > Problem > > i have imported excel data having more than 1lac rows into A

Re: $$Excel-Macros$$ Unhide some sheets starting from a specific sheet number

Hello Dave I get a compile error type mismatch on sh E Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: David Grugeon Sender: excel-macros@googlegroups.com Date: Sun, 3 Feb 2013 22:24:27 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroup

Re: $$Excel-Macros$$ Unhide some sheets starting from a specific sheet number

Untested air code Dim sh as worksheet For sh = 7 to sheets.count Sheets(Sh).visible= true Next sh On Sunday, 3 February 2013, wrote: > Hello experts > > Assuimg I have 10 sheets in a workbook. And I want to unhide the 7th sheet > up to the last sheet Kindly help with vba code to do that. So tec

Re: $$Excel-Macros$$ Database sort (copy from one sheet to another sheet in different order)

Hi David, Thanks for your reply. 1. The row names may change from period to period and region to region. 2. No it may change 3. Yes 4. Yes there will be arithmetic involved. Sent on my BlackBerry® from Vodafone -Original Message- From: David Grugeon Sender: excel-macros@googlegroups.c

$$Excel-Macros$$ Unhide some sheets starting from a specific sheet number

Hello experts Assuimg I have 10 sheets in a workbook. And I want to unhide the 7th sheet up to the last sheet Kindly help with vba code to do that. So technically every sheet from the first sheet Ȋ̝̊̅§ hidden. Any sheet that Ȋ̝̊̅§ after the 10th sheet shd bE unhidden. Thnks Sent from my BlackBe

$$Excel-Macros$$ Need exporting help for Records more than 65000 records in Access to Excel

hi Group, Need your expertise help i along with my friends uploaded some excel file into Access . Now the Access is having around 1lac records . Need help in exporting from access to excel all the 1lac records. i tried exporting it to excel from access but it is throughing only 65000 records.