Re: $$Excel-Macros$$ Help:Open all excel files in folder

Dear Venkat, Please use First goto VB Editor and Select Tools-Reference-Microsfot Scripting Runtime then run Macro Change red color Folder Path... Sub OpenFile_Of_Folder() Dim MyFile As File Dim MyFolder As Folder Dim fso As Scripting.FileSystemObject Set fso = New Scripting.FileSystemObjec

$$Excel-Macros$$

Hi Excel group, I want to know that in MS-Access have automatic backup option acutaly i am working in access file daily wise so i want to take backup daily wise automatically anybody help Thanks in Advance Noorain Sir,Please solve my problem -- *Thanks & Regards * *Aivran kumar *E-mail:- aivra

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Congratulation Noorain. Mothilal.J Universal Computer\ Vellore -2 On Thu, Mar 15, 2012 at 11:36 AM, Dilip Pandey wrote: > Congratulations Noorain > > Keep up the good work and keep helping :) > > Regards, > DILIPandey > > > On Thu, Mar 15, 2012 at 11:31 AM, Abhishek Jain wrote: > >> Ma

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Congratulations Noorain Keep up the good work and keep helping :) Regards, DILIPandey On Thu, Mar 15, 2012 at 11:31 AM, Abhishek Jain wrote: > Many congratulations Noorain bro! > > Keep up the good work and keep helping us mere mortals in excelling our > lives. :) > > God bless > > > On

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Many congratulations Noorain bro! Keep up the good work and keep helping us mere mortals in excelling our lives. :) God bless On Thu, Mar 15, 2012 at 11:23 AM, Maries wrote: > Congrats Brother.. > > > On Thu, Mar 15, 2012 at 9:50 AM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com>

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Congrats Brother.. On Thu, Mar 15, 2012 at 9:50 AM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Congratulation for you achievement. Hoping for a good luck. > > sanjib > > On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain wrote: > >> Hello Everyone, >> >> Noorain Ansari has been sel

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Congratulation for you achievement. Hoping for a good luck. sanjib On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Feb'12 > He has posted 156 posts in Feb'12 and helped many people through his

Re: $$Excel-Macros$$ Macro for format table

Hi Thank u for ur reply, still I need some more changes in the code, pls check the attached xl file, it will show step by step what to do.pls make the necessary change in the code for getting the result. Sub CopyColumnsToTableSAS() Dim i As Integer Dim fr As Long Dim lr As Long 'col A Cells(2, 1).R

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

congratulation noorain ansari may allah good reward for this. On Thu, Mar 15, 2012 at 9:40 AM, Subhash Yadav wrote: > Congrats Noorain Keep it up > > On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain wrote: > >> Hello Everyone, >> >> Noorain Ansari has been selected as 'Most Helpful Member' for

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Congrats Noorain Keep it up On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Feb'12 > He has posted 156 posts in Feb'12 and helped many people through his > expertise. He has been consistent

RE: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Congratulations Noorain! Great contribution! Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: Wednesday, March 14, 2012 3:50 PM To: excel-macros Subject: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari Hello Everyone

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Congratulation Noorain.. On Thu, Mar 15, 2012 at 9:38 AM, Seraj Alam wrote: > Congrats noorain bhai. > [?][?][?][?][?] > > > > On Wed, Mar 14, 2012 at 3:49 PM, Ayush Jain wrote: > >> Hello Everyone, >> >> Noorain Ansari has been selected as 'Most Helpful Member' for the month >> of Feb'12

Re: $$Excel-Macros$$ How to sort horizontaly a line of cells (values) in ascending order ?

Hi , if you are using 2007 or 2010 you can use default sort option with multiple criterias. -- Sent from my Nokia phone --Original message-- From: Jean PIERRE To: "MS EXCEL AND VBA MACROS" Date: Wednesday, March 14, 2012 2:53:17 PM GMT-0700 Subject: $$Excel-Macros$$ How to sor

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Congrats noorain bhai. [?][?][?][?][?] On Wed, Mar 14, 2012 at 3:49 PM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Feb'12 > He has posted 156 posts in Feb'12 and helped many people through his > expertise. He has be

$$Excel-Macros$$ Help:Open all excel files in folder

Dear All, i want to get opened all excel files in certain folder by using vba coding. Regards venkat Chennai -- Sent from my Nokia phone -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Congrats Noorain Sir,, On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Feb'12 > He has posted 156 posts in Feb'12 and helped many people through his > expertise. He has been co

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Congrats Noorain:) On 3/15/12, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Feb'12 > He has posted 156 posts in Feb'12 and helped many people through his > expertise. He has been consistent contributor to this excel forum bu

$$Excel-Macros$$ Re: Most Helpful Member Feb'12 - Noorain Ansari

