Very Good information! On Thu, Oct 14, 2010 at 6:30 PM, Paul Schreiner <schreiner_p...@att.net>wrote:
> Do you mean to change the file associations? > > For that, what you do is change your own associations. > Then go to the system registry (using run -Regedit) > Find your .xlsx extensions, right-click and "export" the settings > to a file (it'll put a .reg extension) > You should get something like: > > [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\Open] > @="&Open" > [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\Open\command] > @="\"C:\\Program Files\\Microsoft Office\\Office12\\EXCEL.EXE\" /e \"%1\"" > [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\Open\ddeexec] > @="[open(\"%1\")]" > > [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\Open\ddeexec\Application] > @="Excel" > > [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\Open\ddeexec\IfExec] > @="[Rem Comment]" > > [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\Open\ddeexec\Topic] > @="system" > > > Do this again for .xlsb, .xls, .xlsm > > then edit the files you've created and combine them into one file. > > if you sent THIS file to the users, and have the execute it, the file > will update the settings. > > > hope this helps. > > Paul > > > *From:* sudheer lolla <sudheer1...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Thu, October 14, 2010 2:00:25 AM > *Subject:* Re: $$Excel-Macros$$ XLSB and XLSX related problem > > HI PAUL > > THANKS A LOT PAUL..IT REALLY WORKED..THAT WAS A PATIENT ANSWER....FULL > PRAISES FOR YOU.... > JUST ANOTHER DOUBT..CAN THIS BE DONE THROUGH WINDOWS DOS COMMAND..I DONT > WANT USERS TO DO ALL THIS.. ANY HOW AM RUNNING A SHELL COMMAND FROM EXCEL > ..IS THERE ANY WAY TO DO THIS WORK ALSO.. > > REGARDS > L SUDHEER > > On Wed, Oct 13, 2010 at 7:34 PM, Paul Schreiner <schreiner_p...@att.net>wrote: > >> Is the XLSTART folder on a network drive? >> >> How are you opening "any other excel"? >> Are you double-clicking on an excel file? >> >> First: a couple of definitions: >> when you double-click the Excel icon (not a file, but the Excel >> application icon) >> It opens an "instance" of Excel. >> It's like loading the entire Excel "software" into memory (ok, not really, >> but it's an analogy) >> >> If you double-click the Excel icon again, it opens a SECOND "instance". >> If you've ever opened two excel files and tried to do a formula like >> "=WB2!A3" >> so that it brings the content of the A3 cell of the second workbook (WB2) >> into the current >> workbook, you'd find that this only works if the two workbooks are in the >> same "instance". >> >> NORMALLY, when you double-click an excel file, it opens in a SHARED >> instance. >> That way, data can be exchanged, and Windows doesn't have the extra >> "overhead" of having >> the application loaded more than once. >> >> Now.. your configuration is "normally" set up to opan all files in the >> xlstart folder whenever >> you open an INSTANCE of Excel. >> That means that if Excel is not open, and you double-click on any Excel >> file, it opens that file, >> but then opens all files in the XLstart folder. >> >> But if your Windows setup is designed to open SEPARATE instances when you >> open >> workbooks, then the files in XLstart will open IN EACH INSTANCE. >> >> When you open a second file, since the files in the XLstart folder were >> already opened in the >> FIRST instance, it will notify you that you're opening them as Read-Only >> in the second instance. >> >> So.. I THINK your problem is actually that your Windows setup is opening >> Excel in separate instances. >> >> To fix that, >> Open "My Computer" (or Windows Explorer) >> Go to Tools->Folder Options >> and select the File Types tab. >> >> Go to the .XLSB extension and click the "Advanced" button. >> >> select "Open" and the "Edit" button. >> >> Your application should read: >> "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1" >> the "Use DDE" checkbox should be SELECTED. >> DDE Message: >> [Open("%1")] >> >> then, here's something that I discovered several months ago. >> It seems that the %1 in the Application box, and the %1 in the DDE Message >> box causes the file to be opened TWICE! >> (I found it in opening some LARGE files with EXTENSIVE macros) >> >> the trick I found is that you need to make an entry in the >> DDE Application Not Running box: >> [Rem Comment] >> >> this is a non-executable comment, so it doesn't DO anything, but evidently >> it makes it work properly... >> >> You'll need to change these settings for .XLS, .XLSX, .XLSM >> >> hope this helps, >> >> Paul >> >> >> *From:* sudheer lolla <sudheer1...@gmail.com> >> *To:* MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> >> *Sent:* Wed, October 13, 2010 7:18:46 AM >> *Subject:* $$Excel-Macros$$ XLSB and XLSX related problem >> >> Hi >> >> This is a very peculiar problem which am facing >> >> i have an *xlsb* which has some macros and is placed in *XLSTART* folder >> >> when an excel is opened the *XLSB* is attached to the *XLSX* file >> >> i*am saying attached because when any other excel is opened,XL is popping >> up message saying "XYZ.xlsb is READ-ONLY"* >> >> *i dont want this to happen.so when ever any other excel opens that has >> to open smoothly without any popups.How to do that?* >> >> -- >> 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 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 excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> >> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> >> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> > > > > -- > 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 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 excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > -- > > ---------------------------------------------------------------------------------- > 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 excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- 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 excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts