Solved

DDE Built-In package - APP_BEGIN function

Posted on 2004-11-02
3,353 Views
1 Ratings
Last Modified: 2008-01-09
In the below block of code the dde.app_begin function is attempting to open c:\index_values.xls
I want to use this code but I want to open c:\Documents and Settings\WDG4\Desktop\local\file.xls
But it blows up cause of the space located after the 's' in Documents and the 'd' in and.  I need the exact line of code please for the dde.app_begin line.



DECLARE
      appid pls_integer;
      convid pls_integer;
      x  number;
BEGIN
  appid :=    
    dde.app_begin('c:\program files\microsoft office\office\excel.exe
                                 c:\index_values.xls',dde.app_mode_minimized);

    convid := dde.initiate('EXCEL','c:\index_values.xls');
1
Question by:wesunivofmd
    1 Comment
     
    LVL 22

    Accepted Solution

    by:
    You can try this (I have added SYNCHRONIZE):

      appid :=    
        dde.app_begin('c:\program files\microsoft office\office\excel.exe
                                     c:\index_values.xls',dde.app_mode_minimized);

    SYNCHRONIZE;

        convid := dde.initiate('EXCEL','c:\index_values.xls');
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone. Privacy Policy Terms of Use

    Featured Post

    The Complete Ruby on Rails Developer Course

    Ruby on Rails is one of the most popular web development frameworks, and a useful tool used by both startups and more established companies to build strong graphic user interfaces, and responsive websites and apps.

    Suggested Solutions

    Title # Comments Views Activity
    query run slowness in 12c 23 84
    get missing data 3 33
    Extract only part of data 5 52
    Stay Alert! 13 37
    Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database

    877 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now