$$Excel-Macros$$ back up - vba code

Hi, I want to take backup of excel files periodically from some "specified path" and to "specified path", is there vba code for same. Thank you with regards Raghu -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Pl

Re: $$Excel-Macros$$ How to export data from Excel to Tally

hi, pls explain the procedure with regards Raghu On Fri, May 18, 2012 at 6:52 PM, sridher sharma wrote: > how? > > > On 18 May 2012 18:32, Jai wrote: > >> if you use Tally 9 Then you have import the excel file in tally >> >> >> On Fri,

$$Excel-Macros$$ How to export data from Excel to Tally

Sir, I have lot of data in excel how to export it to Tally ERP 9, please give suggestions sir. Thanks Raghu -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem

$$Excel-Macros$$ inventory in excel

hi, how to maintain inventory in excel. if any one have samples pls let me know Thank you with regards Raghu -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Prob

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

hi, Congrats sir, you are being very helpful to each and every one in this group i would also than Mr. Don and xlstime they are also equally helpful. keep it up sir. with regards raghu On Thu, Mar 15, 2012 at 11:53 AM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > congratulation

$$Excel-Macros$$ how to save file in 2 different locations

hi, I want save same excel file in two locations (different folders) if ctrl+s is pressed, so that there will be no need to take data backup. how to do it sir with regards raghu -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread title

Re: $$Excel-Macros$$ inventory sheet

te: > >> please fine the below link for excel inventory >> >> http://www.excelmagic.com/inventorymagic.html >> >> >> On Sat, Feb 25, 2012 at 7:31 PM, raghu gr wrote: >> >>> >>> >>> Hi, >>> >>> H

Re: $$Excel-Macros$$ how to find a text in a folder

an you share the some data > > > On Sat, Feb 25, 2012 at 9:44 PM, Sam Mathai Chacko wrote: > >> Well, then it shouldn't work, should it. You are looking for a number, >> but the number is a text. so change all your number texts to actual >> numbers. >

Re: $$Excel-Macros$$ how to find a text in a folder

hi, i am using excel 2003 and number is stored in text only sir thank you On Sat, Feb 25, 2012 at 9:04 PM, xlstime wrote: > which version you are using ? > > > On Sat, Feb 25, 2012 at 7:00 PM, raghu gr wrote: > >> Hi xlstime, >> its working for text only, but fo

$$Excel-Macros$$ inventory sheet

Hi, How to maintain inventory in excel sheet, is there any excel sheet / template / macro. with regards raghu -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Probl

Re: $$Excel-Macros$$ how to find a text in a folder

Hi xlstime, its working for text only, but for numbers it is not working pls help. with regards raghu On Wed, Feb 22, 2012 at 9:02 PM, xlstime wrote: > please use same software for any data type.. > > > On Wed, Feb 22, 2012 at 12:21 AM, raghu gr wrote: > >> hi, >>

Re: $$Excel-Macros$$ how to find a text in a folder

hi, This is working fine for searching text, how to search for numbers sir, means example if i want search a invoce number 2000127845 in a folder in which there are 50 files. Thank you with regards raghu On Mon, Feb 20, 2012 at 11:47 PM, raghu gr wrote: > > hi, > > Thanks this

Re: $$Excel-Macros$$ how to find a text in a folder

hi, Thanks this is very good. thank you with regards raghu On Mon, Feb 20, 2012 at 3:11 PM, xlstime wrote: > Hi Raghu, > > > you can use "*Agent Ransack *" searching software > > http://mythicsoft.com/page.aspx?type=agentransack&page=home > > On Sun, Fe

Re: $$Excel-Macros$$ how to find a text in a folder

Sir, Sir some error in line, Set a = wk.Cells.Find(What:="*" & ThisWorkbook.Sheets("File Names").Range("c2").Value & "*", After:=wk.Cells(1, 1), _ LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, _ SearchDirection:=xlNext, MatchCase:=False) pls help me. Thank you Raghu -- FORUM RUL

Re: $$Excel-Macros$$ how to find a text in a folder

).Row + 1 > ThisWorkbook.Sheets("File Names").Cells(r, 1).Value = fil.Path > ThisWorkbook.Sheets("File Names").Cells(r, 2).Value = Right(fil.Name, > Len(fil.Name) - InStrRev(fil.Name, ".") + 1) > ThisWorkbook.Sheets("File Names").Cells(r, 3).Value = Left(

$$Excel-Macros$$ how to find a text in a folder

hi all, how to find a text in folder. Example - suppose in 1 folder there are 40 excel files, if i want find a text "apple" is in which file (as it becomes tedious to open each and every file and use ctrl +F option). with regards raghu -- FORUM RULES (986+ members already BANNED for violation

Re: $$Excel-Macros$$ alert for duplicate name or number while entering the data in the sheet

hi, its limiting the entry also. with regards raghu On Sat, Feb 11, 2012 at 5:50 PM, Bé Trần Văn wrote: > ** > > 2012/2/10 rajeyssh aggarwaal > >> Hello Sir, >> Is it possible while we entering the date in the sheet system alert us >> that the name or number or text already in the sheet but not

Re: $$Excel-Macros$$ formula in rate column

Thank you sir, its working with regards raghu On Mon, Feb 6, 2012 at 8:20 PM, The Viper wrote: > check the attachment and go to rate sheet > > > On Sun, Feb 5, 2012 at 2:13 PM, raghu gr wrote: > >> hi, >> >> Thanks a lot sir, >> >> For the same

$$Excel-Macros$$ formula in rate column

Hi experts, I have a invoice file and summary file, i want the formula in rate column, which has to pick from rate sheet. please help me in this regard Attached sample file Thank you with regards Raghu -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread

Re: $$Excel-Macros$$ excell to pdf

hi, its not working to me also, error in line fixed width is comming with regards raghu On Tue, Jan 31, 2012 at 7:13 PM, KAUSHIK SAVLA wrote: > Hi Chandra, > > It is not working in my system > Cold you please what you did to get it worked properly? > > Regards, > Kaushik > > -- > FORUM RULES (98

Re: $$Excel-Macros$$ Import data

quirement. > Press Alt+F11 to See Code. > > On Thu, Jan 26, 2012 at 7:25 PM, raghu gr wrote: > >> hi, >> >> how will u run macro, please elobarate >> >> with regards >> Raghu >> >> On Wed, Jan 25, 2012 at 10:53 AM, LearnExcel wrote: >> >

Re: $$Excel-Macros$$ Import data

hi, how will u run macro, please elobarate with regards Raghu On Wed, Jan 25, 2012 at 10:53 AM, LearnExcel wrote: > Hi team, i wanted to import data set from two files and consolidate > the data into a master file. > > I need something in VBA, currently i run a marco that goes through > each s

Re: $$Excel-Macros$$ Converting pdf to excel?

hi, thanks but its showing error in line Dim appAA As Acrobat.CAcroApp "user defined type not defined" alert is comming whn this program is run with regards raghu On Sun, Jan 22, 2012 at 9:52 PM, NOORAIN ANSARI wrote: > Dear Kaushik, > > Please use below code, hope it will help to you.. > > > Su