![]() |
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