Thread: about ontime
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
uma[_2_] uma[_2_] is offline
external usenet poster
 
Posts: 1
Default 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.