Considering his work for the past few months.. could we recommend him for next MVP On Mar 15, 3:49 am, Ayush Jain wrote: >  Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Feb'12 > He has posted 156 posts in Feb'12 and helped many people throu

Re: $$Excel-Macros$$ Email Sheet with message

thanks buddy i'll give this a try On Wednesday, 14 March 2012 01:20:52 UTC-5, NOORAIN ANSARI wrote: > Please add Outlook library before run the code > > Tools-Reference-Microsoft Outlook 12.0 Object Library. > > -- > Thanks & regards, > Noorain Ansari > **

$$Excel-Macros$$ Re: Most Helpful Member Feb'12 - Noorain Ansari

Thanks guys I want to thank everone on this site for making us feel welcome and open to answer any questions keep up the great work On Wednesday, 14 March 2012 17:49:30 UTC-5, Ayush wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Fe

$$Excel-Macros$$ How to sort horizontaly a line of cells (values) in ascending order ?

EUROPE - Belgium Hi, I would like to do a sorting of cells (values) horizontaly in ascending order ! There are many lines to sort ! Which is the VBA code ? Thank you for your help ! Regards, -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

$$Excel-Macros$$ Re: Logical Formula Problem

Hello, new around here .. here is something that might help you... luni, 12 martie 2012, 17:22:04 UTC+2, hilary lomotey a scris: > > Hi Experts > > i am trying to use the logical formula ie < or > operator to have an > outcome such that if the figure in say cell A is greater than that of cel

Re: $$Excel-Macros$$ Email Sheet with message

Hi Mr. Ansari how are you? My dear i need your help can u guide me; how can i improve my skills in excel and VBA regards, On Wed, Mar 14, 2012 at 11:20 AM, NOORAIN ANSARI wrote: > Please add Outlook library before run the code > > Tools-Reference-Microsoft Outlook 12.0 Object Library. > > > -

RE: $$Excel-Macros$$ SQL - Query

Hi Sharma, How do you define failure for the first query? 0 records returned? an error from the database server/engine? What do you want to do with the result of the query? Put it on a (new?) sheet in your workbook? *writing* the queries using VBA is very simple. The following assembles t

$$Excel-Macros$$ Sum hours weeks

HELP !! please I need help with macro function that sum hours week . attached excel file For this example we use in January, but I need it for all months thx all group -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- FORUM RULES (98

Re: $$Excel-Macros$$ Help Needed

Try this Sub CreateWordDocs() Dim xsht As Worksheet Dim rng As Range Dim lngLoop As Integer Set xsht = ActiveWorkbook.Worksheets("Sheet1") lngLoop = xsht.Cells(Rows.Count, 3).End(xlUp).Row If lngLoop > 1 Then With CreateObject("Word.Application") .Vis

Re: $$Excel-Macros$$ Divide Results from 2 Pivot Tables

There ain't no attachment! Sam On Wed, Mar 14, 2012 at 8:51 AM, Jim wrote: > I'm trying to divide a value in one Pivot Table by a value in a second > Table. Please see the screen shot and the following explanation in > the attached Word document. > > Any ideas? I'm thinking that I may be missi

$$Excel-Macros$$ Re: SQL - Query

Hi there, I'm not sure the kind of vba code you're looking for. If it's about using vlookup, match and so on to retrieve data, so far, i'm not able to do much just following you sql code. If you want me to help, copy paste the tables you want to query on and I see Comments in the code below may

Re: $$Excel-Macros$$ Help Needed

Dear Sir I can able to create Notepad files , but i getting following error when trying to create word files Run Time Error User Defined is not found On Tue, Mar 13, 2012 at 4:39 PM, BNS kumar wrote: > Hi, > > check this out > > Sub CreateWordDocs() > ' add a reference to the Word-library >

Re: $$Excel-Macros$$ Macro for format table

lr = Cells(Rows.Count, i).End(xlUp).Row 'two lines below added. MsgBox fr - 2 Cells(1, i + 6) = fr - 2 '=== Cells(fr, i).Resize(lr).Copy Cells(2, i + 6) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Rajesh K R Sent: Wednesday, Mar

Re: $$Excel-Macros$$ Format data from Tally 7.2

Hi, Try below formula, =IFERROR(INDEX(Table1[DSPVCHDATE],SMALL(IF(Table1[DSPVCHDATE]<>"",ROW(Table1[DSPVCHDATE])-1,""),ROW()-1)),"") *Apply With Ctrl + Shift + Enter.* Regards, MARIES. On Tue, Mar 13, 2012 at 10:45 PM, dguillett1 wrote: > I thought I already responded to this. > > Sub Cop

Re: $$Excel-Macros$$ Macro for format table

Hi Thank u very much.I need some change in the code. here I want to count the number of cells deleted in column B here 25 cells In column C delete 50 cells In column D delete 75 cells In column E delete 100 cells. Please refer the attached file Regards Rajesh Kainikkara On 3/13/12, dguillett