sharpescalade
New Member
- Joined
- Sep 13, 2006
- Messages
- 5
THANK YOU SO MUCH FOR YOUR TIME!!! THANK YOU!
I know I MUST be doing something STUPID....
I am working SOLELY with OFFICE/EXCEL 2003 SP2
MACRO Security set to LOW
I have tried the entire DAY to get this to work.
Simple as this:
I have a excel document, it has some VB for a splash screen, and graphic indicators...
Nothing really special.. I am still working on it....
I want to use excel and the VB editor to launch different programs and FILES during different times....
I keep seeing many variations of SHELL and SHELLEXECUTE.....but none "cut and pasted" with my "file or program actual path" added will work.... I keep getting "Compile Error: Invalid Outside Procedure"...
even when i try a basic shell command such as:
Shell ("Explorer")
I get an error
(maybe its where and how I am doing the code)
=====================
NOTE: the SHELL explorer command I just picked for now to get things working.... i have other uses, but i dont want to use a complicated code until I can get a basic SHELL command working.
======================
I am simply:
1. making new excel base document
2. going to VB Editor(right click,code or ALT-F11)
3. creating a NEW MODULE
4. Pasting:
Shell ("Explorer")
5. Saving the document
6. Restarting the excel document
7. Then I get the VB editor popping up, and a error dialog box, "Compile Error: Invalid Outside Procedure"... and the "Shell ("Explorer") highlighted in yellow.....
(And just to check, if this worked, shouldnt I open the document, and then explorer would open as well???)
I was really unsure of where to put the shell commands as well... because one needs to startup when anyone opens the excel document, to minimize all windows, and just leave the splash screen up, then it times out and the actual excel document shows up...(at least thats my plan)..right now I have the splash, timer and document working...but I need the SHELL command to(when you start the excel document) minimize all the windows to the taskbar......which I was simply going to tell excel to SHELL to the "SHOW DESKTOP" command or link or something....(its actually a .scf file in windows, kind of a executable I guess)
and there needs to be some SHELL commands that will be controlled by command/userform buttons(How I can do this, hell I dont know)
note: all my SHELL commands will be linked to FILES and Programs... I dont need to import or export any excel data...... ALSO I need to understand all the variations of SHELL windows settings for ASYNC,SYNC working, MAXIMIZED/MINIMIZED(focused??) windows....
so really.. i need to know what the heck I am doing wrong and why no shell commands, even basic ones, wont run at all...
and I need to find out how to SHELL to minimize all windows, except my splash screen... then the excel doc will load after time-out...
then... i need to know how to SHELL via buttons on userforms or however people normally do it.......
note: I looked into doing some of this by marcos, but controlling and processing macros via VB looked like a huge PAIN........
THANK YOU SO MUCH FOR YOUR TIME!!! THANK YOU!
I know I MUST be doing something STUPID....
I am working SOLELY with OFFICE/EXCEL 2003 SP2
MACRO Security set to LOW
I have tried the entire DAY to get this to work.
Simple as this:
I have a excel document, it has some VB for a splash screen, and graphic indicators...
Nothing really special.. I am still working on it....
I want to use excel and the VB editor to launch different programs and FILES during different times....
I keep seeing many variations of SHELL and SHELLEXECUTE.....but none "cut and pasted" with my "file or program actual path" added will work.... I keep getting "Compile Error: Invalid Outside Procedure"...
even when i try a basic shell command such as:
Shell ("Explorer")
I get an error
(maybe its where and how I am doing the code)
=====================
NOTE: the SHELL explorer command I just picked for now to get things working.... i have other uses, but i dont want to use a complicated code until I can get a basic SHELL command working.
======================
I am simply:
1. making new excel base document
2. going to VB Editor(right click,code or ALT-F11)
3. creating a NEW MODULE
4. Pasting:
Shell ("Explorer")
5. Saving the document
6. Restarting the excel document
7. Then I get the VB editor popping up, and a error dialog box, "Compile Error: Invalid Outside Procedure"... and the "Shell ("Explorer") highlighted in yellow.....
(And just to check, if this worked, shouldnt I open the document, and then explorer would open as well???)
I was really unsure of where to put the shell commands as well... because one needs to startup when anyone opens the excel document, to minimize all windows, and just leave the splash screen up, then it times out and the actual excel document shows up...(at least thats my plan)..right now I have the splash, timer and document working...but I need the SHELL command to(when you start the excel document) minimize all the windows to the taskbar......which I was simply going to tell excel to SHELL to the "SHOW DESKTOP" command or link or something....(its actually a .scf file in windows, kind of a executable I guess)
and there needs to be some SHELL commands that will be controlled by command/userform buttons(How I can do this, hell I dont know)
note: all my SHELL commands will be linked to FILES and Programs... I dont need to import or export any excel data...... ALSO I need to understand all the variations of SHELL windows settings for ASYNC,SYNC working, MAXIMIZED/MINIMIZED(focused??) windows....
so really.. i need to know what the heck I am doing wrong and why no shell commands, even basic ones, wont run at all...
and I need to find out how to SHELL to minimize all windows, except my splash screen... then the excel doc will load after time-out...
then... i need to know how to SHELL via buttons on userforms or however people normally do it.......
note: I looked into doing some of this by marcos, but controlling and processing macros via VB looked like a huge PAIN........
THANK YOU SO MUCH FOR YOUR TIME!!! THANK YOU!