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

2013-02-03 Thread rekha siri
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.

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

2013-02-03 Thread respuzy
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

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

2013-02-03 Thread joseph . camill
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 da...@grugeon.com.au Sender:

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

2013-02-03 Thread David Grugeon
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

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

2013-02-03 Thread respuzy
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 da...@grugeon.com.au Sender: excel-macros@googlegroups.com Date: Sun, 3 Feb 2013 22:24:27 To:

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

2013-02-03 Thread ashish koul
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 rekha.siri2...@gmail.com wrote: hi All, Please assist the below query . Problem i have imported excel data having more than

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

2013-02-03 Thread Prince
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 technically

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

2013-02-03 Thread Prince
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 through

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

2013-02-03 Thread Amit Desai (MERU)
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:

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

2013-02-03 Thread respuzy
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 prince141...@gmail.com Sender:

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

2013-02-03 Thread amar takale
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 noorain.ans...@gmail.comwrote: Congrats Prince babu On Sun, Feb 3, 2013 at 6:03 AM, Bé Trần Văn

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

2013-02-03 Thread amar takale
Dear price, Any solution, Pls? A lots of Appreciate the help. Regards Amar On Thu, Jan 31, 2013 at 5:55 PM, amar takale amartak...@gmail.com 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