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
