$$Excel-Macros$$ Re: Macro to Automate a school timetable workbook
Hello Paul / Ayush, Can you guys help me or guide me on this one... Best regards, Dollar Chande On Friday, March 10, 2017 at 4:28:34 PM UTC+5:30, Dollar Chande wrote: > > Hi All, > > I am a novice at macro (very little knowledge) and would seek your kind > assistance on my attached sheet. I am a MS Office 2013 user and attached > sheet refers to automating a daily time table scheduling crisis I have to > go through for school. > > I have tried my best to input all info i know in the comments and "INFO" > sheet. > > Look forward to your kind help and guidance...thx > > Best regards, > Dollar Chande > -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Macro to Automate a school timetable workbook
Hi All, I am a novice at macro (very little knowledge) and would seek your kind assistance on my attached sheet. I am a MS Office 2013 user and attached sheet refers to automating a daily time table scheduling crisis I have to go through for school. I have tried my best to input all info i know in the comments and "INFO" sheet. Look forward to your kind help and guidance...thx Best regards, Dollar Chande -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book12.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Re: VBA Password help
Dear Harmeet, Thank you so much for your kind help, God bless ya, $ On Mon, Mar 30, 2009 at 9:56 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: Password is 1 On Mon, Mar 30, 2009 at 7:32 PM, DOLLAR CHANDE dollarcha...@gmail.comwrote: Dear All, I have reduced the size of the said file and attached it. Pls provide the VBA password for the same or any tool to get the password. Thx for your kind support, $ On Mon, Mar 30, 2009 at 1:12 PM, DOLLAR CHANDE dollarcha...@gmail.comwrote: Dear Wizards, I have a excel file which i tried to mail to the group for providing the VBA password bt as the size of the file is more than 7MB the mail came back. Request you to kindly provide a any way out enable me to open the macro/code, which will enable me to study the macros which could help me with my work. When we open this file and press ALT+F11 it asks for a password. If possible pls provide a software or a code that can help to unlock such file.. Thx a lot for your kind help. $ -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: VBA Password help
Dear Praveen, Thx a lot your guidance, I will surely give it a go n revert if any probs. Take care, $ On Tue, Mar 31, 2009 at 5:31 AM, Praveen Khunte praveen.khu...@gmail.comwrote: Hello Dollar Chande You can use software called Passware which finds the password for most of the applications like Outlook, Acrobat including Office. It is easily available.. just google it. Regards Praveen Khunte DOLLAR CHANDE wrote: Dear All, I have reduced the size of the said file and attached it. Pls provide the VBA password for the same or any tool to get the password. Thx for your kind support, $ On Mon, Mar 30, 2009 at 1:12 PM, DOLLAR CHANDE dollarcha...@gmail.comwrote: Dear Wizards, I have a excel file which i tried to mail to the group for providing the VBA password bt as the size of the file is more than 7MB the mail came back. Request you to kindly provide a any way out enable me to open the macro/code, which will enable me to study the macros which could help me with my work. When we open this file and press ALT+F11 it asks for a password. If possible pls provide a software or a code that can help to unlock such file.. Thx a lot for your kind help. $ --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ VBA Password help
Dear Wizards, I have a excel file which i tried to mail to the group for providing the VBA password bt as the size of the file is more than 7MB the mail came back. Request you to kindly provide a any way out enable me to open the macro/code, which will enable me to study the macros which could help me with my work. When we open this file and press ALT+F11 it asks for a password. If possible pls provide a software or a code that can help to unlock such file.. Thx a lot for your kind help. $ --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Calling all Wizard - Help needed in attached file
Dear Tom, I am so thankful to you for taking time and providing me this sheet...It would really help me a lot with my work.. I am sorry for the delayed reply as i am not able to login regularly, any how keep up the good work going.. God Bless, Dollar On Tue, Mar 3, 2009 at 8:30 PM, Tom Jeffries tjeff...@gmail.com wrote: Take a look at the attached workbook. I believe it does what you want. IAL-RD.xls serves as a template and can be re-used with any SC file as long as the format does not change. To use the workbook (1) Launch Workbook IAL-RD.xls (2) Click Import SC Button and enter name/location of input SC file for example c:\SC.xls A worksheet (SC) will be added and the SC data will be imported to it. (3) Click Build button HC worksheet is populated using imported SC data IAL worksheet is populated using imported SC data HC worksheet is exported as a seprate workbook c:\HC.xls IAL worksheet is exported as a text file c:\IAL.txt Counts are filled in on Sheet1 IF you want, the completed workbook can be saved UNDER A DIFFERENT NAME. Do not save the original workbook. If you have any questions let me know. Tom 2009/2/28 DOLLAR CHANDE dollarcha...@gmail.com Dear Tom, So thkful to u for your kind efforts, i really appreciate the help. Pls ref to some points: 1. Sheet HC needs to be generated from a macro from sheet SC and exported in the same format in excel and saved in C drive or the desktop (Attached file IAL-DBX9107-OCL.xls for reference). 2. Same ways the text file should be like the space delimited text file created by saving sheet IAL – R D. I have attached a text file (Format.txt) that can be used as guidance. The column width/no of characters required in text file is marked in sheet IAL – R D from column A – Q. The Gross wt. (column D in HC IAL R D) should contain 5 characters ( ex. 02.20 or 26.40 or 04.00 or 15.00) 3. Pls give your suggestion as to hw i can use this workbook every time i need to use it. I mean should i copy the main sheet (SC) or the whole workbook ? Cause i tried to copy to a new sheet bt it did not work. Kindly suggest the best possible way that wud not eat up lot of space on my pc. I really am amazed learning the tricks viewing the vba code that u put in bt i feel i am not competent enough to ustand it fully. Pls advice if any doubts for the above file and thanks a lot for your kind help. This will help me a lot. Requesting all the wizards to pour in with their views and suggestions, Best regards, Dollar Chande On Wed, Feb 25, 2009 at 6:25 AM, Tom Jeffries tjeff...@gmail.com wrote: Take a look at the attached workbook and see if it does what you want. I placed buttons on the SC worksheet for each function you describe. I wasn't sure how you wanted to export the SC worksheet as text so I exported it as tab-delimited. If you have any questions let me know. Tom On Mon, Feb 23, 2009 at 7:32 AM, DOLLAR CHANDE dollarcha...@gmail.comwrote: Dear Wizards (esp. Paul, Tom etc..) Ref to attached workbook, pls help meThis is a very simple task for you guys bt can b very time saving for me and help me in my job. I have given the instructions in Sheet 1, bt pls feel free to contact me for any further requirements. I am a novice and so have made some hap-hazard macros in the workbook which u guys can change/delete to better one. Pls also help to keep the size of the workbook small, so that i can copy n create a new one everytime i need to use it. Thx to all of you and anticipate a positive outcome.. Best Regards, Dollar Chande CTR410882CAXU326023702.202200E CHS MCFITOCL1N CTR430686CAXU674050102.202200E NYC MCFITOCL1N CTR410482CAXU676561802.202200E CHS MCFITOCL1N CTR260188CAXU900997504.004400E CHS MCFITOCL1N CTR261086CLHU850721004.004400E CHS MCFITOCL1N CTR410682FCIU312824802.202200E CHS MCFITOCL1N CTR101086GATU837412004.004400E CHS MCFITOCL1N CTR260688IRNU400481504.004300E NYC MCFITOCL1N CTR431282OOLU103900402.202200E CHS MCFITOCL1N CTR431084OOLU109316002.202200E CHS MCFITOCL1N CTR411086OOLU116979602.202200E NYC MCFITOCL1N CTR410886OOLU117824702.202200E NYC MCFITOCL1N CTR430682OOLU117936702.202200E NYC MCFITOCL1N CTR410584OOLU121053902.202200E NYC MCFITOCL1N CTR430886OOLU129270602.202200E NYC MCFITOCL1N CTR430482OOLU136109402.202200E CHS MCFITOCL1N CTR430484OOLU144218002.202200E NYC MCFITOCL1N CTR431286OOLU149405502.202200E CHS MCFITOCL1N CTR410384OOLU150501502.202200E NYC MCFITOCL1N CTR411082OOLU157505402.202200E CHS MCFITOCL1N CTR431284OOLU158307002.202200E CHS MCFITOCL1N CTR411286OOLU161329902.202200E NYC MCFITOCL1N CTR411084OOLU166622002.202200E CHS MCFITOCL1N CTR430584OOLU170582002.202200E CHS MCFITOCL1N