I get some nasty error message and microsoft is giving me the following solution: http://www.microsofttranslator.com/B...523/en-us?fr=1
I don't have the program VB installed but get to it through Excel and click on ALT F11
Apparently I need to install some kind of Timer but get error message as described in picture 04374638bda14a48b36512503acfc081.jpg
Anybody that can help me out?
Last edited by pansovic; 01-12-2012 at 12:21 PM.
Hello pansovic,
Without seeing all of the code, I am making a guess. It looks like either the Timer object used in Visual Basic ( not the same language as VBA) or it could be a custom VBA Class Timer that uses the Window API Timer.
Any any event, it is missing in your code. Can you tell more about where you got the code? Can you upload your workbook for review?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi,
That looks like VB to me rather than VBA, so it won't work as written. Can I ask where you got the code or the workbook it resides in?
Good luck.
The code I got from the webiste that I have mentioned in previous note. Here a copyBy the way what is difference between VB and VBA and does that have influence on my error?Option ExplicitPrivate oWord As ObjectPrivate Sub Form_Load() Set oWord = CreateObject("Word.Application") Set cSysTray1.TrayIcon = Me.Icon cSysTray1.InTray = True Timer1.Enabled = False Timer1.Interval = 10End SubPrivate Sub Form_Unload(Cancel As Integer) cSysTray1.InTray = False Set oWord = NothingEnd SubPrivate Sub cSysTray1_MouseDblClick(Button As Integer, Id As Long) Timer1.Enabled = TrueEnd SubPrivate Sub Timer1_Timer() Timer1.Enabled = False oWord.Visible = TrueEnd Sub
Did you add that code in response to the error message? If so, it will not help and you should remove it, then tell us what code caused the original error.
Good luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks