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)
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)