Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
mrako
in reply to: WCrihfield

Yes I also use it to show my forms.

Sub Show_Frm_TestExcel()
    'Show/Launch the UserForm named "Frm_TestExcel"
    Frm_TestExcel.Show
End Sub

Message box saying "File not found" show because file c:\Temp\test.xls  was not on disk 

(Kill "c:\Temp\test.xls")

the error is not checked in the code because I have the file on the disk

 

Your Question : 

"One is blank and the other says "Writing works" within cell A1.

Is this the odd behavior you were inquiring about?"

Answers  :  Yes

 

In short, the excel file will not create me.

It is interesting that every other

click on CommandButton   the excel file is create ?!!!

1st         show "GetObject still failing. Process ended."

2nd        File created  

3rd        show "GetObject still failing. Process ended."

4th        File created

.....

....

and I don't understand that

 

Would you be able to modify the code for me to make it work
Very interesting contribution also in terms of iLocic

 

He expresses himself very difficult with my weak English


Many thanks for trying to help me