Hi Sudheer Please elaborate your problem last time, I'm not able to understand the chain mails. I hope, I'll be able to help you out, guide or atleast learn something from your problem.
________________________________________ Thanks & Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com ________________________________________ On Nov 11, 2:22 pm, sudheer lolla <[email protected]> wrote: > ---------- Forwarded message ---------- > From: sudheer lolla <[email protected]> > Date: Tue, Nov 2, 2010 at 9:56 AM > Subject: Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE > To: MS EXCEL AND VBA MACROS <[email protected]>, Paul Schreiner > <[email protected]> > > HI GUYS...JUST WANT TO KNOW WHETHER THIS IS POSSIBLE TO DO OR NOT..... > > On Tue, Oct 26, 2010 at 5:09 PM, sudheer lolla <[email protected]>wrote: > > > ---------- Forwarded message ---------- > > From: sudheer lolla <[email protected]> > > Date: Mon, Oct 25, 2010 at 10:42 AM > > Subject: Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE > > To: Paul Schreiner <[email protected]>, MS EXCEL AND VBA MACROS < > > [email protected]> > > > Hi > > > Theres no one who can help me out...Please guys > > > Regards > > SUDHEER > > > On Fri, Oct 22, 2010 at 12:17 PM, sudheer lolla > > <[email protected]>wrote: > > >> Hi Paul > > >> As i told that "I WILL BE SENDING THE .AVI FILE OF MY QUERY" .since the > >> screen capture software is not available with me am sending the screen > >> shots > >> with comments > > >> The screen shots are named sequentially(1.JPEG,2.JPEG).I work in the same > >> sequence .THERE WILL BE NINE JPEG FILES > > >> PLEASE HELP ME OUT OF THIS > > >> I WILL BE VERY THANKFULLY > > >> PLEASE LET ME KNOW FOR ANY QUERIES... > > >> THANKS > >> L SUDHEER > > >> On Tue, Oct 5, 2010 at 11:08 AM, sudheer lolla > >> <[email protected]>wrote: > > >>> HI PAUL > > >>> I GET U.BUT MY REQUIREMENT IS BIT DIVERTING...I WILL POST AN AVI FILE > >>> THAT SHOWS THE ACTIVITIES WHICH ARE BEING DONE ON THE FILE > > >>> BY THE WAY CAN I KNOW U R FREE TIMINGS SO THAT OUR INTERACTION WOULD BE > >>> QUICK ENOUGH > > >>> REGARDS' > >>> SUDHEER > > >>> On Mon, Oct 4, 2010 at 11:30 PM, Paul Schreiner > >>> <[email protected]>wrote: > > >>>> The macros that I posted will have an issue because you cannot > >>>> remove the "ThisWorkbook" module and import a new one. > > >>>> What you MAY have to do is to put the macro into a "temporary" .xlsb or > >>>> .xlsm file. > >>>> then, when the .xlsx file is opened, copy the sheet to the temporary > >>>> file > >>>> and close the .xlsx file. > >>>> If you planned to save and overwrite the file, you can always include a > >>>> saveas statement. > > >>>> Paul > > >>>> *From:* sudheer lolla <[email protected]> > >>>> *To:* [email protected] > >>>> *Sent:* Mon, October 4, 2010 12:26:16 PM > > >>>> *Subject:* Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE > > >>>> HI PAUL > > >>>> IF I KEEP A PIECE OF CODE IN "This Workbook" SAY I KEEP IN > >>>> "WORKBOOK_CHANGE" THEN WHENEVER SHEET CHANGES THIS WILL BE INVOKED > > >>>> FOR THIS TO HAPPEN I NEED TO COPY A MODULE FROM .XLSB INTO THAT > >>>> WORKBOOK.....THATS THE REQUIREMENT > > >>>> THIS .XLSX IS OPENED ON THE FLY...DONT KNOW WHICH XLSX USER WILL > >>>> SELECT..SO IAM KEEPING A MASTER .XLSB IN "XLSTART" FOLDER IN > >>>> MICROSOFT-->EXCEL-->XLSTART > > >>>> THIS MASTER .XLSB HAS A CODE THAT GENERATES A CUSTOM BUTTON.(THE CODE > >>>> FOR THIS IS KEPT IN "WORKBOOK_OPEN" EVENT IN .XLSB FILE) > > >>>> UPON CLICK OF THIS BUTTON..SOME VALIDATION ARE DONE ON THE SHEET(THE VBA > >>>> CODE FOR THESE VALIDATIONS ARE WRITTEN IN .XLSB FILE) AND ALSO CODE IN > >>>> "THIS > >>>> WORKBOOK" MODULE OF .XLSB IS COPIED INTO "THIS WORKBOOK" OF .XLSX FILE. > >>>> AND > >>>> ALL MODULES IN .XLSB FILE ARE COPIED INTO .XLSX. > > >>>> FOR THIS WHOLE THING TO HAPPEN . > > >>>> 1) .XLSB IS LOCKED > >>>> 2)WORKBOOK_OPEN OF .XLSB IS CREATING CUSTOM BUTTTON EVEN WHEN ITS LOCKD > >>>> 3)VALIDATIONS ARE DONE ACCORDINGLY > >>>> 4)BUT BUT THE MODULES ARE NOT GETTING COPIED INTO DESTINATION .XLSX FILE > > >>>> IF I REMOVE PROTECTION THIS WHOLE THING IS WORKING FINE > >>>> BUT WITH PROTECTION AM HANGING AT POINT 4)...THAT IS MODULES NOT GETTING > >>>> COPIED.. > > >>>> REGARDS > >>>> SUDHEER > > >>>> =============================================================== > > >>>> On Mon, Oct 4, 2010 at 9:20 PM, Paul Schreiner > >>>> <[email protected]>wrote: > > >>>>> Why do you want to copy the macros? > > >>>>> I have one application that has over 37,000 lines of code (macros) > >>>>> all in one protected workbook (both the workbook and VBA project are > >>>>> password protected) > >>>>> I run the macros which open 15 other files and operate on each one. > >>>>> At no time do I copy modules into these files. > > >>>>> what is the requirement that makes it necessary to have the macro > >>>>> reside in the xlsx file? > > >>>>> Paul > > >>>>> *From:* sudheer lolla <[email protected]> > > >>>>> *To:* MS EXCEL AND VBA MACROS <[email protected]> > >>>>> *Sent:* Mon, October 4, 2010 11:19:15 AM > >>>>> *Subject:* Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE > > >>>>> HI PAUL > > >>>>> THANKS FOR YOUR QUICK REPLY > > >>>>> I DON'T WANT THE FILE TO BE SAVED (THATS NOT WITHIN SCOPE WHETHER USER > >>>>> SAVES IT OR NOT)WITH MACROS > > >>>>> IN ORDER FOR THE EVENTS IN THE .XLSX TO BE RUN,IAM KEEPING THE MACROS > >>>>> IN "This Workbook" OF THE .XLSX FILE > > >>>>> MACROS WONT GET COPIED WHEN PROTECTION IS ON (.XLSB IS PASSWORD > >>>>> PROTECTED).I NEED TO UNLOCK THE XLSB COPY MACROS INTO .XLSX AND AGAIN > >>>>> LOCK > >>>>> THE .XLSB > > >>>>> AND ONE MORE THING THIS OPERATION OF COPYING IS TO BE DONE FROM THE > >>>>> LOCKED XLSB. > > >>>>> AM KEEPING THE CODE IN Workbook_Open AND UPON CLICK OF THE USER COPYING > >>>>> HAS TO BE DONE. > > >>>>> BUT HOW CAN I COPY FROM LOCKED XLSB FILE INTO XLSX FILE > >>>>> ================================================================= > >>>>> On Mon, Oct 4, 2010 at 3:10 PM, sudheer <[email protected]> wrote: > > >>>>>> Hi > > >>>>>> IAM IN URGENT NEED OF AN ADVISE THAT COULD HELP ME GET OUT OF THIS > >>>>>> PROBLEM > >>>>>> THE STEP BY STEP THAT NEEDS TO BE DONE ARE GIVEN .ONLY THING IS HOW TO > >>>>>> DO IT?? > > >>>>>> 1..Running a particular code from .XLSB file > >>>>>> 2..This .XLSB file is locked and i know the password also. > >>>>>> 3..Code which is in this locked .XLSB file runs satisfactorily. > >>>>>> 4.. When it comes to copying some modules from this locked .XLSB to > >>>>>> opened XLSX file.IT <http://file.it/> FAILS > > >>>>>> my understainding > > >>>>>> Since some code is running from locked .XLSB file, this copying code > >>>>>> also needs to be run > >>>>>> BUT THIS IS NOT HAPPENING WHY?? > > >>>>>> I TRIED ALL THESE > > >>>>>> --------------------------------------------------------------------------- > >>>>>> ----------------------------- > > >>>>>> Dim argPWD As String > >>>>>> argPWD = "tcs" > >>>>>> Dim VBP As VBProject > >>>>>> Set VBP = ActiveWorkbook.VBProject > >>>>>> MsgBox CStr(VBP.Protection) > >>>>>> If VBP.Protection <> vbext_pp_locked Then > >>>>>> Exit Sub > >>>>>> Else > >>>>>> Application.ScreenUpdating = True > >>>>>> SendKeys "%{F11}%TE" & argPWD & "~~%{F11}", True > >>>>>> End If > > >>>>>> --------------------------------------------------------------------------- > >>>>>> ------------------------------------ > > >>>>>> With Application.VBE.ActiveVBProject > > >>>>>> .SendKeys "lolla" > >>>>>> .SendKeys "{ENTER}" ' > > >>>>>> .VBE.CommandBars("Menu Bar").Controls("Tools") _ > >>>>>> .Controls("VBAProject Properties...").Execute > >>>>>> .SendKeys "^{TAB}" > >>>>>> .SendKeys "{TAB}" & "lolla" > >>>>>> .SendKeys "{TAB}" & "lolla" > >>>>>> .SendKeys "{TAB}" > >>>>>> .SendKeys "{ENTER}" > > >>>>>> End With > > >>>>>> --------------------------------------------------------------------------- > >>>>>> ------------------------------------- > > >>>>>> NONE OF THESE ARE WORKING > > >>>>>> PLEASE COMMUNITY MATES HELP ME > > >>>>>> -- > > >>>>>> --------------------------------------------------------------------------- > >>>>>> ------- > >>>>>> Some important links for excel users: > >>>>>> 1. Follow us on TWITTER for tips tricks and links : > >>>>>>http://twitter.com/exceldailytip > >>>>>> 2. Join our LinkedIN group @ > >>>>>>http://www.linkedin.com/groups?gid=1871310 > >>>>>> 3. Excel tutorials athttp://www.excel-macros.blogspot.com > >>>>>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >>>>>> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > >>>>>> To post to this group, send email to [email protected] > > >>>>>> <><><><><><><><><><><><><><><><><><><><><><> > >>>>>> Like our page on facebook , Just follow below link > > >>>>>>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;... > > >>>>> -- > >>>>> sudheer.L > > >>>>> -- > > >>>>> --------------------------------------------------------------------------- > >>>>> ------- > >>>>> Some important links for excel users: > >>>>> 1. Follow us on TWITTER for tips tricks and links : > >>>>>http://twitter.com/exceldailytip > >>>>> 2. Join our LinkedIN group @ > >>>>>http://www.linkedin.com/groups?gid=1871310 > >>>>> 3. Excel tutorials athttp://www.excel-macros.blogspot.com > >>>>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >>>>> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > >>>>> To post to this group, send email to [email protected] > > >>>>> <><><><><><><><><><><><><><><><><><><><><><> > >>>>> Like our page on facebook , Just follow below link > > >>>>>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;... > > >>>>> -- > > >>>>> --------------------------------------------------------------------------- > >>>>> ------- > >>>>> Some important links for excel users: > >>>>> 1. Follow us on TWITTER for tips tricks and links : > >>>>>http://twitter.com/exceldailytip > >>>>> 2. Join our LinkedIN group @ > >>>>>http://www.linkedin.com/groups?gid=1871310 > >>>>> 3. Excel tutorials athttp://www.excel-macros.blogspot.com > >>>>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >>>>> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > >>>>> To post to this group, send email to [email protected] > > >>>>> <><><><><><><><><><><><><><><><><><><><><><> > >>>>> Like our page on facebook , Just follow below link > > >>>>>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;... > > >>>> -- > >>>> sudheer.L > > >>>> -- > > >>>> --------------------------------------------------------------------------- > >>>> ------- > >>>> Some important links for excel users: > >>>> 1. Follow us on TWITTER for tips tricks and links : > >>>>http://twitter.com/exceldailytip > >>>> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > >>>> 3. Excel tutorials athttp://www.excel-macros.blogspot.com > >>>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >>>> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > >>>> To post to this group, send email to [email protected] > > >>>> <><><><><><><><><><><><><><><><><><><><><><> > >>>> Like our page on facebook , Just follow below link > > >>>>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;... > > >>>> -- > > >>>> --------------------------------------------------------------------------- > >>>> ------- > >>>> Some important links for excel users: > >>>> 1. Follow us on TWITTER for tips tricks and links : > >>>>http://twitter.com/exceldailytip > >>>> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > >>>> 3. Excel tutorials athttp://www.excel-macros.blogspot.com > >>>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >>>> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > >>>> To post to this group, send email to [email protected] > > >>>> <><><><><><><><><><><><><><><><><><><><><><> > >>>> Like our page on facebook , Just follow below link > > >>>>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;... > > >>> -- > >>> sudheer.L > > >> -- > >> sudheer.L > > > -- > > sudheer.L > > > -- > > sudheer.L > > -- > sudheer.L > > -- > sudheer.L > > > > dOUBT.zip > 929KViewDownload -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
