TOUGH MACRO - DARE TO CODE IT
in [Programming]
|
Prev: marvendas@gmail.com Kit completo de Solenoides ( solenoid ) + chicotePara Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 30942
Next: Question Responses
From: Skiffle on 20 Feb 2010 09:04 On Feb 20, 10:37 am, marcus <marcusinlond...(a)yahoo.com> wrote: > Hi Amit > > All of the information to complete this project is available online > through searches within Google. Being a student research should be > second nature to you and gleaning the information to perform this > simple task should be straight forward. > > I mean no disrespect and sincerely hope you get the answer you are > looking for through your own endeavours. VBA is a very intuitive > language and completing this project yourself with be liberating > rather than taking someone else's work and presenting it as your own. > > Take care > > Marcus "Amit Kumar" <amit4kumar(a)gmail.com> wrote >@all i understand that macro is intutive language but the thing is >that i don't know much about the vb >and its my assignment for which i had been given 3 days. >regarding the project i have created the button and have somewhat >figured out to sort the data but my problem is >1)how to connect the sheet 2 parameters to sheet1 >2) how to attach macro to the button so that when it is pressed it >sorts the data out > >if any of you have any idea how to do that >and don't preach,its my marks that matter. >i know there must be some subjects you don't know for ex. >@Marcus :- if someone asks you to give the biosyntheis of The aspirin >i bet nobody in the net can do this. >please understand when the subject is alien mere understanding doesn't >help >and i am not asking for readymade help at least make another macro for >attaching any simple code to a button and tell me hw you connected >themacro to button >i will figure it out then and will apply to my case Amit, Everyone who responded has been rather polite. I would advise you to reread Marcus' response. Now, I guess I'll be the bad guy. Given your last response, you don't seem to get it. No one here is going to do your homework for you. > ,,, i don't know much about the vb How do you expect to learn VB if you are simply given the answers. It is your research and attempts (right or wrong) that will help you learn. Were you given reference materials, a textbook for this course or assignment ? >and its my assignment for which i had been given 3 days. Better get crackin' ! > ... and don't preach,its my marks that matter. No, *you* only care about your marks. When you're out of school, other people really don't care what your grades were. It is your knowledge and intelligence that matter. Those qualities will help you in life. >i know there must be some subjects you don't know for ex. That is true for everybody but he's not asking for someone else to do his homework. I'm having some time with particle physics at the present time but, in a few weeks, no problem. > @Marcus :- if someone asks you to give the biosyntheis of The aspirin i > bet nobody in the net can do this. Actually, you are wrong. Aspirin is quite easy to synthesize. Even if this was true, I can find out how to make aspirin through the internet. It took all of 0.53 seconds Amit. http://science.csustan.edu/nhuy/chem1002/aspirin.htm > i am not asking for readymade help Yes you are > at least make another macro for attaching any simple code to a button and > tell me hw you connected > themacro to button i will figure it out then and will apply to my case Again, do your own homework. Learn. Skiffle
From: Don Guillett on 20 Feb 2010 09:23 We don't do homework. However, google is your friend, ie: excel: pivot table -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Amit Kumar" <amit4kumar(a)gmail.com> wrote in message news:36605d1c-2f92-4c24-ae91-97872c1b4800(a)m35g2000prh.googlegroups.com... > hi i am just a novice at the vba . now i have been asked to submi an > assignment that is: > > 1)Create a workbook having a button. When the user presses the button, > it should sort the data in sheet1 & then add subtotals to it. The > parameters required for sorting & subtotals are specified in the > sheet2. > > OR > 2)Create a workbook for generating the pivot table from the given > data. The parameters for the pivot table are to be specified in > sheet2. > > > please as i am a novice it would be so kind of any programmer if he > can send me the working excel sheet and yes its very urgent.|(2 days > only)gotta submit it by monday > >
From: marcus on 20 Feb 2010 15:38 Hi Amit Your course directors have put this course on your agenda as they think it is important and that you and your fellow students have the grey matter and research skills to pull it off. We could solve this for you in no time. But we are doing you a favour. Don even told you where to look and Skiffle in essence said that knowledge is what is really important. This will become very apparent when you leave school and employers start asking more about what you have done rather than what grades you got. Please dont disrespect the altruistic hard work that people do in this forum. From my own experience very few people say thank you but it is a bit rich when someone is critical when all we do is try to help. In your case (though you don't see it this way) helping is telling you to go and do some research and try and crack this yourself. I would point you to Dons post and ask you to look at the question and use that as criteria in the most powerful library ever created, the Internet. Take care Marcus
From: CellShocked on 20 Feb 2010 15:39 On Fri, 19 Feb 2010 22:25:43 -0800 (PST), Amit Kumar <amit4kumar(a)gmail.com> wrote: >On Feb 20, 10:37�am, marcus <marcusinlond...(a)yahoo.com> wrote: >> Hi Amit >> >> All of the information to complete this project is available online >> through searches within Google. �Being a student research should be >> second nature to you and gleaning the information to perform this >> simple task should be straight forward. >> >> I mean no disrespect and sincerely hope you get the answer you are >> looking for through your own endeavours. �VBA is a very intuitive >> language and completing this project yourself with be liberating >> rather than taking someone else's work and presenting it as your own. >> >> Take care >> >> Marcus > >@all i understand that macro is intutive language but the thing is >that i don't know much about the vb >and its my assignment for which i had been given 3 days. >regarding the project i have created the button and have somewhat >figured out to sort the data but my problem is >1)how to connect the sheet 2 parameters to sheet1 >2) how to attach macro to the button so that when it is pressed it >sorts the data out > >if any of you have any idea how to do that >and don't preach,its my marks that matter. >i know there must be some subjects you don't know for ex. > > >@Marcus :- if someone asks you to give the biosyntheis of The aspirin >i bet nobody in the net can do this. >please understand when the subject is alien mere understanding doesn't >help >and i am not asking for readymade help at least make another macro for >attaching any simple code to a button and tell me hw you connected >themacro to button >i will figure it out then and will apply to my case >\ Right click on the button and select hyperlink. Then select the link parameters and point it to a macro. Then work on the macro. Or do the macro first, then point to it with the button. Either way same result. You should be familiar with Windows too. Right clicking any object or screen element can very often provide choices that take you where you desire to go. Getting to know these sub menus as you use them in your experience with getting familiar with the application is how you gain the capacity to create workbooks that will process and display and report on your data in the most efficient, professional way. It optimizes your abilities along the way. Since you only have 3 days, I can see your need. You might get what you need, but you should remember that you studies cannot all be about your major. You have to take in the little details about all the other stuff too. Even if that means that you are not one of the 'see and be seen' crowd out partying on the weekends. If you record a macro where you right click on a pivot table and select "refresh data", and then save the macro, you should be able to examine the macro code to see what the pivot table update code segment is.
From: CellShocked on 20 Feb 2010 16:04
On Sat, 20 Feb 2010 08:23:22 -0600, "Don Guillett" <dguillett1(a)gmail.com> wrote: >We don't do homework. However, google is your friend, ie: >excel: pivot table Or "Windows interface basics". Step: Right click and examine available menu options. He said he placed the button, but can't get it to do anything. I think there is a slight lack of user familiarity with basic Windows human interface paradigms here. I see a LOT of this in today's world. Lots of slackers that just can't figure out why they can't find what they want, but did not even pay attention to the person that they got to do it for them, right in front of them. Desktop/Operating System familiarity is tantamount to being able to utilize computers in your educational and career choices optimally. Any lack causes your work efficiency level to cost others their time and ends up degrading office/school operational/educational efficiency/efficacy. Einstein said that we should not commit to memory anything that we can look up in a table or book. IF we merely commit to memory, the operational parameters of our computers, we can make his statement true with the vast cloud of information that is out there. Those that fail to perform this basic need will always be tugging away at other to help out. My mind is free because I can find anything out there. All these years of doing that means I AM familiar with this machine, and folks that are unaware of a simple right click menu function are really sport more serious character flaws in many cases. We see here one such flaw resulting in excuses like deadlines, etc. He only has 3 days, but how long has this assignment sat on his schedule sheet? OR how does this teacher have an expectation of familiarity with this application? What is the class, is the question? Is it an Office suite class, or is it some data management class? What? Doesn't matter. He should learn it. However, if he thought hard enough, finding out here is easy enough. MS has user submitted templates with tables and buttons like he wants, where he could easily sub in his criteria, and do so legally, since the sheets are submitted as being public domain, free to edit works. You have to learn it at some point, and there is no time like the present. |