Reputation: 299 Architect
- Active Posts:
- 1,760 (0.95 per day)
- 26-March 09
- Profile Views:
- Last Active:
- Today, 01:28 PM
- OS Preference:
- Who Cares
- Favorite Browser:
- Favorite Processor:
- Favorite Gaming Platform:
- Your Car:
- Who Cares
- Dream Kudos:
- Expert In:
Posts I've Made
Posted 12 Apr 2014Not all that familiar with working with the office objects, but a couple of questions.
1. Does the document open in a previous version of excel?
2. Are you referencing the office object related to the version office you're working with?
Posted 2 Apr 2014What have you tried already?
Googling the error code gives a raft of information related to this error and VB6 (and in a lot of cases solutions - Including a hotfix for MAPI), so it would be useful for people to understand what you have already tried.
Posted 31 Mar 2014How are you building your SQL statement?
What gets written into variables 2 and 3 if you only select something in list 1?
Do you actually have valid records if Field1 = Variable1 and Field2=Nothing and Field3=Nothing?
How do you want it to work? Should it only use the lists that have been clicked? If so, you need to be a little more dynamic with the building of your SQL statement.
Posted 28 Mar 2014Check out this linkfor starters
Posted 25 Mar 2014If I understand you correctly, you want to put something in a loop when you click one button and stop it when you click another?
If so, you need a way of escaping your loop, which you don't seem to have and also, it will appear to freeze, because your loop isn't relinquishing control to the system in anyway.
I'm not familiar with the webbrowser control, so I'll give a generic example.
Option Explicit Dim blnStop As Boolean Private Sub cmdStart_Click() ' Clear the stop flag blnStop = False ' Call our loop routine subStartLoop End Sub Private Sub cmdStop_Click() ' Indicate we want to stop the loop! blnStop = True End Sub Private Sub subStartLoop() Dim lngLoop As Long lngLoop = 1 ' Create our "infinite" loop Do While lngLoop = 1 And Not blnStop ' We commented out our loop increment, so it will never end 'lngLoop = lngLoop + 1 ' Add a DoEvents to give control to the system to process messages DoEvents Loop MsgBox "Loop Finished" End Sub
Hopefully that should point you in the right direction
- Member Title:
- D.I.C Lover
- 42 years old
- June 12, 1971
- Programming Languages:
- C#, VB
- Website URL: