DDECommand for Excel (None Specified)
At 11 OCT 1999 06:28:45AM Keith Flanagan wrote:
Does anybody out there know the syntax for opening an Excel Workbook using DDECommand ?
I've discovered that Word uses 'FileOpen .Name=MYDOC.DOC"' , but that stupid paperclip seems to have no idea about DDE and Excel !
Many thanks in advance
Keith Flanagan
CCS Group plc
At 11 OCT 1999 09:26AM Andrew Carey wrote:
Keith,
I'm not sure if this will work with XL97 but I use it all the time with the 16bit XL…
In Xl record a macro, making sure you use the save in XL macro script not VB script.
Perform the Open task via the alt-f & O or using the mouse.
Close the macro and view it.
The script saved can be used as a DDE command in square brackets.
Hope this works,
Best Regards,
Andrew.
At 12 OCT 1999 05:39AM Keith Flanagan wrote:
Andrew
Thanks for the tip, but I dont seem to have the option to save as Excel Macro with version 7.0 !
So, saved as a VB script and tried to call the macro using 'MyMacro.xlm' in the DDECommand, but that wouldn't play ball either.
Do you have any other ideas ?
Keith
At 12 OCT 1999 05:42AM Keith Flanagan wrote:
Sorry, forgot to mention….
I could do with passing the name of the workbook to open as a parameter, as it may be one of a number depending upon various flags set in the OI form..!
Keith
At 26 OCT 1999 11:58AM Andrew Carey wrote:
Excel 4 tells me to use:
DIRECTORY("C:\WHATEVER\YOU\LIKE")
OPEN("MYBOOK.XLS")
WORKBOOK.SELECT("Sheet1","Sheet1")
You could try this in XL7 and see what it does. It's backwardly compatible when it comes to workbooks, may its b.comp. with DDE