Recent content by TopJack

Would it help if the question was ..... is the window inactive rather than busy. The window might or might not be the focus window (top window) Any help would be appreciated. Thanks.

Sorry experts, I thought this might be the best place to post this problem. I'm actually using VBA to find multiple windows running under XP and determine if the window is busy or not, ie waiting for user input. I have some code that can enumerate through all top level windows and identify the...

Thanks for the clarity JTBorton. Looking through the net I found these two websites that might give us a clue whats happening:- http://www.devnewsgroups.net/group/microsoft.public.office.developer.outlook.vba/topic57971.aspx Try specifying the local host. Set objOutlook =...

Thanks Asjeff. Very useful.

The code should work with or without Outlook being open. The routine creates a reference to Outlook but does not need it to be open. It sounds like your receiving the error message because of some other issue - I tried to investigate what the error message was actually reporting but couldn't...

Assuming you save your file before, you could use code similar to this for creating an e-mail without sending (assuming your e-mail client is MS Outlook aswell) ...... Sub create_email_for_editing() 'This routine will require "Tools\References" to "Microsoft Outlook X.X Object Library" Dim...

Have you checked out this very good article by CMP at faq707-6399 where you can identify web page input boxes and write to them.

Found out what was wrong in the end. It was how I declared the SetPrinter function and also the timing of when I close the printer. Thanks for the interest anyway. Here is the main block of code that I used in the end - I know its VBA but its similar logic :- Public Type PRINTER_INFO_9...

Sent this post over to the VB WIN API forum for help, thanks anyway ....... thread711-1490076

I posted this in the VBA forum thinking it was an appropriate place for the question - with the stunned silence that followed I guess maybe it was more of an API question. I'm trying to write this code in VBA but I guess it will be similar in VB. Here goes ........ I've been working on this for...

I found changing my two lines that call "GetPrinter" to access 9 seems to stop the "work first time only" effect. It consistently doesn't change the paper tray now without error !! GetPrinter(hPrinter, 9, 0, 0, nBytesNeeded) Do I not have the right authority to change the printer settings ...

I've been working on this for the last few hours and I can't seem to get it working properly. Any advice would be appreciated. I'm trying to get Excel(2003) to print (through XP platform) to a shared network printer but select the paper source (tray) at the same time. In Excel this seems...

Sorry, I will try there instead. Thanks.

Hello everyone, I have a table "TREND" that has data like this :- WEEK LOCN COST === ==== ===== 45........A......10 46........A......12 47........A......15 45........B......18 46........B......16 47........B......11 45........C......13 46........C......14 47........C......10 How do I...

Mizzness, I guess you are looking for code similar to this :- Sub paste_next_day() Dim first_row As Integer, last_row As Integer, columns_used As Integer Dim ws As Worksheet first_row = 11: last_row = 13 'declare rows to be copied Set ws = ActiveSheet 'declare current sheet columns_used =...