Issue Importing Userform

[uk747]

Hi

I previously Exported a Userform

When I try and Import the Userform into a New Workbook I get popup message

Errors during load.Refer To Log - Log just says Line 0: (The file path to Where userform1.frm was exported to ) could not be loaded.

When I click OK I then get

Input past end of file:"

Any Ideas??

 

[Dan_W]

I can't say I've ever encountered that error.
The usual issues people experience when importing userforms are (off the top of my head):

• Missing an FRX file - when you export a userform, it generates two files - one with an FRM extension and another with an FRX extension. Both files need to be in the same directory when you try and import the FRM file. Could that be the issue?
• A userform of the same name already exists in a workbook - you can't import a userform into a workbook where the name is already in use, but it would say that in the error message and in the log.

The only other thing I can think of is perhaps there is something wrong with one of the files. The FRM file is a text file, and so can be read in Notepad or any other text editor. I wonder if maybe it's missing some code.

 

[Dan_W]

Actually, if your log is telling you that the problem is line 0, it might be a problem with the code after all. I'm not sure. Are you able to share the first few lines here? It should look something like:

VERSION 5.00
Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} LookAtMe 
   Caption         =   "LookAtMe"
   ClientHeight    =   5445
   ClientLeft      =   120
   ClientTop       =   465
   ClientWidth     =   6285
   OleObjectBlob   =   "LookAtMe.frx":0000
   StartUpPosition =   1  'CenterOwner
End
Attribute VB_Name = "LookAtMe"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

 

[uk747]

Hi

Prior to exporting the forms I was getting a system error which I debugged with no errors before exporting

It's.only when I tried.to reimport them into a new workbook I had the issue

Looks like it may have some other corruption that debug didn't pick up as when I looked at the frm file it didn't contain any code beyond the first part

VERSION 5.00
Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} userform1 
   Caption = "userform1"
   ClientHeight = 15000
   ClientLeft = 100
   ClientTop = 465
   ClientWidth = 18000

Didn't have a line called oleobjectblob and no frx file in the location of the frm

Guess that's the issue didn't export properly

 

[Dan_W]

It would seem not, I'm sorry. Any chance you can export the Userform again?

 

[uk747]

Can't export this time as don't have it to export. Maybe next time copy the code to textfile first ?

 

[Dan_W]

You shouldn't have to do that, but I've also been there a few times (and almost once again yesterday!) - it's not great. You have my sympathies. If you wanted to retrieve an image that was saved with the userform, that might still be recoverable from the FRX file - that's only semblance of hope I can give, if that helps at all.... but I suspect not. Sorry.

 

[uk747]

No problems. Thanks for your help Dan