ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   about ontime (https://www.excelbanter.com/excel-programming/351081-about-ontime.html)

uma[_2_]

about ontime
 
I am doing automation using excel VBA.During that process i need to
print Adobepdf..
if i send print command using DDE then the Adobe pdf is creating save
pdf file name dialog.
To automate that also, i have to send enter key to adobe pdf save as
dialog...so i used sendkeys command;..
My code is like this:
DDEExecute ch, "[Print Spectrum]"
Sendkeys"{Enter}"
but the problem is once the control goes to pdf...it's not coming to
next line(sendkeys)..
how can i overcome this problem? Is there anyother way?
any suggestion...please help

Thanks and Regards,
uma.



All times are GMT +1. The time now is 02:24 AM.

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