in reply to Re: Using Win32::OLE and Excel - Tips and Tricks
in thread Using Win32::OLE and Excel - Tips and Tricks

I'm not sure that I understand your question. ALL of the above code assumes that the worksheet is open (Either by creating a new one, or by opening an existing one).

Are you getting some kind of error, or are you not seeing what you expect? The code that you seem to have omitted would probably help me determine what the matter is, and don't forget to use <CODE> </CODE> tags, it makes for much easier reading.

C-.

---
Flex the Geek

  • Comment on Re: Re: Using Win32::OLE and Excel - Tips and Tricks

Replies are listed 'Best First'.
Re: Re: Re: Using Win32::OLE and Excel - Tips and Tricks
by Anonymous Monk on Jun 25, 2002 at 18:21 UTC
    In fact, my problem is more about Excel rather than perl (I think).
    I was wondering if there is an option so when my perl program update a value in a cell I can see it immediately in Excel (the file is always open on my desktop)
[reply]
      If its always open on your desktop, make sure that you are only using the current, open instance of Excel, set your worksheet=ActiveSheet and don't close the worksheet or workbook before terminating your script. 
      my $Excel = Win32::OLE->GetActiveObject('Excel.Application')||
die "You gotta have it open first!!\n";
my $Sheet = $Excel->{ActiveSheet};

      [download]

      C-.

      ---
      Flex the Geek

[reply]
[d/l]

In Section Tutorials