Problem using DDE to Save Excel spreadsheet 
Author Message
 Problem using DDE to Save Excel spreadsheet

I'm using VB6 to interact with an Excel spreadsheet using DDE such as reading
data from the spreadsheet as well as updating data. That's working fine. My
problem is how to issue a command to SAVE the spreadsheet.

The following code produces an error that says the "foreign application won't
perform DDE method or operation". Any thoughts?

txtLink3.LinkTopic = "Excel|Sheet1"
txtLink3.LinkMode = 1
txtLink3.LinkExecute "ActiveWorkbook.Save"

Sun, 21 Oct 2001 03:00:00 GMT  
 [ 2 post ] 

 Relevant Pages 

1. Using DDE to open an Excel Spreadsheet

2. Save embedded excel spreadsheet in access to excel file

3. Problems Updating Excel Spreadsheet using ADO and VB 6.0

4. Please help identify active row in DDE update of Excel spreadsheet Gary G

5. Add a row to a spreadsheet using a MS Access DDE-link

6. Open Excel Spreadsheet, Save, Close

7. Save Excel spreadsheet from Access

8. saving email info into excel spreadsheet

9. Save Excel spreadsheet to Public Folders???

10. Saving Excel Spreadsheet to STS thru VBA

11. Use VB to save Excel Spreadsheet as Tab Delimited File

12. Saving Excel spreadsheet with VB macro size increases


Powered by phpBB® Forum Software