PennStateBrian
New Member
- Joined
- Aug 27, 2007
- Messages
- 24
I have a resource intensive excel spreadsheet and I'm trying to make it run cleaner for my end users. One idea I had was to increase the priority windows gives excel when this speadsheet is open. I'm close to getting what I want, but am stuck on the code. Right now I have the below.
Private Sub Workbook_Open()
Shell (cmd /c start /high excel.exe)
End Sub
The problem is, this starts a new excel document at a high priority, but does not change the current environment. Another option is to have the shell call a batch file, but because this is for end users, I want to keep it hardcoded as to reduce the number of files that need to be sent.
Private Sub Workbook_Open()
Shell (cmd /c start /high excel.exe)
End Sub
The problem is, this starts a new excel document at a high priority, but does not change the current environment. Another option is to have the shell call a batch file, but because this is for end users, I want to keep it hardcoded as to reduce the number of files that need to be sent.