Open Only one Excel file in Excel Instance.

Posted on 2012-08-21
Medium Priority
Last Modified: 2012-09-20
Hi Team,

I have a .xlsm file that opens up as soon as a person logs into the system and then the file will also hide itself.  The reason for this is becuase the file is suppose to keep running in the back end to track some data usage.

Now everything runs fine.   Till the time the user open another excel file.  Now the hide instance of my Excel sheet becomes visiable.

I want a way were once my excel file is opened and then hidden.  If any other Excel files are opened they should open in another Excel Instance.  This way my file is never discovered.

Question by:Sandesh555
  • 2

Author Comment

ID: 38315717

I want to do this only for one file.  That is my Excel automation File.  Rest all files should be able to open in the same instance other than the instance in which my Excel Automation file is open.

For Example.

Lets say my Automation file name is ExcelAutomation.xlsm and a few other reports file like Report.xlsx, Report1.xlsx etc.

Now when the user logs in the ExcelAutomation.xlsm file will open automatically lets say in Instance A.  But when the user starts to open Report.xlsx this should open up in a differnt instance, lets say Instance B.  Now when the user goes to open Report1.xlsx.  this should open in Instance B so on.

I hope I have made my self clear.  :)

Sandesh Jadhav.

Author Comment

ID: 38315730

I dont want to disable this.  I only want my excel automation file to remain hidden and no other excel file should one in the instance my automation file is running in.
LVL 34

Accepted Solution

Rob Henson earned 1500 total points
ID: 38317028
This sounds similar to the situation with the Personal.xls file in Excel 2003 and earlier.

I have my Personal.xls to open from the xlstart directory but it opens hidden. I can then open files in the same instance of excel and the personal.xls does not show itself.

If I want to see the Personal.xls I can go to the Window menu and select Unhide, do what I need to and then Window > Hide. I guess you would have to add some protection so that the user cannot do this as well.

Rob H

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question