Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print Extra session

Status
Not open for further replies.

P2A3W4E5

Technical User
Sep 22, 2003
6
US
Hi

I'm trying to automate printing, can anyone give me an idea for macro that will print the Extra screen and Extra info in excel spr sheet? So far I'm using:

AppActivate "MS excel - test"

sendkeys "^p",1 ' control + p

sendkeys {Enter},1



any ideas would be very helpfull

Thanks!

 
This is listed in your other post, but these FAQ's will help you abunch. Bascially, depends on exactly what you'r trying to do. SendKeys is not the best way to accomplish most task as the system doesn't know when it's done - even with the ",1".

faq99-4069 How do I use VB(A) to manipulate attachmate (6.5+)?
faq99-4068 How do I get data to Excel?

calculus
 
Sorry, That was someone else's "other" post.

Where did I leave my coffee?...

calculus
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top