Re: update records in excel file
From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: Sun, 24 Feb 2002 10:30:57 +0000 (UTC)
Message-ID: <a5afd1$e05$1_at_helle.btinternet.com>
Date: Sun, 24 Feb 2002 10:30:57 +0000 (UTC)
Message-ID: <a5afd1$e05$1_at_helle.btinternet.com>
I suppose you could use DDE. You can access the values on the sheet like
this:
ActiveWorkbook.Worksheets("sheet1").Range("A1").value
But why not do it the other way around and fetch the information from Excel instead of posting it from Oracle. You can use SQL*XL to get the data hassle free into Excel. Have a look at SQL*XL at www.oraxcel.com
If you need to develop an automated solution you can even program SQL*XL actions in your Excel macro code. You can also use the macro recorder to make the code for you.
-- Gerrit-Jan Linker Author of SQL*XL: the addin for Excel to access databases http://www.oraxcel.comReceived on Sun Feb 24 2002 - 11:30:57 CET