Visual Basic :: Excel: Object Library Switching From 2000 To XP

Microsoft Office Object Library Excel 2003 And Excel 2000
Ciao Gurus,

I have developed an application with excel 2003 and, of course, it takes as reference the library of excel 2003, but most of the users have excel 2000 and the application goes in error when this reference is called. The library is Microsoft Outlook that in excel 2003 is 11.0 version while in excel 2000 is 9.0.
How can I fix the problem?
Best Regards
KAIALA

Edited by - kaiala on 7/2/2007 3:21:56 AM

Excel 2003 Vs 2000 Library Compatibility
Hi, some of the users of the report I've written are moving over to XP, and Excel 2003. the report was written in VBA in Excel 2000, and now there seems to be a problem with the macro.

an error is thrown on this line:

sheet.Shapes.Item(oldName).name = newName

But this line works fine when I run it on 2000.

Does anyone know about what changes there were to the libraries between 2000 and 2003? I noticed in the references, that the Excel Objecy library refers to EXCEL.EXE in 2003, whereas it refers to EXCEK9.OLB in 2000.

Excel Object Library
does someone knows where can I download the excel object library for excel 2000?

Excel Object Library
I am using VB6 and make a reference to the excel object library 8.0 in my program. If someone uses the program with Excel X, will the program still work?

Is there a way to reference all the excel librarys(sp?), Excel Object Library 8.0, 9.0 and 10.0?

Thanks for the help.

Excel Object Library
I'm developing an application which will run using Excel 97 but the PC I'm developing on has Excel 2000 installed. Will that give me trouble or how do I make sure that my app will be ok with 97?

Excel Object Library, Plz Help!!!
Hello, I want to calculate a math expression using the ms excel object library.
First, I add a reference (Project -> Add Reference->COM) to the Microsoft Excel 10.0 Object Library, then I write following code:

Public Class Form1
....
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim EXL As New Excel.Application()
' I want to evaluate 5*3+1
EXL.Evaluate("5*3+1")
End Sub
End Class

And the following message appears when I run the program:
An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in WindowsApplication3.exe

Additional information: Old format or invalid type library.

Could you please help me?? Do I make sth wrong?How could I fix it??
Thank you in advance?

Excel Object Library
hi
i am using vb 6.. installed excel 2000 in my machine.. but in references there is nothing named microsoft excel object library.. what is the problem.. does it requires re-installation of vb or excel or copying some files alone may help.. if so what files..

Excel 8 Object Library
Within my program I am accessing data from an Excel 97 spreadsheet. To do this I am using the Excel.Application, Excel.Workbook and Excel.Worksheet objects. I have added a reference to the Excel 8 object library, and all works fine.

However, I installed the program on another PC. This one does not have Office installed on it, but I made sure to check that excel8.olb got installed in the system32 folder (it's an NT box). When I try to run the program on this machine, it crashes with error 429: ActiveX component can't create object. This crash happens when it tries to instantiate the Excel.Application object.

Can anyone suggest why this is happening and post a solution? It would be much appreciated, and it's quite urgent. Thanks.

Excel 11 Or 12 Object Library In VB6
Hi,

I use VB6 to read data from Access and populate data on Excel Worksheets.

Currently I have Office 2003 installed on my development computer so in VB6, I use Microsoft Excel 11.0 Object Library reference.

In some cases, my customers may install Office 2007 on their own and use my VB application. Here are my questions:

1) If I compile my VB application with Excel 11 Object Library, will there be any problems to run the application on any machines with Excel 2007 (especially for creating and formating chart objects)?

2) If I install Office 2007 with Excel 12 Object Library on my development machine, then I compile my VB application. Should it work on any computers with Excel version 2000 to 2007? I think so but want to make sure.

3) Instead of installing Office 2007 on my computer, is there any Excel 12 Object Library plug-in which I can download and register on my computer so I can still compile my VB application?

Appreciate for any inputs.

Jeff

Excel 11 Or 12 Object Library For VB6
Hi,

I use VB6 to read data from Access and populate data on Excel Worksheets.

Currently I have Office 2003 installed on my development computer so in VB6, I use Microsoft Excel 11.0 Object Library reference.

In some cases, my customers may install Office 2007 on their own and use my VB application. Here are my questions:

