| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Automation/Immediate Window
Is it possible to type and execute code in the Immediate Window of an
instance of Excel automation? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Automation/Immediate Window
Yep. You may find it very useful when debugging. I'm not sure I would expect
the users of a workbook to do this, though. AA2e72E wrote: Is it possible to type and execute code in the Immediate Window of an instance of Excel automation? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Automation/Immediate Window
On clicking POST, I realised that my question would be misunderstood!
What I meant to ask was this: Is is possible for to type/write code programatically (from the client using Excel as an automation server) into the Immediate Window and execute it? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Automation/Immediate Window
I think it would be a real kludge. I remember someone posting code to clear
the immediate window from that instance of excel and it was basically a Sendkeys operation. (and when there was a glitch, it wiped all the code out a module). Depending on what you want to do, Windows Scripting Host has an evaluate command I believe. -- Regards, Tom Ogilvy "AA2e72E" wrote: On clicking POST, I realised that my question would be misunderstood! What I meant to ask was this: Is is possible for to type/write code programatically (from the client using Excel as an automation server) into the Immediate Window and execute it? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Automation/Immediate Window
I wanted to be able to execute code in the immediate window when I do not
need the result or when there is no result. I guess it is easier to add subroutines from the Client and then run them on the Server. An example of what I had in mind: From the Client, I wanted to be able to Name ThisFile As ThatFile where Name does not return a result. "Tom Ogilvy" wrote: I think it would be a real kludge. I remember someone posting code to clear the immediate window from that instance of excel and it was basically a Sendkeys operation. (and when there was a glitch, it wiped all the code out a module). Depending on what you want to do, Windows Scripting Host has an evaluate command I believe. -- Regards, Tom Ogilvy "AA2e72E" wrote: On clicking POST, I realised that my question would be misunderstood! What I meant to ask was this: Is is possible for to type/write code programatically (from the client using Excel as an automation server) into the Immediate Window and execute it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I "re-hook" my worksheet window to my Excel window? | Excel Discussion (Misc queries) | |||
| The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
| In Excel - how to delete new window created from window on tool ba | Excel Worksheet Functions | |||
| How do I undo the Excel, Window Menu, New Window command | Excel Discussion (Misc queries) | |||
| vc++ automation: opening chart as chart window and setting scale | Excel Programming | |||
Hybrid Mode
