$$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 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
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 sridher.sha...@gmail.comwrote: how? On 18 May 2012 18:32, Jai jaihumtu...@gmail.com wrote: if you use Tally 9 Then you have import the excel file in tally On Fri, May 18, 2012 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 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$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 Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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 On Thu, Mar 15, 2012 at 11:39 AM, jmothilal gjmothi...@gmail.com wrote: Congratulation Noorain. Mothilal.J Universal Computer\ Vellore -2 On Thu, Mar 15, 2012 at 11:36 AM, Dilip Pandey dilipan...@gmail.comwrote: Congratulations Noorain Keep up the good work and keep helping :) Regards, DILIPandey On Thu, Mar 15, 2012 at 11:31 AM, Abhishek Jain abhishek@gmail.comwrote: 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 talk2mar...@gmail.com wrote: 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 jainayus...@gmail.comwrote: 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 but has acheived this recognition for third time. *About Noorain Ansari :* [image: noorain.jpg] Noorain is a great poet and keep sharing his thoughts on different topics throgh cool poems. Professionally, he is a Excel aficionado and presently working as senior business analyst in One97 Communication Ltd. He is a MS excel - vba expert and keep sharing his thoughts with this forum. You can follow his blogs for Excel knowledge and cool poems : www.excel-macro.blogspot.com www.noorain-ansari.blogspot.com *Noorain, Many thanks for all your great support to group. Keep it up* *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it up !! ** *Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- - -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will
$$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 titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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, 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.comwrote: 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 balaji.bra...@gmail.comwrote: 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+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may
$$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 Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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, 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, 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.comwrote: 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 balaji.bra...@gmail.comwrote: 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+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros
Re: $$Excel-Macros$$ how to find a text in a folder
hi, In folder xyz in abc.xls i typed 123456, then in agent ransack in containing search i typed 123456, but it is not seaching the file abc.xls thanks a lot sir with regards raghu On Sat, Feb 25, 2012 at 11:29 PM, xlstime xlst...@gmail.com wrote: Hi raghu, can you share the some data 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...@gmail.comwrote: 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.comwrote: 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, 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.comwrote: hi, Thanks this is very good. thank you with regards raghu On Mon, Feb 20, 2012 at 3:11 PM, xlstime xlst...@gmail.comwrote: 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 balaji.bra...@gmail.com wrote: 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+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- 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, and Need Advice will not get
Re: $$Excel-Macros$$ inventory sheet
sir, Thank you, its good one. with regards raghu On Sun, Feb 26, 2012 at 12:56 AM, Maries talk2mar...@gmail.com wrote: Hi, Check this link, http://www.webandmacros.com/macro_excel_gestion_stocks.htm Regards, MARIES. On Sat, Feb 25, 2012 at 7:27 PM, xlstime xlst...@gmail.com wrote: 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 -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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 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 balaji.bra...@gmail.comwrote: 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+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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 balaji.bra...@gmail.comwrote: 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+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$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) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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 text already in the sheet but not limit the entry of the data, if yes let me know how can we do it and is it possible to imply the rule in few rows not in all the rows. thanks regards rajesh -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com *Validation of data entry to avoid duplicate values (Excel 2003).* From the menu, choose Data, select Validation, Making Data Validation box appears select the Settings tab, in the Allow: select Custom, enter the formula in the Formula frame (for column B) as follows: = MATCH (B2, $ B: $ B, 0) = ROW (B2) Next Error Alert tab, in the frame enter the text Error message you have duplicate data entry, then press the OK button -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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 to write formula in the attached file, but i could not, so pls request to give formula for attached file also. with regards Raghu On Sat, Feb 4, 2012 at 10:50 AM, The Viper viper@gmail.com wrote: hi check the attachment On Sat, Feb 4, 2012 at 12:02 AM, raghu gr balaji.bra...@gmail.comwrote: 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 titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Great day,* *viper* -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Great day,* *viper* -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum
$$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 titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com SAMPLEINVOICE.xls Description: MS-Excel spreadsheet
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 -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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 through each sheet and copies them into the marco but for some reason it takes some time im sure theres a better way.. let me know if you need more info -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Import data
hi noorain, I mean how Mr.Selva wrote or record the macro to import data set from two files and consolidate the data into a master file. thank you raghu On Thu, Jan 26, 2012 at 7:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Raghu, Please use attached sheet vba code as per 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 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 sheet and copies them into the marco but for some reason it takes some time im sure theres a better way.. let me know if you need more info -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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 help to you.. Sub ImportPDFFileData() 'Author: Steve Lipsman 'Purpose: Import PDF File Data Into Excel Worksheet 'Other Requirement(s): 'Acrobat' Checked in VBA Tools-References 'Reference Renames Itself 'Adobe Acrobat 9.0 Object Library' After Reference Is Saved 'Declare Variable(s) Dim appAA As Acrobat.CAcroApp, docPDF As Acrobat.CAcroPDDoc Dim strFileName As String, intNOP As Integer, arrI As Variant Dim intC As Integer, intR As Integer, intBeg As Integer, intEnd As Integer 'Initialize Variables Set appAA = CreateObject(AcroExch.App): Set docPDF = CreateObject(AcroExch.PDDoc) 'Set PDF FileName strFileName = Your Full PDF File Pathname Here.pdf 'Read PDF File docPDF.Open (strFileName) 'Extract Number of Pages From PDF File intNOP = docPDF.GetNumPages 'Select First Data Cell Range(A1).Select 'Open PDF File ActiveWorkbook.FollowHyperlink strFileName, , True 'Loop Through All PDF File Pages For intC = 1 To intNOP 'Go To Page Number SendKeys (+^n intC {ENTER}) 'Select All Data In The PDF File's Active Page SendKeys (^a), True 'Right-Click Mouse SendKeys (+{F10}), True 'Copy Data As Table SendKeys (c), True 'Minimize Adobe Window SendKeys (%n), True 'Paste Data In This Workbook's Worksheet ActiveSheet.Paste 'Select Next Paste Cell Range(A Range(A1).SpecialCells(xlLastCell).Row + 2).Select 'Maximize Adobe Window SendKeys (%x) Next intC 'Close Adobe File and Window SendKeys (^w), True 'Empty Object Variables Set appAA = Nothing: Set docPDF = Nothing 'Select First Cell Range(A1).Select End Sub On Sun, Jan 22, 2012 at 8:32 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: That code not working too. Pls suggest. Regards, Kaushik Savla -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com