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
>>>
>>>
>>>iam 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
