Thanks for your replies. We are not using DDE to update data to the
Excel sheet. Rather, a VB app. passes text files to the sheet. This info
is correctly updated into the sheet so long as the sheet is closed (the
VB app. simply takes the sheet as a target file where the data is to be
saved and executes the SAVE command). However, when the worksheet is
open, the VB app. passes the data, but on executing the SAVE command,
the data does not get refreshed or updated in the worksheet (we get the
message: "file already exists, do you wish to replace it?". Even though
we select YES from within the VB app. or even configure it so it omits
prompting the question, it does not replace it). Might there be a VB
command other than SAVE that we should be using instead that will cause
the data to update to the active worksheet?
Our workaround was to create a second worksheet linked to the original
one (which remains closed), that would refresh and display the new data.
We suspected that this problem may have had to do with the shared status
of the sheet, needing to configure the sheet as being shared between the
VB app. and the user. But when we set up this configuration, several
macros that are in the sheet do not run (error message: "value not
defined"). Is this suspicion correct or is there something else going
on?
Thanks in advance for your insight.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!