ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   save file by DDE (https://www.excelbanter.com/excel-programming/359240-save-file-dde.html)

asburypark98[_2_]

save file by DDE
 
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 &
"<IndexGPC<GO")
Call DDEExecute(BLP, "<blp-1<home<SAVE<GO")


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


Call DDETerminate(BLP)



All times are GMT +1. The time now is 02:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com