$$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

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

at 6:13 PM, raghu gr balaji.bra...@gmail.comwrote: 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

$$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

$$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

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: congratulations

$$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

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 xlst...@gmail.com wrote: please use same software for any data type.. On Wed, Feb 22, 2012 at 12:21 AM, raghu gr balaji.bra...@gmail.comwrote: hi

$$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

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 xlst...@gmail.com wrote: which version you are using ? On Sat, Feb 25, 2012 at 7:00 PM, raghu gr balaji.bra...@gmail.com wrote: Hi xlstime, its working for text only

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

On Sat, Feb 25, 2012 at 9:44 PM, Sam Mathai Chacko samde...@gmail.comwrote: 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. Sam On Sat, Feb 25, 2012 at 9:32 PM, raghu gr balaji.bra

Re: $$Excel-Macros$$ inventory sheet

: 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 balaji.bra...@gmail.comwrote: Hi, How to maintain inventory in excel sheet, is there any excel sheet / template / macro. with regards raghu

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 balaji.bra...@gmail.com wrote: hi, Thanks

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 xlst...@gmail.com wrote: Hi Raghu, you can use *Agent Ransack * searching software http://mythicsoft.com/page.aspx?type=agentransackpage=home On Sun, Feb 19, 2012 at 11:41 PM, raghu gr

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 RULES (986+

$$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 betnmtdongna...@gmail.comwrote: ** 2012/2/10 rajeyssh aggarwaal rajey...@gmail.com Hello Sir, Is it possible while we entering the date in the sheet system alert us that the name or number or

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 viper@gmail.com wrote: check the attachment and go to rate sheet On Sun, Feb 5, 2012 at 2:13 PM, raghu gr balaji.bra...@gmail.com wrote: hi, Thanks a lot sir, For the same type of file i tried

$$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

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 savla.kaus...@gmail.comwrote: Hi Chandra, It is not working in my system Cold you please what you did to get it worked properly? Regards, Kaushik --

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 sendse...@gmail.com 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

Re: $$Excel-Macros$$ Import data

your requirement. Press Alt+F11 to See Code. On Thu, Jan 26, 2012 at 7:25 PM, raghu gr balaji.bra...@gmail.comwrote: hi, how will u run macro, please elobarate with regards Raghu On Wed, Jan 25, 2012 at 10:53 AM, LearnExcel sendse...@gmail.comwrote: Hi team, i wanted to import data set

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 noorain.ans...@gmail.comwrote: Dear Kaushik, Please use below code, hope it will