Re: $$Excel-Macros$$ Re: how to crack Excel VBA password
Dear Team, Below software is can recover password only VBA project file of Doc, Xla and Xls files but my exel file is xlsx so its not working. so plz suggest me the password remover of xlsx file format. Regards, Nitin Kumar Pfa, Regards, Nitin Kumar On Wed, Mar 5, 2014 at 1:09 PM, nancy ahuja nancyahuj...@gmail.com wrote: There are a lot of manual ways n which you can reset VBA passwords but it seems like you don't have access to this option because in your case nobody remembers passwords. That's really awful but you don't have to panic as I have a recommendation for this free trial version which I hope can definitely serve your purpose or maybe you won't have to look for other ways. Check out this *SysInfoTools VBA Pasword Recovery http://www.sysinfotools.com/recovery/vba-password-recovery.html*. It is an effective software that will aid you in cracking VBA password and you would be able to open required Excel file. On Friday, February 19, 2010 7:54:12 PM UTC+5:30, sunil sasidharan wrote: *Hi All,* *I need to edit an excel macro file but the VBA coing is protected and nobody is aware of the password.* *Could you please help me on how do i crack the excel password or is there any free software available?* *Thanks in advance for your helpRegards,Sunny* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/B_bTLZ3HSp0/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: how to crack Excel VBA password
Dear Team, Below software is can recover password only VBA project file of Doc, Xla and Xls files but my exel file is xlsx so its not working. so plz suggest me the password remover of xlsx file format. Regards, Nitin Kumar Pfa, Regards, Nitin Kumar Pfa, Regards, Nitin Kumar On Fri, Feb 28, 2014 at 2:03 PM, nitin kumar nitin.k...@gmail.com wrote: Dear Elis, below software is not working not showing the password can u find the the password of attached file password. please... Regards, Nitin Kumar +91 9784363535 Pfa, Regards, Nitin Kumar On Fri, Feb 21, 2014 at 6:08 PM, elis smith elissmit...@gmail.com wrote: * You can use Excel file password creacker *software which easily crack Excel file password unlock Excel spreadsheethttp://www.excelunlocker.com/after then fastly re-open Microsoft Excel file.. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/B_bTLZ3HSp0/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: how i convert pdf file to Excel using macro.
HI, Email on tyagi@gmail.com.. for what macros u r looking for... i can help u. On Sunday, January 26, 2014 8:31:10 AM UTC+5:30, Frank Friedland wrote: Hi I need someone to write macros for me, please email me. Best Frank On Saturday, February 19, 2011 2:17:51 AM UTC-5, rashid memon wrote: Dear Experts, i want to convert PDF file to Excel so plz provide me macro file is attached... Looking forward to receive your kind attention. Thanks Best Regards Rashid Hussaini Email:- *mr.rash...@gmail.com* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
RE: $$Excel-Macros$$ Help me for interview : Excel Formulas and Macros
IN WHICH COMPANY... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KATHIRVELAN N Sent: Saturday, March 08, 2014 6:41 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help me for interview : Excel Formulas and Macros Dear Friends, I have scheduled for an Interview on coming Monday. Please help in what are basic things that could be prepared in Excel formulas and Macros. Particularly i'm very new to macro, so what are the basic syntax commonly used. Send me files with basic macro project. Please guide me. Thanks, Kathirvelan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ cell tooltip
try this Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count = 1 And Target.Column = 1 Then On Error Resume Next ActiveSheet.Shapes(displaytext).Delete On Error GoTo 0 Set shp = ActiveSheet.Shapes.AddShape(msoShapeRectangle, Target.Offset(0, 1).Left, Target.Top, 50, 10) With shp .Name = displaytext .TextFrame.Characters.Text = Target.Value .TextFrame2.AutoSize = msoAutoSizeShapeToFitText .TextFrame2.WordWrap = True End With End If End Sub On Sat, Mar 8, 2014 at 12:32 PM, Rupesh Patil patil.rupesh1...@gmail.comwrote: Dear Abhishek, I have database for medicines, that data base have columns call side effect and contraindications value of both columns are like five to six line paragraph. If I want to see this side effect and contraindications, I need to press F2, it will visible like paragraph, so each time or cell I have to do this. instead that, I want to show that value if, mouse over that particular cell. so could you please tell me, how can I get this done On Fri, Mar 7, 2014 at 4:20 PM, Abhishek Jain abhishek@gmail.comwrote: Just to help me understand: Why do you want to reflect the value in tooltip when it is already visible in the Cell itself? Do you mean Cell Address instead of Cell Value? Example - Cell Value is Rupesh Cell Address is E2 What do you want to appear in the tool tip? On Fri, Mar 7, 2014 at 3:29 PM, Rupesh Patil patil.rupesh1...@gmail.comwrote: Hi Expert, Is there no way to do that? On Fri, Mar 7, 2014 at 9:57 AM, Rupesh Patil patil.rupesh1...@gmail.com wrote: Hi Expert, I need your help. how to show cell value as tool tip when mouse over that cell. -- Thanks and Regards, Rp. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Thanks and Regards, Rp. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever
Re: $$Excel-Macros$$ How to link a cell between two worksheets keeping the Hyperlink?
you can use =HYPERLINK formula. Can you please share a sample file On Thu, Mar 6, 2014 at 5:20 PM, Caroline Campos caroline@gmail.comwrote: I have two worksheets and I linked the cells to change automatically, but when I insert a hyperlink in the cell of the original worksheet, it does not change the other worksheet that should be updated. Copying and pasting the cells, it works, but when i update the hiperlink, it doesn't So, I need too link the cells, and when updating, change the hiperlink too. Somebody help me? Thank you. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ import txt file to excel with vba
can u please write in english 2014-03-06 21:45 GMT+05:30 Lidija Malek lidij...@gmail.com: Imam veliko txt. datoteke, ki jih želite samodejno uvozijo preko VBA koda tekstovan datoteke je vedno enak aritetura potrebujejo le nekateri podatki v teh dveh vrstah, kar je rdeča samo želijo te podatke * Izbrano PCB: C: \ SmartSM \ \ PCB 2013/04/02 KL.SENSOR . odločijo * izbrani datum: 20130402_214823 izbrani datum: 20130402 * Run Time: 00:42:17 (2.537 sec) * Place Čas: 00:41:41 (2.501 sec) * Transfer čas: 0:00:26 (26 sec ) * Začetek pavza: 00:00:10 (10 sec) * Izhod pavza: 12:00:00 (0 sec) * Stop čas: 0:00:16 (16 sec) se kopira iz txt. datoteke v Excelu, tako da sem imel s klikom na gumb boste dobili vse informacije in preko tega gumba boste iskali mapo, v kateri so podatki, bi zraven imela 2 linije eno bi bilo ime računalnika v eno mapo in uporabnik lahko več To bi bilo tudi mapa, v kateri so bili podatki Ime računalnika na glavni mapi podmape, uporabniki, in je želel, da se mi brati podatke, od katerih jih je v imenu računalnik in uporabnika. npr. Računalnik ime uporabniškega g545 peter g545 joe to je original txt.file Trenutni Proizvodnja Informacije * Izbrano PCB: C: \ SmartSM \ PCB \ 2013/04/02 KL.SENSOR.opt * izbrani datum: 20130402_214823 * Skupni odbor: 6. [EA] * izpuščen PCB: 0 [EA] * Delal PCB: 504 [EA] * Run Time: 00:42:17 (2.537 sec) * Mesto čas: 0:41:41 (2.501 sec) * Čas prenosa: 00:00:26 (26 sec) * Začetek pavza: 00:00:10 (10 sec) * Izhod pavza: 00:00:00 (0 sec) * Stop čas: 0:00:16 (16 sec) * Peak Zgradite Time: 0.0 [sec / board] 0 [Board / uro] 0 [čip / uro] * Srednja zgraditi Time: 416,8 [sec / board] 8. [Board / uro] 10882 [čip / uro] * prejšnjem ciklu: 427,6 [ sec / board] * - Build čas: 423,4 [s] * - Tranfer čas: 4,2 [s] Head Informacije Pickup, Kraj Napaka, Napaka (PPM) Pick gospodična Del NG 1 1260 1260 0 0 0 0 0 # 2 1.260 1.260 0 0 0 0 0 # 3 1260 1260 0 0 0 0 0 # 4 1.260 1.260 0 0 0 0 0 # 5 1.260 1.260 0 0 0 0 0 # 6 1.260 1.260 0 0 0 0 0 # 7 0 0 0 0 0 0 0 # 8 0 0 0 0 0 0 0 # 9 0 0 0 0 0 0 0 # 10 0 0 0 0 0 0 0 # 11 0 0 0 0 0 0 0 # 12 0 0 0 0 0 0 7560 7560 0 0 0 0 Feeder Informacije Točka Pickup, Kraj Napaka, Napaka (PPM) Pick gospodična Del NG F20 504 504 0 0 0 0 0 ICS_74HCT4060_00 23 F23 504 504 0 0 0 0 0 SENZOR_HC105_00 29 F29 504 504 0 0 0 0 0 RS0805_180K_00 30 F30 1008 1008 0 0 0 0 0 CSK0805_22NF_00 31 F31 504 504 0 0 0 0 0 RS0805_110K_00 32 F32 504 504 0 0 0 0 0 RS0805_56R_00 33 F33 504 504 0 0 0 0 0 RS0603_10K_00 34 F34 504 504 0 0 0 0 0 RS0805_12K_00 35 F35 504 504 0 0 0 0 0 RS0805_10K_00 36 F36 504 504 0 0 0 0 0 ICS_LP2980_00 37 F37 504 504 0 0 0 0 0 CSK0805_1N5F_00 38 F38 504 504 0 0 0 0 0 CSK0805_150PF_00 39 F39 504 504 0 0 0 0 0 TS_BCR141_00 40 F40 504 504 0 0 0 0 0 ICS_KT230_00 S1-1 0 0 0 0 0 0 0 ICS_74HCT4060_00_STICK 0 0 0 0 0 0 7560 7560 0 0 0 0 Šoba Informacije Pickup, Kraj Napaka, Napaka (PPM) Pick gospodična Del NG 8 0 0 0 0 0 0 0 CN400N 1 - 9 0 0 0 0 0 0 0 CN110 1-10 0 0 0 0 0 0 0 CN400N 1-12 0 0 0 0 0 0 0 CN750 1-14 0 0 0 0 0 0 0 CN040 1-15 252 252 0 0 0 0 0 CN140 1-16 1008 1008 0 0 0 0 0 CN065 1-17 0 0 0 0 0 0 0 CN220 1-18 0 0 0 0 0 0 0 CN040 1-19 252 252 0 0 0 0 0 CN140 1-20 1008 1008 0 0 0 0 0 CN065 1-21 0 0 0 0 0 0 0 CN220 1-22 0 0 0 0 0 0 0 CN040 1-23 252 252 0 0 0 0 0 CN140 1-24 1008 1008 0 0 0 0 0 CN065 1-25 0 0 0 0 0 0 0 CN220 1-26 0 0 0 0 0 0 0 CN040 1-27 252 252 0 0 0 0 0 CN140 1-28 1008 1008 0 0 0 0 0 CN065 1-29 0 0 0 0 0 0 0 CN220 1-30 0 0 0 0 0 0 0 CN040 1-31 0 0 0 0 0 0 0 CN140 1-32 1260 1260 0 0 0 0 0 CN065 1-34 0 0 0 0 0 0 0 CN040 1-35 0 0 0 0 0 0 0 CN140 1-36 1260 1260 0 0 0 0 0 7560 7560 0 0 0 0 Nazadnje urejal lika86; danes ob 09:31 . -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at
Re: $$Excel-Macros$$ cell tooltip
Dear Ashish, Thanks Ashish, awesome micro. On Sat, Mar 8, 2014 at 6:30 PM, ashish koul koul.ash...@gmail.com wrote: try this Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count = 1 And Target.Column = 1 Then On Error Resume Next ActiveSheet.Shapes(displaytext).Delete On Error GoTo 0 Set shp = ActiveSheet.Shapes.AddShape(msoShapeRectangle, Target.Offset(0, 1).Left, Target.Top, 50, 10) With shp .Name = displaytext .TextFrame.Characters.Text = Target.Value .TextFrame2.AutoSize = msoAutoSizeShapeToFitText .TextFrame2.WordWrap = True End With End If End Sub On Sat, Mar 8, 2014 at 12:32 PM, Rupesh Patil patil.rupesh1...@gmail.comwrote: Dear Abhishek, I have database for medicines, that data base have columns call side effect and contraindications value of both columns are like five to six line paragraph. If I want to see this side effect and contraindications, I need to press F2, it will visible like paragraph, so each time or cell I have to do this. instead that, I want to show that value if, mouse over that particular cell. so could you please tell me, how can I get this done On Fri, Mar 7, 2014 at 4:20 PM, Abhishek Jain abhishek@gmail.comwrote: Just to help me understand: Why do you want to reflect the value in tooltip when it is already visible in the Cell itself? Do you mean Cell Address instead of Cell Value? Example - Cell Value is Rupesh Cell Address is E2 What do you want to appear in the tool tip? On Fri, Mar 7, 2014 at 3:29 PM, Rupesh Patil patil.rupesh1...@gmail.com wrote: Hi Expert, Is there no way to do that? On Fri, Mar 7, 2014 at 9:57 AM, Rupesh Patil patil.rupesh1...@gmail.com wrote: Hi Expert, I need your help. how to show cell value as tool tip when mouse over that cell. -- Thanks and Regards, Rp. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Thanks and Regards, Rp. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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
Re: $$Excel-Macros$$ Name Range Change through VBA
Sub chnage_address() Dim rng As Name, rngaddress As String, k As Long k = 30 For Each rng In ThisWorkbook.Names rngaddress = rng.RefersTo rng.RefersTo = Left(rngaddress, InStrRev(rngaddress, $)) k Next End Sub On Fri, Mar 7, 2014 at 12:54 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear All, Good Afternoon, I have one query . Can we change the Name Range with help of VBA for example below are the name range in my excel file I have to extend the range by 2...i.e 85000. if it is possible ..Kindly provide the code for the same. Abhijit_ =Details!$AJ$1:$AJ$65000 Bucket_ =Details!$U$1:$U$65000 Cdate =Details!$AB$1:$AB$65000 City_ =Details!$AF$1:$AF$65000 Code_ =Details!$W$1:$W$65000 Cweek =Details!$AD$1:$AD$65000 date_ =Details!$AB$1:$AB$65000 Edate =Details!$AC$1:$AC$65000 Eweek =Details!$AE$1:$AE$65000 Filter_ =Details!$S$1:$S$65000 Group =Vlookup!$B$2:$D$169 jo_ =Details!#REF! LOB_ =Details!$E$1:$E$65000 mode_ =Details!$B$1:$B$65000 Month_ =Details!$AH$1:$AH$65000 Oct_ =Details!$AG$1:$AG$65000 Owner_ =Details!$Y$1:$Y$65000 Ownerlob_ =Details!$Z$1:$Z$65000 Pornima_ =Details!$F$1:$F$65000 Reso_ =Details!$R$1:$R$65000 Resp_ =Details!$Q$1:$Q$65000 RLIWeek =Details!$AK$1:$AK$65000 SDM =Vlookup!$T$2:$U$46 Severity_ =Details!$M$1:$M$65000 Status =Vlookup!$L$2:$M$53 Status_ =Details!$AA$1:$AA$65000 Status_Oct =Details!$AI$1:$AI$65000 Week_ =Vlookup!$X$2:$Z$40 Zone =Vlookup!$F$2:$J$15000 Zone_ =Details!$X$1:$X$65000 Regards, Prafull Jadhav 9920553518 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Excel Forum available @ discussexcel.com
Hi Sir, Could you help me with vba codes. I need help on vba code to copy data from sheet 1 and paste in sheet 2. But the range to copy the data is different from the range to copy the data, for example : copy from (R20) and paste in (T10). The sheet 2 is a invoice, There is around 15 rows in sheet 1. so, it would be great if i can choose the row number to copy the data. Thanks in advance. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Excel Forum available @ discussexcel.com
Hi Sir, Could you help me with vba codes. I need help on vba code to copy data from sheet 1 and paste in sheet 2. But the range to copy the data is different from the range to copy the data, for example : copy from (R20) and paste in (T10). The sheet 2 is a invoice, There is around 15 rows in sheet 1. so, it would be great if i can choose the row number to copy the data. Thanks in advance. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Excel Forum available @ discussexcel.com
Hi Sir, Could you help me with vba codes. I need help on vba code to copy data from sheet 1 and paste in sheet 2. But the range to copy the data is different from the range to copy the data, for example : copy from (R20) and paste in (T10). The sheet 2 is a invoice, There is around 15 rows in sheet 1. so, it would be great if i can choose the row number to copy the data. Thanks in advance. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Excel Forum available @ discussexcel.com
try this see if it helps Sub test() Sheets(Sheet1).Rows(20:20).Copy Destination:=Sheets(Sheet2).Range(a15) ' to copy whole row Sheets(Sheet1).Range(R20).Copy Destination:=Sheets(Sheet2).Range(t10) ' to copy cell content End Sub On Sun, Mar 9, 2014 at 11:16 AM, Leo Ruphen logaroo...@gmail.com wrote: Hi Sir, Could you help me with vba codes. I need help on vba code to copy data from sheet 1 and paste in sheet 2. But the range to copy the data is different from the range to copy the data, for example : copy from (R20) and paste in (T10). The sheet 2 is a invoice, There is around 15 rows in sheet 1. so, it would be great if i can choose the row number to copy the data. Thanks in advance. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Excel Forum available @ discussexcel.com
Hi Ashish, Thanks for the prompt reply, But i have few columns to be copied to the invoice. Please refer attachment for more details Thanks and Regards Leo On Sunday, 9 March 2014 13:51:43 UTC+8, ashish wrote: try this see if it helps Sub test() Sheets(Sheet1).Rows(20:20).Copy Destination:=Sheets(Sheet2).Range(a15) ' to copy whole row Sheets(Sheet1).Range(R20).Copy Destination:=Sheets(Sheet2).Range(t10) ' to copy cell content End Sub On Sun, Mar 9, 2014 at 11:16 AM, Leo Ruphen logar...@gmail.comjavascript: wrote: Hi Sir, Could you help me with vba codes. I need help on vba code to copy data from sheet 1 and paste in sheet 2. But the range to copy the data is different from the range to copy the data, for example : copy from (R20) and paste in (T10). The sheet 2 is a invoice, There is around 15 rows in sheet 1. so, it would be great if i can choose the row number to copy the data. Thanks in advance. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Test.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet