save the file by DDE

A

asburypark98

Hi,
could someone suggest me how can I save the graph
called by the second row of the code below, in a specific directory
(ex.: C:\Graphs) ?
I've used "SAVE" command but unfortunately it gives me a window for a
directory
which isn't the one I want.
I've tried to use "SAVE.AS" command in different ways but I've always
failed...

Any help very appreciated
---------------------------------------------------------------------------­--------------------------------



BLP = DDEInitiate("winblp", "bbk")
Call DDEExecute(BLP, "<blp-1><cancel>" & ActiveCell.Text &
"<Index>GPC<GO>")
Call DDEExecute(BLP, "<blp-1><home><SAVE><GO>")

'Call DDEExecute(BLP, "<SAVE.AS>")

Call DDETerminate(BLP)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top