Search results for query: *

Simplified scenario: Table t1 type_cd category_cd (need to populate this column) abc def ghi jkl mno pqr stu vwx Table t2 tbl_id type_cd cat_cd 001 abc COL 002 def STA 003 ghi JDG 004 jkl SAC 005 mno...

Using: Microsoft Biztalk Server 2004 Microsoft Visual Studio .NET 2003 Does anybody know how to do a keyword search (or search for a phrase) in an orchestration view? I know that you can do "find in files" (that binoculars icon on the Visual Studio toolbar), but that will only show you the...

I have a directory of files - some of them with the naming convention *.input What I would like to do is run the following command-line global replace on all of these *.input files: For files *.input, replace the 15th to the last character of lines 2 and 3 with 'mystring' If its any easier...

I know that you can use Ctrl-% to match the brackets or parenthesis in a perl script from with the vi editor. I was wondering if there is also some trick to locate the definition or "origination" of a selected variable in a script. Does anyone know if this is possible? [hammer]

Hey, I was wondering if anyone can come up with a macro for the following problem: I have a spreadsheet with 2 textboxes on it. So a user can enter data within these textboxes as well as enter data in cells on the sheet. Some users have asked to make it possible to tab out of a textbox after...

I have an Excel worksheet which contains merged cells that users can paste various data into. I know that the user can press the F2 function key before pasting, or just click in the formula bar first - but the users don't always know that, and as a result, the following error happens: "Data on...

Hey, if anyone can help, I'm trying to come up with a macro for MS Word (Office XP version) that will replace every other instance of a string in a document, and then replace the remaining instances of that string with a different value. Specifically, I have a document that is * delimited. I...

I have a procedure to extract the initials from the name in a cell, and then assign the initials to a named range in the workbook. Originally I had the range as a hidden cell, so for my last line in this procedure, I just had: Worksheets("Fix Checklist").Range("initials") =...

Anyone ever have this problem: You open an Excel document, and right after it opens, it tries to open again, with the following message: <filename> is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen <filename>? This only happens to me when...

I have a range of cells that are merged named &quot;descr&quot;: ($B$2:$K$2). I had a problem (which I fixed) in which you can't pasted certain data to the merged range of cells. The following error messages would pop up when trying to paste: &quot;Data on clipboard is not the same size and...

Is there a way in Excel to make Data Validation dropdowns actually dropdown on the first click? You know, as it currently works, you have to click on the cell with the data validation to select it. Then you have to click on it again to make the dropdown expand. Is there some kind of VB code...