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