1) If I compile my VB application with Excel 11 Object Library, will there be any problems to run the application on any machines with Excel 2007 (especially for creating and formating chart objects)?

2) If I install Office 2007 with Excel 12 Object Library on my development machine, then I compile my VB application. Should it work on any computers with Excel version 2000 to 2007? I think so but want to make sure.

3) Instead of installing Office 2007 on my computer, is there any Excel 12 Object Library plug-in which I can download and register on my computer so I can still compile my VB application?

Appreciate for any inputs.

Jeff

Various Excel Object Library
Hi folks

I made a small app to automate an excel spreadsheet from vb 6.0. it works fine when i run the program in the comp that has visual basic. I'm making the application in vb 6.0 SP5 in windows XP with Office XP.
When I created a setup using package and deployment wizard for that program and install it on Windows 98 with Office 97 or 2000 it doesn't run and gives me this error

"Run time error '-2147023067 (80070725)':Automation error

After looking at on various forums I decided to to try a better setup tool (Wise 5.1 and Installshiel 8). But I got the same result.

I know that Office XP is shipped with a different version of Object Library than Office 2000 or 97 (version 9 for Office 2000 and 10 for XP), so because my app has the 10.0 object version as a reference the program doesn't work.

I don't want to run multiple versions of Office on my computer or create different distribution depending the OS and Excel version.

I don't know if it is possible but I would like my setup to be able to install the right version of Object Library (8, 9 or 10) depending the target computer.

does it the right way to deal with this problem? Any other idea?

Thanks in Advance

Yann

Excel 8.0 Object Library
Hi ,

Anyone knows how to format an Excel column as Text before moving data to it
I was trying to move "2.10" to Excel as a string, but Excel misunderstands
that my data is numeric and it rounds it up to "2.1"

Thanks

Excel 8.0 Object Library
Hi,

I was trying to read Excel spreadsheets using Excel Object Library, and the
file is big (2 sheets , each has around 2000 rows).

I was some where near the end of my reading process when everything seems
to be hanging. I press Ctrl+Alt+Delete : evrything is not responding

And I've got Component Request Pending
message: "This action can not be completed because the application is busy.
Choose "Switch to " to activate the busy application and correct the problem"

I end up closing everything and have to reboot my computer.

Thanks for any help.

Excel Object Library
Hi

I want to append 1 more Sheet to my Workbook.
And I have trouble using :

dim MyWorkbook as Workbook
MyWorkbook.Worksheets.Add ([Before],[After],[Count],[Type]) as Object

What am I supposed to pass to [Before] or [After] ?

Thanks

Excel Object Library Reference
I have an Excel add-in program that is coded in VBA. It works fine until I loaded a vender's software. Now the add-in won't compile. It can't reference the workbook, worksheets and range objects. The reference is still set to the Excel 9.0 object library.

I have reinstalled Office and uninstalled the vender program. The uninstall said that not all components of the vender program were removed. The add-in still won't compile.

Any idea what the problem is?

Excel 8.0 Object Library Problem
I'm using VB 6 and I'm trying to write a program that will automate some Excel functions. I can open a new Excel Application and close it fine from within VB, but everytime I try to do some manipulation of the cells, rows, or columns I get an Automation Error -2147417848 (80010108).

