General information
Category:
COM/DCOM and OLE Automation
Hi Terry,
I did some testing and put the following in as the first line in the Init of my object:
=strtofile("Only me","C:\hello.txt")
When I run the Excel macro, the file hello.txt is created.
If I delete the file and run the macro again, I get the error and the file is not created. I assume this means that my object isn't even being initialised - putting code in the Error method won't make a difference.
[I thought of the above because I considered putting the strtofile line in the Error method to write the error details to disk]
Best.
Matt.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only