I've asked the users who've reported this to me to respond and tell me exactly what happened. All I've got so far is "there was an error message and then nothing happened". I'll post more details when I get them. I don't have 2007 available to me to test.
Richard
Hello.
I have a VBA application written in Excel 2003 that works just fine. However, when a user opens the workbook in Excel 2007 the appication errors out and won't run.
Are there any hints or tips to make sure an app will run fine in 2003 or 2007 ?
Richard
Thanks, everyone. The problem was that I've mostly worked in VB itself rather than VBA, and the differences keep biting me.
Fumei is right... using the dropdown list would have saved me hassle :-)
Richard
Hi all, I'm obviously missing something basic here.
When a form (frmOpenSplash) opens, I want it to display a value in a label. I can't get the Form_Open() event to work at all though.
My code is...
Private Sub Form_Open()
lblNoOfQuestions.Caption = "20"
End Sub
I've also tried Private sub...
Sorry, I had missed copying over some of the code :-(
Here is the full coding I am using now...
Private Sub cmdFinished_Click()
Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = "Sample test results message"
objMessage.Sender = "rickalty@myserver.com"
objMessage.To =...
Thanks, I followed that link, and looked further into CDO, but can't get it to work.
I got this sample code...
Private Sub cmdFinished_Click()
Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = "Sampling test results"
objMessage.From = "me@myserver.com"
objMessage.To =...
Hi everyone, I have an online test that is completed on a SharePoint site. When the user finishes the test, I'd like the results (the test is scored as it goes, and the results listed on a worksheet) to be emailed to me.
I know I can use "ActiveWorkbook.SendMail" to send the whole workbook to...
He everyone, I have a form that I wish to print. I've put a button on the form to print it, but I don't want the button itself to print.
I've done this...
"frmEQLabel.cmdPrintEQLabel.PrintObject = False"
but it errors out, saying that the class or data member "PrintObject" is not found. What...
Hi... On a 012 with ring generator, we wish to use a regular basic one-line phone, but have it set on delayed ring. However, since it's not a Merlin phone I can't do the feature *36 to set the line to delayed ring.
I assume I have to do it from the MLX-20 through system programming, but I...
Hello, everyone.
We've just returned to service a Merlin Legend R3 system that's been out of use for a year or so. I've installed it, run all the wiring and set it up and everything is working fine with one exception - the line selection on the operators phone.
The system has 7 outside lines...
Hi there, thanks.
No, I've checked in Add/Remove Programs and it doesn't seem to appear there. Nor does it show up in Task Manager. I also searched the web for reference to it, and couldn't find anything there either - which is why I asked here, at the all-knowing font of wisdom and...
Hi everyone. I have started seeing an error that the above program - "eglEClientCommandWnd" - is not responding when I shut down Windows 98SE. Can anyone tell me what this is, and how do I stop these errors ? The program does not show up in my task manager when the computer is...
:-) Well, "Duh".... I was partly right about it being something to do with the multilingual thing though - on the letter key I'd printed out, it showed "N" at the top of the right hand column, as being 64, but it also showed it on the bottom of the left hand column as being...
Hi - I'm programming the voice mail (MLM007) on a Legend release 6.1, and it's going OK except for one problem - the system isn't recognizing the letter "N" in mailbox names. For example, I enter "53 21 64 23 #" and the system responds "Mailbox name is L A C"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.