Opening an entirely new process/instance of Excel

[touyets]

Hi all,

My file is all done and is awesome (thanks to some tweeks by you guys) but since it has a userform in it when it opens, it means that it does not allow users to go to another Excel workbook (that has nothing to do with the one with the userform), meaning that they have to close the file whenever they want to access another excel file for whichever reason and that's kinda lame.

Is there a way around this? I've tried looking for answers for about a week now and can't find anything usefull apart from the vbmodeless feature but that allows access to all Excel spreadsheets open but also therefore teh data inside the one with userform that I don't want them to edit manually.

I was thinking that having Excel open as a completely new instance when the file is open would solve this as it would be basically seen with Windows as a completely new program even if excel is already running but I'm not sure if I am right in thinking this or if it is even possible.

What I would like:
- when the excel spreadsheet opens, it appears but i have a userform that opens ontop of it taht doesn't allow access to the data on teh spreadsheet (that's fine since i don't want them to be able to just change data willy-nilly)
- if there is another excel workbook open at the same time I would like them to be able to view them whenever they wish without having to close the file with the userform.

Regards,

Simon

 

[Richard Schollar]

The troublemaker Von Der Heyden needed to do that too and he used this code from Jaafar:

http://www.mrexcel.com/forum/showpost.php?p=2411880&postcount=9

 

[touyets]

That does not seem to work on my Excel 2007. No idea why. I have however foudn a great absolutely fantastic way of getting this done but the issue it is not automated via VBA yet and I would love for it to be possible via VBA: http://www.vadriano.com/excel-vb/2007/04/12/how-to-open-excel-files-in-a-new-application-instance/

 

[Jaafar Tribak]

That does not seem to work on my Excel 2007. No idea why. I have however foudn a great absolutely fantastic way of getting this done but the issue it is not automated via VBA yet and I would love for it to be possible via VBA: http://www.vadriano.com/excel-vb/2007/04/12/how-to-open-excel-files-in-a-new-application-instance/

Note that the solution you provided in the link you posted will apply to every single workbook not just the one you are interested in.

I haven't tested my code in Excel 2007 . I'll test it tomorrow and see what I get.

 

[bobsan42]

try this in the VBA code:
http://www.mrexcel.com/forum/showpost.php?p=2410719&postcount=2

 

[Jaafar Tribak]

try this in the VBA code:
http://www.mrexcel.com/forum/showpost.php?p=2410719&postcount=2

Hi bobsan42.
That will only work if the workbook is opened via code.

- when the excel spreadsheet opens, it appears but i have a userform that opens ontop of it taht doesn't allow access to the data on teh spreadsheet (that's fine since i don't want them to be able to just change data willy-nilly)

Simon. Why not have your worksheet protected to prevent the user from changing the data.

If you then want to edit the worksheet via the UserForm then you can always Unprotect the sheet , make your changes and Protect it back.

Also, you can also protect the worksheet via code such as :

Sheets(1).Protect UserInterfaceOnly:=True

to allow the Macros to edit the worksheet but not the user.

 

[bobsan42]

well if Simon needs it to be opened through Windows Explorer or whatever - then he found the best solution in post #3 - yes it will be applied to all files but it is not the default action - just an additional option in the Context menu.

That does not seem to work on my Excel 2007. No idea why. I have however foudn a great absolutely fantastic way of getting this done but the issue it is not automated via VBA yet and I would love for it to be possible via VBA: http://www.vadriano.com/excel-vb/200...tion-instance/

how actually do you want to automate it via VBA (it is not impossible) - but if you want to do it on multiple computers the simple way would be an exported REG file.