Search results for query: *

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 =...

I don't believe VBA can record the line number when an error occurs but you could create a rough breakpoint flag that will give you a clue of its origin. I've used this crude code to identify key blocks of code that could potentially have an unexpected error. Sub force_error() Dim checkpoint...

Never one to give up easily. With some usefull help from Jon Peltier (check out his website - its got good content). He has discovered that in terms of Excel menus you can select "Chart/Chart Type/Standard Types" and check "Default Formatting" and this will force the chart back to allowing the...

I thought that might be the answer. Another feature of Excel ! Thanks for your time Skip.

In Excel 2003 I'm creating a very simple area chart with a legend placed to the right of the plot area. If I move the legend to say bottom of the plot area (right mouse click and "Format Legend/Placement/Bottom") the plot area itself automatically resizes to maximise the visibility. This is good...

Good idea but I do not have the option in this circumstance to export/import the Excel data to an Oracle database. Thanks for the suggestion.