Excel VBA Program stopped working

[cebbie]

Hi all this is my first post so please be gentle with me.

I have an VBA in excel 2010 that I have been using for some time, it takes invoice details from one workbook and puts the details into another workbook.
It has suddenly stopped working. Dim exApp As Excel.Workbook has "Nothing" when I hover over it. I think I have all the references installed.

I am stuck.

I am not a VBA programmer but a am a software engineer(PLC Programing) and write small utilities to help me.

Can anybody help.

It was working on windows Xp and windows 7. I am currently running windows 8 pro, (official version). It stopped working in Windows 7. I did install office 2013 preview but I am now back with 2010.

Cheers Clive

[mrice]

Have you tried Application.Workbook as an alternative?

[g8r777]

The line:

Please Login or Register  to view this content.

should always show "Nothing" when you hover over exApp. All you've done with that code is declare a variable. You haven't set that variable to anything yet.

You could use the code:

Please Login or Register  to view this content.

also.

What do you mean by "stopped working"? Do you get an error message? Does the debugger pop up? If so, what row is highlighted?

It would also be helpful for you to attach a sample workbook.

[cebbie]

Sorry I did not give enough info.

here is what happens see attached image.

I added word to see if that worked ad it did its just Excel

The error I get I type mismatch. The workbook "invoice calculator" is the workbook I have open.

Cheers Clive

[mrice]

Suggest declaring appEx as a workbook rather than an application.