Use of InStr() function

Visual Basic for Applications (VBA)

Index ‹ Microsoft ISV

- Previous
  - 1
    - Null Value Error in recordset I have encountered a problem when returning a record set which contains a Null value. Please can any one help I am trying to determine if a date field against a client is empty but if it is empty, when I try to get the value, I get an error message when it gets to dteDateCreated - "Invalid Use Of Null" Dim SQLText As String Dim rs As Recordset Dim strClientCode Dim dteDateCreated As String Dim strCode As String strClientCode = [Forms]![frmClient].[ClientCode] SQLText = "SELECT tblClient.ClientCode, tblClient.DateCreated " & vbCrLf & _ "FROM tblClient " & vbCrLf & _ "WHERE (tblClient.ClientCode) = " & strClientCode & ";" Set rs = CurrentDb.OpenRecordset(SQLText) strCode = rs.Fields("ClientCode").Value dteDateCreated = rs.Fields("DateCreated").Value It works OK if there is a date present. I am using Access 2000 on Windows XP. Tag: Use of InStr() function
  - 2
    - LCS 2005 SP1 Server-Side Contact Lists Not Populating within Communicator 2005 I am having trouble creating server-side contact lists for my employees using Communicator 2005. We have an LCS 2005 SP1 SE virtual test environment. All my users are LCS enabled (right-clicked on OU within AD to enable). Background knowledge... Contacts.txt looks like... msRTCSIP-PrimaryUserAddress sip:u ser1 @domain.local sip:u ser2 @domain.local sip:u ser3 @domain.local ACESFile looks like... all allow allow General I then run the following commands at the command line... CScript LCSAddContacts.wsf /userfile:contacts.txt / contactsfile:contacts.txt Then I run... CScript LCSAddaces.wsf /userfile:contacts.txt / contactsfile:acesfile.txt The command line displays the examples within the script, pauses for about 2 seconds, and then completes. However, when I have user1, user2, etc log into Communicator 2005 nothing changes... Please help, Keenan Tag: Use of InStr() function
  - 3
    - run an exe file in excel using VB Thank you Shasur, you really help a lot, cheers. Tag: Use of InStr() function
  - 4
    - Some questions about WER Hi Nikolai, When you map your files on winqual, the filename, Version, and LinkDate are used to pair up with WER reports sent by end-users. There are times when the linkdate is not picked up by the WER client in the signature of the report. When that happens, the Winuqal mapping is based on filename and version only. This happens mostly on pre-vista operating systems. When this happens, it is possible to have noisy reports for files with a common name and version. This is the case with your sample project. Kind Regards, -Jason Tag: Use of InStr() function
  - 5
    - public variable between sheet code and userform Hey, I created a public variable in sheet code and assigned a value to it. Now I want to be able to call a userform from the sheet code and use the value I established in the Userform code. Is there a way to do this Tag: Use of InStr() function
  - 6
    - Help Deploying VBA changes across hundreds of Word Temlates I have been asked to "clean up" existing Word templates that have VBA code in them. Basically what I need to do is to remove the old code that is currently in the ThisDocument class module of the template and replace it with the new code. I've exported the "good" code to a .bas file and I have worked out how to import it back into the Word Template but the only problem I have is that I am importing it as a new module and the original code for the template is stored in the ThisDocument module. I don't know how to either clear the ThisDocument module programmatically (using VBA) or how to replace the contents of it with the "good" code. There are hundreds and hundreds of these templates and I am looking for the quickest and easiest solution as I am only new to the whole VBA world. Any help greatly appreciated. Thanks in advance. SIobhan Tag: Use of InStr() function
  - 7
    - A question from a beginner... Thanks for the recommandation. Tag: Use of InStr() function
  - 8
    - About iexplorer 7 error. "The instruction at 0x66869bc7 referenced memory at 0x00000050 . The memory could not be read." I keep getting this message whenever I close the internet explorer 7. Can anyone help me out on this matter Tag: Use of InStr() function
  - 9
    - Excel Pivot Table Hi, I am populating the Excel Pivot table from the sql OLAP cubes . I am having 2 items in the Data Field list and I dragged and droped those two in the pivot table and every thing is working fine .But the problem is when i am selecting two rows and asking to group by right clicking the Data field , It is grouping the rows but it is showing only one column insted of two and the 2nd column is disappering and it is also disappering from the Data Field List and coming back when i say unGroup. I could able to figure out if it is a front end (Excel ) issue or it is a backend (OLAP) issue. Can any one help me on this and also let me know if I am missing any thing in setting the properties. Tag: Use of InStr() function
  - 10
    - VBA Word Can't find project or library Unfortunately the code example you posted works fine for me. I am not able to generate the error. Tag: Use of InStr() function
  - 11
    - Excel: Public variable doesn't work I have a routine that needs to sometimes display a form to get user input, then hand the result back to the caller. I use a Global variable to do this but the value is not returned. When I use Option Explicit, I get a run-time error, "Variable Not Defined" in the form. The code is like this: In the calling module... Code Snippet Public PsResult as String private sub ModuleA() PsResult = "" formB.show msgbox PsResult end sub Then, in the form's code Code Snippet PsResult = "derived value" Note that the form doesn't specify "Public PsResult as String". It shouldn't need to as it should already exist. What is important to note is that my calling code is within ThisWorkbook (because it's replacing the standard Excel Workbook_BeforeSave function). If I copy a bit of it to a new Module then it works perfectly. So why can't my form see a Public variable defined in ThisWorkbook Jeff. Tag: Use of InStr() function
  - 12
    - Inserting Comments in Excel...from a Beginner I managed to get your error by selecting a range containing numerical values, which I assume is what you were doing. I guess by passing a numerical value into the String argument of the AddComment method, it wasn't liking it. I have amended the code to explicitly convert a cell's value to a string as it passes it to the AddComment method. I've also added code that deals with Cancel button being clicked on the input box, just to make it more complete. Give it a try. Code Snippet Sub AddComments() Dim dataRange As Range Dim cell As Range 'Prompt user to define range containing values in Sheet2 and set dataRange accordingly On Error Resume Next Set dataRange = Application.InputBox("Select range containing the values to convert into comments", Type:=8) On Error GoTo 0 If dataRange Is Nothing Then Exit Sub 'Loop through each cell in the specified range, ignoring blank cells For Each cell In dataRange.SpecialCells(xlCellTypeConstants).Cells 'Add a cell comment in the corresponding cell in Sheet1 Sheets(1).Range(cell.Address).AddComment (CStr(cell.Value)) Next Sheets(1).Select End Sub Tag: Use of InStr() function
  - 13
    - Time Addition Hi all, I am facing such a horrible problem, i have tried everything and cannot find a way to solve it and it is now driving me insane. What i am trying to do is to calculate the amount of hours a member of staff has worked for the whole week, this is done through VBA on a userform and i just cannot do it. the main problem i am facing is how to add hour and minutes together to give me a value in format HH:MM see code below Code Snippet Dim BreakLength As Date Dim TotalHours As Date 'Dim for Sunday Dim TimeAstart As Date Dim TimeAend As Date Dim TimeAelapsed As Date Dim Day1 As Date 'Dim for Monday Dim TimeBstart As Date Dim TimeBend As Date Dim TimeBelapsed As Date Dim Day2 As Date 'Dim for Tuesday Dim TimeCstart As Date Dim TimeCend As Date Dim TimeCelapsed As Date Dim Day3 As Date 'Dim for Wednesday Dim TimeDstart As Date Dim TimeDend As Date Dim TimeDelapsed As Date Dim Day4 As Date 'Dim for Thursday Dim TimeEstart As Date Dim TimeEend As Date Dim TimeEelapsed As Date Dim Day5 As Date Dim TimeFstart As Date Dim TimeFend As Date Dim TimeFelapsed As Date Dim Day6 As Date 'Dim for Saturday Dim TimeGstart As Date Dim TimeGend As Date Dim TimeGelapsed As Date Dim Day7 As Date BreakLength = "00:30:00" '------------------------------------------------------ 'this section is repeated seven time all together 'once for each day of the week 'label8 for sunday, label9 for monday and so on 'TimeAxxxxx for sunday, TimeBxxxxx for monday and so on If Label8.Caption = "--:--" Or Label8.Caption = "" Or Label8.Caption = "00:00" Then Day1 = 0 Else TimeAstart = ComboBox1.Text TimeAend = ComboBox2.Text TimeAelapsed = TimeAend - TimeAstart + IIf(TimeAend > TimeAstart, 0, 10) If TimeAelapsed >= "07:00" Then Day1 = TimeAelapsed - BreakLength Else Day1 = TimeAelapsed End If End If '----------------------------------------------------- 'Here is where all the problems start, to TotalTime = Day1 + Day2 + Day3 + Day4 + Day5 + Day6 + Day7 Label15.Caption = Int(CDbl(TotalTime * 24)) & Format(TotalTime, ":nn") if my shift goes over midnight then the number of hours is in 3 digits e.g if my shift is 21:45 to 06:00 then label15 shows 223:45 instead of 7:45 (note that is should be 8:15 but the break time is deducted) but label8 will show me 7:45 So the main solution i am looking for is how to add time together. I am now desperate for a solution to this, so if anyone does have a solution please help me Thanks in advance Tag: Use of InStr() function
  - 14
    - Excel/Word VBA IDE - Additional Controls Dialog Box refuses to display I have a problem trying to add additional controls to the Controls toolbox The two methods I've tried 1. Right click on the controls toolbox , click Additional controls 2. Menu, Tools, Additional controls Neither of the above produce a dialog box containing the list of additional controls to choose from. Things I have tried so far.... Office Update, Reinstalling Office 2000, uninstalling Office 2000 and installing Office XP (2002) Please help any ideas Tag: Use of InStr() function
  - 15
    - Excel Time Help thank you all for your replies but i wasnt successful with the datediff in vba and the other formula provided wasnt doing what i required. Althought i have found a formula that works and does what i want it to do =IF(MOD(A2+1/12,1)<1/3,MIN(1/3,MOD(B2+1/12,1))-MOD(A2+1/12,1),IF(MOD(B2+1/1,1)<A2,MIN(MOD(B2+1/12,1),1/3),0)) the problem with this one though is that the moght shift will start at 22:00:00, not at 23:00:00 which is what i need. what should i do to change the time to 23:00:00 any suggestions thanks Tag: Use of InStr() function
  - 16
    - Excel import I have a working Excel vba that imports about 50,000 cell values from a variety of different text files into numerous worksheets. The problem is it is painfully slow, taking over an hour to run. The main time killer is populating each individual cell using the format: Worksheet.Cells(row,col).Value = strValue Commenting out these lines of code the program runs in under a minute. I've been searching for other alternatives but nothing I've found executes any faster. Ideally I would like to populate one row at a time using a delimited string, or string array. Other options I've considered but haven't done yet are creating a .csv file for each sheet then importing that, or using ADO from an external program. I'm looking for any suggestions on how to speed up this application. Thanks. Rod Wing Tag: Use of InStr() function
- Next
  - 1
    - iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :( I had the same problem. I had recently installed Norton 360 and I use IE7 so I imagined the problem was something to do with a conflict between the two programs. However for me (and I can only speak for myself) it turned out to be a newly installed Add-on from my new ISP which was causing the problem. I went into Control Panel - Internet Options - Programs - Manage Add-ons and disabled the new add-on and the problem went away immediately! I would imagine the same thing is causing the problem for you too. I recommend you go into the above menus and try and spot anything that looks new, something which relates to a new program you may have installed, and try disabling it. For me it was a toolbar (which I didn't want or even ask to be installed) from my new broadband ISP but I guess it could be anything. You might have to do some experimenting before you find the right one; if you're not sure which is the offending program I��d try them one at a time. Disable the add-on, close IE and open it again then close IE again and see if the problem has gone away. If it hasn't then it's fair to say the add-on you just disabled wasn��t to blame so you can then go back in, enable the add-on and then try the next one! Laborious but it should work.....assuming it's just one add-on that's causing the problem that is!! Anyway have a go and see how you get on. If you find it you'll need to do the same thing with any other user profiles set up on your machine as these will still have the offending program enabled. Don't bother trying to reinstall IE7 as your add-on settings will probably just reappear when you reinstall IE7 again anyway. I��d be interested to know if this works for you. Good luck. Tag: Use of InStr() function
  - 2
    - Importing excel spreadsheets over time into Access using a module in Access Hi, I am trying to create an access database that will allow to import excel spreadsheets at the click of the button on a switchboard. I have been trying for hours to create a module in access that will import excel spreadsheets that contains a table with 12 columns and a different amount of rows for each spreadsheet. I was able to create an almost complete macro in excel that I copied over to an access module (i was unable to create a Do while that will format the excel file by cutting out the first 8 rows and take out all columns except for 6 of them that i need for importing. It should delete rows below once it finds a row with "Elimination Totals" (Column C) or delete rows belowonce it reaches a blank cell in Column A. The Functionality of Database that I am trying to create can be described as: Functionality: Import Spreadsheet (6 fields/columns) into Access Table with 8 fields(Year & Quarter fields will be entered in by user) Use macro or module to format the imported file a) auto expand all columns and rows b) Delete first 8 rows of spreadsheet c) (only import columns A, B, C, D, I, & L) delete all of the rest of the columns d) Read Column B data (truncate or delete the first character in the cell) ex 6050 should be 050; G123 should be 123: keep the remaining three characters in the table. e) Import the table until Column A reaches a blank value �� (maybe a do while function��.not sure how these work ) or until Column C = ��Elimination Totals�� Everything on the Elimination Totals line and below should be deleted and not brought into the table in Access. f) Row 1 & 2 values should be combined to make one row. Example: Row 1 Column A = Cost; Row 2 Column A = Center; Combine the two and you get one Row = Cost Center. Delete the extra row The import should be initiated by clicking ��Upload Spreadsheet�� on the Switchboard (I believe I just need to refer to the function name of the import module to accomplish this) a) When the ��Upload Spreadsheet�� button is clicked on the Switchboard, a query should be initiated that requires the user to input the Year value ex: ��2007�� and Quarter value ex: ��1��. These fields as well as the imported fields should be linked to a table. The table should be pulled by a form preferably a Pivottable sorted by Fiscal Year and Quarter that allows user to change the Agreement Description field(Column C from above) and RA Number (Column L from spreadsheet before formatting) but the other 4 fields should show all and not be able to get modified at all. Data in the Pivottable will be the Agreement Amount value (Column D from above) b) Another Pivottable will be needed to be sorted by Component (Column I from spreadsheet before formatting). Only the Components should be accessible to change for sorting options here; the rest of the fields should display all and be locked from editing. Data in this Pivottable should also be from the Agreement Amount field/column(Column D from above). The macro that i used is as follows: Sub ProviderListMacro() ' ProviderListMacro Macro - Formatting Range("E9 20").Select Selection.EntireColumn.Delete Range("I8 42").Select Selection.EntireColumn.Delete ActiveWindow.SmallScroll Down:=21 ActiveWindow.ScrollColumn = 2 ActiveWindow.ScrollColumn = 1 ActiveWindow.SmallScroll Down:=-45 Rows("1:8").Select Selection.Delete Shift:=xlUp Range("A1").Select ActiveCell.FormulaR1C1 = "Cost Center" Range("B1").Select ActiveCell.FormulaR1C1 = "Agreement Number" Range("C1").Select ActiveCell.FormulaR1C1 = "Agreement Description" With ActiveCell.Characters(Start:=1, Length:=21).Font .Name = "Arial" .FontStyle = "Regular" .Size = 10 .Strikethrough = False .Superscript = False .Subscript = False .OutlineFont = False .Shadow = False .Underline = xlUnderlineStyleNone .ColorIndex = xlAutomatic End With Range("D1").Select ActiveCell.FormulaR1C1 = "Agreement Amount" Range("E1").Select ActiveCell.FormulaR1C1 = "Organization" Range("F6").Select Selection.EntireColumn.Delete Range("F5").Select Selection.EntireColumn.Delete Range("F1").Select ActiveCell.FormulaR1C1 = "RA Number" Rows("2:2").Select Selection.Delete Shift:=xlUp Cells.Select Cells.EntireColumn.AutoFit Cells.EntireRow.AutoFit Range("B10").Select ActiveWindow.SmallScroll Down:=-9 End Sub Can someone please assist me on successfully giving the user the ability to import an excel spreadsheet (has the same required information) by creating a module that will import the file and fix the formatting, then save the information to a table and display it on a Form The form should have two extra fields - Year(2007) and Quarter (ex: 1,2,3,4), which i can/will add to the table. Any input will be helpful thanks, ultsun1 Tag: Use of InStr() function
  - 3
    - Dynamically add controls with events at runtime Cool, bookmark this thread. I was having the same problem. I ended up creating tons of the same buttons and keep copy and paste the same even handler. Although this still can be tricky when I run out of space for the buttons, but it already took care of the main problem. Thanks. Tag: Use of InStr() function
  - 4
    - run an exe file in excel using VB Thank you Shasur, you really help a lot, cheers. Tag: Use of InStr() function
  - 5
    - autofill vba code I need to copy a function down a column to length of the adjoining column to the left. I recorded a macro which did what I wanted. Unfortunately, the column changes sizes depending on my data. Unfortunately, every time I run the macro it uses the length that was recorded the first time. How can I set up a dim or something to have the autofill work with the variable length lists Thank you very much for any help nsheff1@hotmail.com Tag: Use of InStr() function
  - 6
    - Need to link two word documents together. Hi, I have two documents which have roughly similar tables that need to be filled in Microsoft Word. I would like to have a macro that updates a cell in a 5-by-5 table in B.doc when a cell in a 5-by-5 table in A.doc is updated. 1) A.doc is updated. 2) B.doc is opened, then updated. 3) Both documents save themselves. It would be best if steps 1-3 are completed with a click of the button. Thank you! Tag: Use of InStr() function
  - 7
    - VBA - Accessing files in a folder Evening Ppl, I am working on a Excel VBA assignment which involves accessing a directory which has around 2500 files and displaying the filename, date created & date modified based on a search criteria. To be more clear, i have well formed file names in that folder and the last 4 characters in the file name are DDMM (date and month) TEST0806.csv TEST0803.csv TEST0802.csv TEST0801.csv ANSWER0806.csv ANSWER0803.csv ANSWER0802.csv ANSWER0801.csv I would have files for two weeks in this folder. My program should fetch the files for today and yesterday from this folder, for the specified "TYPE", meaning TEST, ANSWER etc., I have tried using the FSO method, it works but it is very slow. I tried using DIR() method, even this works but it does not give me the date created or date modified values. Can any of the experts in this forum suggest me a faster solution to this problem Thanks Raja Tag: Use of InStr() function
  - 8
    - iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :( I had the same problem. I had recently installed Norton 360 and I use IE7 so I imagined the problem was something to do with a conflict between the two programs. However for me (and I can only speak for myself) it turned out to be a newly installed Add-on from my new ISP which was causing the problem. I went into Control Panel - Internet Options - Programs - Manage Add-ons and disabled the new add-on and the problem went away immediately! I would imagine the same thing is causing the problem for you too. I recommend you go into the above menus and try and spot anything that looks new, something which relates to a new program you may have installed, and try disabling it. For me it was a toolbar (which I didn't want or even ask to be installed) from my new broadband ISP but I guess it could be anything. You might have to do some experimenting before you find the right one; if you're not sure which is the offending program I��d try them one at a time. Disable the add-on, close IE and open it again then close IE again and see if the problem has gone away. If it hasn't then it's fair to say the add-on you just disabled wasn��t to blame so you can then go back in, enable the add-on and then try the next one! Laborious but it should work.....assuming it's just one add-on that's causing the problem that is!! Anyway have a go and see how you get on. If you find it you'll need to do the same thing with any other user profiles set up on your machine as these will still have the offending program enabled. Don't bother trying to reinstall IE7 as your add-on settings will probably just reappear when you reinstall IE7 again anyway. I��d be interested to know if this works for you. Good luck. Tag: Use of InStr() function
  - 9
    - Parse AIM Buddy List Export file and Import to LCS 2005 Client I'm working on a migration project from the wide use of AOL AIM to Office Communicator 2005 and Live Communication Server 2005. I can create a text file export like the following: Config { version 1 } User { screenName thereScreenName } Buddy { list { "GroupA" { "buddy1" "buddy2" } "GroupB" { "buddy3" "buddy4" } } } There could be any number of groups. I will provide variable inputs for the input file and output file locations. I need to be able to make a new file like: buddy1 sip:buddy1@aol.com buddy2 sip:buddy2@aol.com buddy3 sip:buddy3@aol.com buddy4 sip:buddy4@aol.com I am completely a newbie in C#, but I was requested to use it. Any assistance would be great. I will request that the resulting tool be open source and publicly available, so please keep that in mind. Tag: Use of InStr() function
  - 10
    - VBA Powerpoint - identifying textboxes by type Hi everyone, I'm writing an add-in for Powerpoint 2003. I'd like to know how I can identify textboxes by type if such a thing exists. For example, when reading a TextFrame, how do I know if I'm reading the title textbox, the subtitle, or a the big textbox with bulleted points depending on the slide model I've found the Shapes.Title property, but that only gives me the title if it exists, not the value of the subtitle or the default big textbox with bulleted points that you find on a default slide. Is there some property somewhere that I'm missing Thanks a lot, Pete Tag: Use of InStr() function
  - 11
    - Issue with Selection.TypeText and Chinese Characters. Hello Everyone, I'm having trouble getting chinese characters to work with TypeText. When I use English, everything works great. For example, the following statement shows up as " " in my word document. exec sp_OAMethod @objword, 'Selection.TypeText("��y")' While I'm using T-SQL and not VBA, I figured that the people here would probably know the answer. I've been finding VBA documentation or recording word macros and translating it to work with T-SQL as there is hardly anything on intergrating Word and SQL Server. So, my appologies in advance if this is the wrong forum. If anyone knows the answer or could point me in the right direction, it'd be greatly appreciated. Thanks! Tag: Use of InStr() function
  - 12
    - Automatically send attachment in email with a submit command button in word I have a huge problem if anyone out there is able to help; I have tried to create a submit command button to email off a document as soon as the user hits submit; however i am new to this and my macro does not seem to be working. Does anyone know where i have gone wrong and if possible can you please help rectify the problem. Thank you Sub CommandButton1_Click() Dim Email As Object Dim Attachment As String Set Email = CreateObject("Outlook.Application") 'Assign Outlook application to variable With Email.CreateItem(olMailItem) .to = "<>" 'email address .Subject = "Incident Report" 'Something for the subject Field .body = ActiveDocument .Display = Attachment Options.SendMailAttach = True End With Tag: Use of InStr() function
  - 13
    - Wording of Response web pages is different to specified text Hello, I'm working on a prototype application using Windows Error Reporting, and right now I'm trialling Responses. I'm trying to understand why the wording on the web page I see (after submitting an error report for an event that I've registered a Response for) is completely different from the wording I've specified on the Winqual website's Response Management page. Two examples: 1a) My registered response #948 for event #64109781 in Winqual's Response Management page: Product(s): WERDemo 1.0.0.0 URL to Solution/Info: http://www.qsrinternational.com Response Template: Working On A Fix Response Template Text: ##CompanyName## working on a fix Thank you for submitting an error report. Problem description The error was likely caused by: ##ProductName## More information ##ProductName## was created by ##CompanyName##. ##CompanyName## is aware of the problem and working on a fix. To learn more, see the ##CompanyName## website. ##ResponseURL## 1b) What I see on the Windows Error Reporting web page after submitting an error report for this event: http://wer.microsoft.com/responses/Response.aspx/7412/en-au/5.1.2600.2.00010100.2.0 SGD=e65d413f-fb6a-43c9-9310-018a1921e3ce Problem caused by WER Demo This problem was caused by WER Demo. WER Demo was created by QSR International. QSR International is aware of this problem and working as quickly as possible to make a solution available. Recommendation -------------------------------------------------------------------------------- To learn more about this problem, QSR International recommends that you go online to the following website. QSR International 2a) My registered response #997 for event #64109918 in Winqual's Response Management page: Product(s): WERDemo URL to Solution/Info: http://www.qsrinternational.com/products_nvivo_service-packs.aspx Response Template: Custom Template Additional Info: Thank you for reporting this error to QSR International. A fix for this error is available in WER Demo 1.0 Service Pack 1. To download this service pack, please follow the link above. 2b) What I see on the Windows Error Reporting web page after submitting an error report for this event: http://wer.microsoft.com/responses/Response.aspx/7813/en-au/5.1.2600.2.00010100.2.0 SGD=d12dd974-7324-4266-9560-863419e3743e Download updates for WER Demo This problem was caused by WER Demo. WER Demo was created by QSR International. Solution -------------------------------------------------------------------------------- A newer version of WER Demo is available for download that will address this problem. QSR International recommends updating to the latest version of WER Demo to take advantage of security and stability improvements. Go to the QSR International website and install the latest version of WER Demo: QSR International --- A related question: I see Winqual is attempting to localize the text displayed on these response web pages (e.g. replace the culture "en-au" with "de-de" in the URLs above, and the text is shown in German). How does this work, and what is supposed to be displayed on the response web page for different cultures if I've specified a Custom Template with custom text on the Response Management pages Is there any way to force the page to be displayed in English Regards, Marcus Ogden QSR International www.qsrinternational.com Tag: Use of InStr() function
  - 14
    - Why is it so ? Hi, I uploaded a product map file recently, and one of the exe was having version 7.31.0.0 But, when I go to the Product Rollup page, I can see an event for that exe having version 7.20.0.0 . As I understand, mapping process considers the version of that file also. Can anybody explain why 7.20.0.0 is listed instead of 7.31.0.0. In other words how come version 7.20.0.0 event were mapped for 7.31.0.0 mapped file Also the reported events were not sent from my side. Actually this product is used by many users across different timezone and once I uploded the map file, thses events also started showing up. Regards, Dhon Tag: Use of InStr() function
  - 15
    - Is Microsoft the company broken? I've been developing on Microsoft platforms for many many many years (early 80's). I've been forced to start developing on OSX and other flavors of *nix primarily due to: 1. Increasing demand by my clients to produce higher level service agreement 2. VS 2005 even with SP1 can't deliver the goods on large scale 24/7 mission critical apps 3. The need to still use Java in ASP.NET based web solutions 4. Microsoft's SP/Fixes take too long to (6-18 months is not acceptable) Unfortunately I find myself having to agree with my client's position and the many clients I've lost because of the platform (.NET) I use. But what it ultimately boils down to is this: 90% R&D and 10% coding I'm spending way too much time working around the problems associated with Microsoft development at all levels from OS to IIS to .NET. It's a platform of too many compromises, too many bugs, and is just not secure (at least in my Client's eyes which is all that matters). I have 5 new clients lined up and NONE of them are considering Vista at all and for my large corporate clients, Vista's hardware requirements have excluded it from being a viable large scale deployment. Why this post so late in the game Perhaps my last attempt to send the signal and hope someone at Microsoft isn't there just to collect a check, that someone at Microsoft does indeed see the problem, someone at Microsoft sits back and looks at the company as a whole and discovers the problem -- at the very least they should question why "Zune" even exists when there are serious issues/problems with their bread and butter (dev tools and OS and server tools). Rob. Tag: Use of InStr() function
  - 16
    - Debugging I can watch the execution flow of code in VBA under MS Word 2002 using the F8 key. How do I take a step backwards I want to watch a small section of execution flow again without starting from the beginning. Tag: Use of InStr() function

une

Can you use InStr() to determine the position of the next character in a string that is not equal to one of a number of options. If so, how

For example, what would be the syntax of an expression that returned the position of the next character that was not either a "t", space, tab or return character Would you have to use ascii representations of some or all of these characters in the exepression

Top

Re: Use of InStr() function

Wildert

Sounds like you'd have to loop through each character in the string and examine if that char is what you want, and if it is, exit the loop.

Top

Re: Use of InStr() function

une

Thanks, but I was thinking that a single InStr() statement could do it, I just am not sure of how to arrange the arguments within the function call.

Top

Re: Use of InStr() function

Andy Pope

Hi,

The Instr function is designed to find characters/text. So search for text that is not there will not work.

Looping through the characters is the normal way of doing it.

Another possible approach is to use Regular Expressions. I'm not really clued up on there use but a bit of googling should provide more help.

Top