Answer Questions
PaulYuk_MS VBA code to search and modify in Word
I am very new to VBA for word. Please excuse. I am trying to search for text that meets a the following criteria. The "#" reps any number, "T" reps any Letter. "TRACKING NUMBER: #TTT############## " The idea is to find all "tracking number"'s that meeds the text and number "format". I then need to modify the number by modifying the letters and adding two numbers. The result is below. All track numbers need to be modified. "TRACKING NUMBER: #TTT##############-## " You help with this is greatly appreciated. Rob The search is more of a format search. ex. ###AAAA#########. These represent wild cards for text and ...Show All
Babu Annamalai Internet Explorer Error and shut down duing print an a secure site
Is it just me, or have others had this problem I had the final release of Internet Explorer 7. I have removed it. During two attempts two print a shipping label at a secure Paypal site, Internet Explorer 7 quit when I clicked on "Pay and Continue." It displayed: "Intnernet Explorer 7 has cause an error and will close...," message on the screen and then the Error Reporting kicked in. IE 7 has done the same thing other times as well. I have Java 5 Update 9 and the latest flash. I uninstalled IE 7 and now running IE 6 for XP SP2. I have not tried to print from a secure site as before where there has to be a popup to start the printing. Popup blocker is turned off turned off. Goggle tool bar is disabl ...Show All
tkrasinger Worksheet.Copy causes execution to stop
Hi I am experiencing an odd behaviour from my VBA code in Excel. I have some code that has worked until recently. We have gotten XP instead of win2k, which i could suspect is causing this in some strange way. My problem is that i have the code below. In the line where i say Worksheet.Copy, the execution simply stops. No errors appears, nothing. <CODE> On Error GoTo ERROR: Worksheets(SN_MonthYearAct).Copy After:=Worksheets(Worksheet.Count) .... ERROR: MsgBox(Err.Description) </CODE> The variable SN_MonthYearAct is a constant containing the string "MonthYear Act", and a sheet with this name does exist. Worksheet.Count returns currently 8, and there are 8 sheets in the workbook. I have trie ...Show All
niallhannon Databases comparison
Hi, i have a big database where i store a lot of data. in order to make sure that there are no mistakes in the data (usually becasue of typing mistakes) i type the same data to 2 different folders. no i have 2 files that supposed to be equal. how can i compare the 2 database to ensure that they contain the same data is there any build-in function that compare 2 databases i want all the mismatches to be stored in a table: Table, Field Name, First Value, Second Value ...Show All
Alex Vournas variable declarations
Hi, this is kind of a basic and maybe a silly question, but also hopefully a simple one. in a few code snippets i have seen online, i have seen dim declarations made with variable names followed by ampersand or percent sign...such as dim Dim LastRow&, LastCol% what do these signs mean do they specify some kind of characteristic for the variable thank you, kriti I found one list on this page , there are probably better references around. Remember that this kind of declaring your variables is considered obsolete and should be avoided. Andrej thanks! makes sense. are there other such "shortcut" type declarations as well or anywhere i could find a list ...Show All
Derek Comingore Problems with last 2 parts of code?
Hi Just testing my almost completed project and have come across two pieces of code that are proving a pain in the butt for me! I wonder if a fresh set of eyes may pick up on something i'm missing... Basically I have to run the macro a number of times before it properly removes all the rows of data I want it to - any ideas Sub cmdRemoveEntries_Click() 'used to automate the removal of exceptions such as Russia, Ukraine Dim x, z As Integer Dim cell As String z = Module1.GlobalCount 'total number of employees to be processed For x = 2 To z cell = "O" & x 'O signifies the Site in which the employee is based 'feel free to add other countries/sites as they become applicable 'MS/NN/WT ...Show All
Tryst Count and display in cell
Ok I have an Excel workbook that contains a schedule (51 worksheets total). Each cell has intials in it and if that person has taken a day off the cell is highlighted a certain color (yellow, rose, or red). What I need to do is have something that goes through and counts what intials have what color and then display in a cell the number. So: If cell contains "initials" and cell color is "color" Then count and display in "cell" Example: If cell contains "JJ" and cell color is "Yellow" Then count and display in "A2" I know it is possible to do this but I'm not sure how. Tiger Hello, Try the following code: You could ...Show All
Luo Cao WebPart Problem (?) / BSM2005
Hy. We have a Win2k3-Server (SP1) with SQL2k5, IIS6, Sharepoint Services 2. To tryout the features i've installed the BSM2005-Demo. Fortunately there where no problems during the installation, but after deploying a scorecard i get the following error: can you please let us know how you solved the problem.... Regards never mind, solved it myself -_- Hi, I have the same problem. Could you please tell me how did you resolve the issue Many thanks, Andrej hi, can you tell me please how did you solved it ... i'm having the same problem. thanks Tatiana. ...Show All
PatriotB CRM 3.0 Outlook Client
I have a question regarding the settings necessary for the CRM 3.0 Outlook client to be installed. I have the CRM and Exchange on seperate servers & networks, both running SBS 2003. I have the CRM server setup as localhost in my office, and Exchange is hosted off-site. Whenever I open outlook I am getting errors saying: "Your Web browser options are currently set to disable cookies. Microsoft CRM requires cookies to use the Web client. To enable cookies, see the online Help for your browser" "An error occurred loading Microsoft CRM functionality. Try restarting Microsoft Outlook. Contact your system administrator if errors persist." I have allowed all cookies in IE 7, and still get the first error. When I i ...Show All
Wayne Pfeffer datagrid control in access
hello, i am developing an access application using forms and i don't have the datagrid control. i tried downloading msdtagrd.ocx and install it but the control doesn't seem to be working properly. is there a control i can use that has a menual on how exactly i use it (either in the code and on the form). thanks refael why isn't there any simple DataGridView control i can use does it have to be so complicated do you know of a tutorial i can use the thing is i want it to br UnBound. i want to insert or remove items from the code is it possible If you want to create a datagrid control similar to .NET then create a form that contains the bound fields you want in the datagrid, then you need to set the ...Show All
Paul_G Error hanlder that does not end macro
I have an error handler that I use extensively. However most of the times I just want to be able to inform the user of the error and then move on. Sometime I save info on errors too. However they way that my error handler works now is that it terminates the program when an error is being detected. Please help me modify it so that it “tolerates” mistakes and just warns the user of the error. My code is: Public Sub mainProgram() ….. On Error GoTo Handler Exit Sub Handler: Select Case Err.Number Case 600 Msgbox(“Error type 102”) Case 601 Msgbox(“fatal error!) ……… Case Else End Select End Sub And ...Show All
Riekey Word: How to you determine the current cursor position
For one of my macros to run, I have to ensure that the cursor position is not in a table or in a frame when the user activates the macro. How can I find our the current cursor position Once I can determine that the cursor is positioned in a table or a frame, I can then code a message box to instruct the user where to put their cursor to run a certain routine. Thanks for that! Will try it straight away! Hi, Cursor position Selection.Range.End This will check whether currently in a table or frame. Dim lngTableCount As Long Dim lngFrameCount As Long For lngTableCount = 1 To ActiveDocument.Tables.Count If Selection.Range.InRange(ActiveDocument.Tables(lngTable ...Show All
Shawn Wildermuth - MVP &#40;C&#35;&#41; Saving information in a form
Hope someone can help! i have created a form in access where the user needs to input some information. What I want to do is be able to save this information on the form so that the next time I open the form the information is displayed, and also have the ability to change any field and save the changes. I also want to be able to save the information in an access table. Thanks a lot, I really appreciate any feedback/suggestions. HMariana Hi, I wrote a blog entry about how to do this http://dsmyth.blogspot.com/2006/05/saving-user-interface-state.html Generally what you want to do is create a class that contains all the data entered/displayed on the form. Add two properties to the ...Show All
Mikx where do I start??
Good evening. Here is the thing. I am using a Mass spectrometer, which exports data into excel worksheet. What I want to do now, is to process this data while it being exported into the worksheet, i.e: taking avrage value every (let's say) 5 values that being exported, or every once in a time interval, and save it somewhere else (a different worksheet for example). Now, since I don't know how to program VBA, I don't even know if that's possible, and that's my first question. Is that possible My second question, is only relevant if the answer to the first is 'yes', where do I start Thank you for the attention!! Eyal Thanks a lot! If you have the ability to export information from the spectrometer into f ...Show All
XNA Rockstar ExecuteCommand and PrintOutput procedures
I am trying to run some sample codes downloaded from MSDN website regarding Command Object. The sample codes consist of the 2 Stored Proc below, where can I download the 2 stored procs ExecuteCommand PrintOutput The sample code can be found here http://msdn2.microsoft.com/en-us/library/ms681504.aspx Thanks. Daniel ...Show All