The program works on another computer in the office (and I think the only difference is that it's running Windows Xp and mine is on 98, but it still uses VB 6 and MS Office 97). This made me think maybe my Excel 8.0 Object Library was corrupt. I've just recently uninstalled and reinstalled the Entire MS Office 97 suite. I get the same problem.

The following program demonstrates functions I'm trying to run and my methodology for doing so:

Code:
Private myExcel As Excel.Application
Private myWorkBk As Excel.Workbook

Private Sub Command1_Click()
Set myExcel = New Excel.Application
Set myWorkBk = myExcel.Workbooks.Add()
myExcel.Visible = True
myExcel.UserControl = False

End Sub

Private Sub Command2_Click()
Dim myrange As Excel.Range
Set myrange = myExcel.Range("A3:A7")
myrange.Formula = "Some Text" // <---- Errors Here
End Sub

Private Sub Command3_Click()
myExcel.Range("A3:A7").Copy myExcel.Range("D3:D7") // <---- Errors Here
End Sub

Private Sub Command4_Click()
myExcel.Quit
End Sub
I can click Buttons 1 and 4 all day long without a problem, but if I click 2 or 3 I get the automation error. Any help you can provide would be much appreciated.

Excel Object Library W/ VB6. Need Some Help/examples
After searching around the forums, I found a reference to the Excel Object library and some starting code:

Code:
Dim exl As Excel.Application
Set exl = New Excel.Application

etc..

How to I use the Excel Object Libary to just open Excel? (so I have a new workbook open to start interacting with). Every example I can find shows an existing sheet being open.

With what I'm doing I can not open an existing workbook or save a workbook. I just need Excel to open with a new blank workbook that I can use (interacting with it like the VB6 is really Excel VBA... all the good stuff).

Anyone have any good examples or links for the Excel Object Library?

Thanks...

Excel 9 Object Library Referencing
Hey All,

I got some great input from Paul Hinds about writting to an Excel file from VB, BUT when I try to run the additions to my previously running program I get error....
Referenced memory at "0x00000000". The memory could not be "read".

My thinking is that I am supposed to add Excel 9 object library in my referenced, but all I have available is Excel 10? How do I find the 9, if this is even my problem???

P.S. This is my favorite help site, some(I won't mention, but it's initials are esri) are not friendly at all.
Cheers
Debbie

Help Meee. Excel Object Library
i had vb 6 and excel 2000 installed in my machine.. found no excel object library in references.. then installed excel-97.. now found excel object lib 5 and 9..

my code goes like that
Dim objWrkSht As New Worksheet
dim X As Integer
Set objExcel = CreateObject("Excel.Application")

when 5 is used at
Dim objExcel As New Excel.Application
it displays
invalid use of new keyword

when 9 is used at
Set objExcel = CreateObject("Excel.Application")
it displays
variable uses automation type not supported in vb

wot is the problem.. i cant do any work becoz of that.. please reply me

Microsoft Excel Object Library
Where can I get Excel Object Library? I have Excel 2000, I have vb 6, I cannot find the Excel Library...

Microsoft Excel 8.0 Object Library
could you tell me where i can download this library?
For ocx controls we never seen before is there any way of getting some info on it??

Loading Excel Object Library
Fairly new to this!

I want to use Excel functions in VB6, like NORMDIST (normal distribution) etc, and in a post by wdb on 4/11/2002, one way might be to load Excel object library into my project - but I can't see how to do this!

I've looked in the Project menu / Components / Controls, and can't see any .dll or .ocx, or anything that refers to Excel.

Running Office XP, WIndows XP, VB6 Pro with SP5.

Any ideas please?

Thanks.

Microsoft Excel 11.0 Object Library Question
is there a way to view the compnents of Microsoft Excel 11.0 Object Library. Like a read out of all avaliable objects and properties etc...?

Thanks,
Nooch

Excel Object Library Causes My Subs To Fail
I turned on the Excel object library (in the lowest priority position) and now a couple of my subs don't work. I at first thought that it was something to do with the names of the subs conflicting with the names of some of the methods of Excel Objects, so I changed the following names:

closeMenus
openMenus

to:

closeDecisionMenus
openDecisionMenus

But I still got the same error message (type mismatch). As soon as I turned off the Excel object library they worked again. Any ideas?

Here is the script for the subs

Public Sub closeDecisionMenus(ByRef theToolbar As Toolbar)
'This sub-routine disables the menus that should only be available when the user has a project open

Dim i As Long

For i = 1 To theToolbar.Buttons.Count
If Not theToolbar.Buttons.Item(i).Caption = "File" And Not theToolbar.Buttons.Item(i).Caption = "About" Then
theToolbar.Buttons.Item(i).Enabled = False
End If
Next i

i = Empty

End Sub

Public Sub openDecisionMenus(ByRef theToolbar As Toolbar)
'This method enables all menus in the project:

Dim i As Long

For i = 1 To theToolbar.Buttons.Count
theToolbar.Buttons.Item(i).Enabled = True
Next i

i = Empty

End Sub

Microsoft Excel Object Library Question
Hello everybody

I`d like to know if the Microsoft Excel 11 Object Library, installed by Microsoft Office 2003, can be used on machines which might have another version of Microsoft Office installed.

Excel Object Library Compatability Issues???
Quick question for any who know.

I have almost finished writing an app for reading the data out of XLS files and writing to a DB. All is working well (in thanks to people here) but I am concerned about compatability.

If the system I am installing on has an older or newer version of excel installed will this have any effect?

I wrote my app with the Excel 8.0 object lib (office 97) but users may be on office 95 (excel 5) or office 2000 (excel 9) I'm only using the RANGE and WORKBOOK objects but would like to hear more before distribution.

Thanks

Missing Microsoft Excel 8 0 Object Library
A customer gave me code to download, and I am getting the following error. I do not have Excel loaded on my machine -- is there any way that I can just download the Excel object library ? Or do I need to be running a version of Excel ?

ToolBar1 && Microsoft Excel 12 Object Library Does Not Get Along?
Hi there, I have a project using Toolbar, and has being working great for such a long time.

Know i decided to make some improvements to my program, and one of the improvements is to export data on a MSFlexgrid to Excel. For that, i needed to add Microsoft Excel 12.0 Object Library.

When i run the program it appers to be a mistake on a SUB wich reads something like this:

The declaration of the procedure does not match with the description of the event or the procedure that has the same name.

The problem seams to be here:

Private Sub Barra_ButtonClick(ByVal Button As Button)

Where Barra is the name of the control Toolbar and the event is to catch the Button pressed.

The fact is, if I erase the Barra_ButtonClick Sub the Excel exporting works just fine.

Or

If i Take out the Object Library the ToolBar Event works great.

What can that be?

Please help more than apreciated!

VB 6.0 MS Excel Object Library 10.0 And Toolbar Problem
Hi! I'd appreciate if anyone could help me ....

Referencing to Microsoft Excel 10.0 Object Library will generate Run time error 13 "Type Mismatch" at
Set btnX = Toolbar1.Buttons.Add(, "open", , tbrDefault, "open") line below but if MS Excel Object library 10.0 is unreferenced in my vb 6.0 prj, the toolbar works fine. I need to reference MS Excel Object Library 10.0 and the toolbar buttons. What can I do to eliminate this run time error?

Private Sub Form_Load()
' Create object variable for the ImageList.
Dim imgX As ListImage

'Load pictures for the Toolbar buttons into the ImageList
'control.
Set imgX = ImageList1.ListImages. _
Add(, "open", LoadResPicture(101, vbResBitmap))

Set imgX = ImageList1.ListImages. _
Add(, "save", LoadResPicture(102, vbResBitmap))

Set imgX = ImageList1.ListImages. _
Add(, "exit", LoadResPicture(103, vbResBitmap))

Toolbar1.ImageList = ImageList1

' Create object variable for the Toolbar.
Dim btnX As Button

' Add button objects to Buttons collection using the Add method.
' After creating the button, set the Description and ToolTipText
' properties.

' Create Open Button
Set btnX = Toolbar1.Buttons.Add(, "open", , tbrDefault, "open")
btnX.ToolTipText = "Open"
btnX.Description = btnX.ToolTipText

' Create save Button
Set btnX = Toolbar1.Buttons.Add(, "save", , tbrDefault, "save")
btnX.ToolTipText = "save"
btnX.Description = btnX.ToolTipText

' Create Exit Button
Set btnX = Toolbar1.Buttons.Add(, "exit", , tbrDefault, "exit")
btnX.ToolTipText = "Exit"
btnX.Description = btnX.ToolTipText

With Toolbar1
.Wrappable = True ' Buttons can wrap.
End With
End Sub

Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
' Use the Key property with the SelectCase statement to specify
' an action.
Select Case Button.Key
Case Is = "open"
Call cmdFileSelect(blnSndpath)
Case Is = "save"
Call cmdInsert(blnSndpath)
Case Is = "exit"
Call cmdQuit
End Select

End Sub

Thank's in advance!

Speed Whan Working With A Excel 10.0 Object Library
I’m busy working on an application that saves data into a SQL database through a front-end. I am busy creating a system to export this data into a spreadsheet when needed so that it can be saved as a document by the user when needed using the Excel object 10.0 Object Library.
I am finding this whole process painfully slow as editing 100 odd cells is taking over a minute, and I’m sure this will exponentially increase as more data needs to be put onto the spreadsheets.
Below is a simplified copy of the code i am using.

VB Code:
Dim xls As ObjectSet xls = CreateObject("Excel.Application")xls.Workbooks.Open Filename For n = 0 To 52xls.Range("G" & N + 12).Value = RsProjects.Fields(N + 6 + 53 + 53 + 53 + 53)next n xls.Visible = True

Is there any way of speeding this process up or perhaps even using another method I am unaware of

Any comments are appreciated
Thank you in advance

Microsoft Excel 10.0 Object Library And Toolbar Problem
Referencing to Microsoft Excel 10.0 Object Library will generate compile error: Run time error 13 "Type Mismatch" at
"Set btnX = Toolbar1.Buttons.Add(, "open", , tbrDefault, "open")" code below. Please, help if you can, Thank's.

Private Sub Form_Load()
    ' Create object variable for the ImageList.
    Dim imgX As ListImage

    'Load pictures for the Toolbar buttons into the ImageList
    'control.
         Set imgX = ImageList1.ListImages. _
            Add(, "open", LoadResPicture(101, vbResBitmap))

         Set imgX = ImageList1.ListImages. _
            Add(, "save", LoadResPicture(102, vbResBitmap))

         Set imgX = ImageList1.ListImages. _
            Add(, "exit", LoadResPicture(103, vbResBitmap))

    Toolbar1.ImageList = ImageList1

    ' Create object variable for the Toolbar.
         Dim btnX As Button

    ' Add button objects to Buttons collection using the Add method.
    ' After creating the button, set the Description and ToolTipText
    ' properties.

    ' Create Open Button
         Set btnX = Toolbar1.Buttons.Add(, "open", , tbrDefault, "open")
            btnX.ToolTipText = "Open"
            btnX.Description = btnX.ToolTipText

    ' Create Save Button
         Set btnX = Toolbar1.Buttons.Add(, "save", , tbrDefault, "save")
            btnX.ToolTipText = "save"
            btnX.Description = btnX.ToolTipText

    ' Create Exit Button
         Set btnX = Toolbar1.Buttons.Add(, "exit", , tbrDefault, "exit")
            btnX.ToolTipText = "Exit"
            btnX.Description = btnX.ToolTipText

    With Toolbar1
            .Wrappable = True ' Buttons can wrap.
         End With
End Sub

Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
    ' Use the Key property with the SelectCase statement to specify
    ' an action.
    Select Case Button.Key
        Case Is = "open"
         Call cmdFileSelect(blnSndpath)
    Case Is = "save"
         Call cmdInsert(blnSndpath)
    Case Is = "exit"
         Call cmdQuit
   End Select

End Sub

If Add Reference To Excel 9.0 Object Library And Set Button On Toolbar , Error
Hi, i am getting error if i add reference to Microsoft Excel 9.0 object library

1. add reference to Projext->Reference and select Microsoft Excel 9.0 object library
2.add one toolbar on form1
3. Run the following code

Private Sub Form_Load()
Dim btnX As Button
Toolbar1.Buttons.Add (1)
Set btnX = Toolbar1.Buttons(1)
End Sub

if you remove the reference then everything will work fine but if add reference then type mismatch error

why these error is occuring ?

MS Word 98 Object Library With Word 2000
I wrote a program that uses the Microsoft Word 8.0 Object Library to write to Word documents, etc. Will that program run unmodified on a PC that has Word 2000 rather than Word 97?

Excel Object 11.0 Cannot Run In Office 2000
I have implemented a VB6 program which export data into an excel file directly from the program using Microsoft Excel Object 11.0. However, when I tried to run my program in users' computer, an unknown error was found. After checking, it was found that the difference in that I am using office 2003 while the user is using office 2000. Is it related? If yes, how can I solve the problem besides upgrading users' office?

Trouble Switching From Access 97 To 2000 With VB5.0
When data base converted from Access97 to 2000 get the error "Unrecognized database format " path name". I asked a similar question last week about this. Was told that service pack 4 would fix. Can't find one for Visual Studio 97 just 6.0. Two questions. Where to get the service pack 4 for Visual Studio 97? Will I still have this problem if I try converting to Access 2003 or was it fixed with 2003?

Quirky AdvancedFilter On Range Object (Excel 2000)
Hmm, my code is quite simple...

Code:
Private Sub cmdPullUnique_Click()

On Error Goto ErrHandler

Range("f1:f10000").AdvancedFilter xlFilterCopy, ,Range("j2"),True
Range("j2").Delete (xlShiftUp) 'Deletes the first entry, which always causes a duplicate

Exit Sub

ErrHandler:

Exit Sub 'Clicking on the button more than once creates an error, so I ignore it
End Sub
I'm trying to figure out why the first value, if it is repeated anywhere in the range ("f1:f10000"), will show up again in the first spot in the list where it is afterwards, creating aa duplicate entry...Any ideas why only the first value behaves like this? I'm quite confused at the moment. For now, I'm just deleting the first value in the set, since I know it will be returned again (my data is predicatable enough that this is a certainty)

Edit by Moderator:
Please post Excel questions, in the Excel forum.

Please use the [vb][/vb] tags when you post your code. Edit or reply to this post to see how.

Thank you.

Project Reference, "MISSING: Microsoft Excel 10.0 Object Library"
I am writing a program that requires the Microsoft Excel 10.0 Object Library. I just moved the project to a new development machine that does not have Microsoft Excel installed on it, and I do not have my Excel cd with me here. Is there anyplace that I can get download the object library, or will I have to wait until I have the cd with me?

Switching Windows In Internetexplorer Object
I have a program that is acting a more of a macro than anything else. I loads a web page, enters the correct data, and a pop up window appears. I would like to retrieve data from this pop up window, but I cannot find a way to get the internetexplorer object to recognize a window that it did not directly create. Is there any way around this issue?

Object Library Invalid Or Contains References To Object Definitions That Could Not Be Foun
Does anyone what this message mean:
"Object library invalid or contains references to object definitions that could not be found"

I tried to compile a VBAproject and I got this message.

*RESOLVED* Identify Object Library To Which Object Belongs
Hi,

I have inherited a VB6 application which was written by someone who is no longer with the company.

I need to distribute his application but I have noticed that he used some objects from the Forms2 object library.

As you are not allowed to distribute applications that use this library, I have to work through his application and replace forms2 objects with others.

I have replaced the obvious ones (spin button) but when I try to remove the Forms2 component from the project, it tells me that some controls are still in use.

How can I tell which objects belong to the Forms2 library?

As always, any help greatly appreciated.

VBA Excel - Switching Between Aps
I have built an application in Excel but when I try to switch over to a seperate excel worksheet it wont allow me to switch to it unless the VBA program has been ended. Is this something you just have to deal with or is there a work around?

Switching Between Different Instances Of Excel
I have written an application that opens excel and transfers some data to a worksheet and then saves the worksheet and closes excel. It does transfer data when multiple instances of Excel are open. It doesn't transfer data when there are multiple instances of the same file open. Is there a way around this?

I have declared an object that is why it transfers data when multiple instance of excel are opened.

Thanks,

Animaul

Switching Sheets In Excel
Does anyone know if you can add a control character to a CSV file, so that when its loaded into Excel it will force Excel to switch to the next worksheet ?

Microsoft CDO For Exchange 2000 Library
Hi folks,
I am sending an email from a form in VB and i require the following reference to be oncluded in my project:

Microsoft CDO for Exchange 2000 library

However, i cannot seem to find it on my computer and i was wondering if anoyone knows where i might be able to access this reference. I have looked on the net and i have been told that it is availbale via Outlook 2000 or indeed Exchange server 5.5, but i have Outlook on my PC and i still cannot find the reference. I have also checked Exchange server and could not find it there either.

I am stuck at this point and would be very graateful for some help.

Thank you all in advance.

Switching From Excel Back To VB6: I Need A VB6 Event!
Hi Everyone,

BACKGROUND:
I have a VB6 application that uses two forms, the first is the parent, and the second is the child. The child form interacts with Excel, and the Excel cursor position can be modified from time to time.

QUESTION:
When I return to my child VB6 form, after moving the Excel cursor, I'd like to notify my application via some sort of event.

PROBLEM:
Unfortunately, the Form_Activate() event is triggered only when the focus is changed between the two forms (parent and child), not when the child has focus, then Excel has focus, and then the child has focus again. Form_GotFocus won't work either.

Any ideas on how I can tell my application and/or child form that it is active again?

Thanks guys,
Andrew.

Please reply to,
abruce@zenon.com