XL07 Importing Form - Invalid File reference

[PeterMoran]

Hi,

I am trying to Import a Form into my "personal.xlsb" in XL07, and get the following error:

Line 8: Property OleObjectBlob in frmChangeCase had an invalid file reference.

Have just tried the same thing into a new "personal.xlsb" in XL10 where I understand the form has been tested.

Line 8 in the Form is:

OleObjectBlob = "frmChangeCase.frx":0000

I have not imported a form into VBA before so I selected "personal.xlsb" on the left of the VBA page and then selected File, Import.

Then I see an Error Window with:

Errors during load, Refer to log file for details.

The log file is as I have displayed above: "Line 8....."

Then a further window displaying:

"System Error - plus further details - not recorded.

Finally I get:

"Out of Memory!"

If the error is in line 8, how do I load the form to modify the code?

Thanks for viewing.
Any assistance greatly appreciated.

Peter Moran

 

[LaurieHamlin]

I'm not sure I'm following your question. You're importing an XL07 file into ___?
I've gotten that error in Excel before when running macros. Excel is limited in memory. I could run some of the macros, but it would run out of memory before completing.
I hope that helps at least somewhat.

 

[PeterMoran]

Hi Laurie,

Thanks for the reply and sorry for the delay.

I am in VBA, and trying to import a form "frmChangeCase.frm" into personal.xlsb.

I think I will end up trying to re-create the form myself, as I don't seem to be able to load it as would seem appropriate.

Many thanks.

Peter Moran

 

[combo]

You may also try to open both excel files (with the form and target one) and in VBE drag it from source vba project to the target project.

combo