Good Afternoon,

I have uploaded two text files called as follows

Audit_HV_Type.txt

AuditPlot_HV_Type.txt

The main file is called 'Audit_HV_Type' it has a value under the heading Order Number: - the values are like this as example HV_000035_106116

In the other file it is called 'AuditPlot_HV_Type', in this file it contains two key values, 'Order Number' & 'Description'

I want to able to create a process that takes the 'Order Number' taken from file 'AuditPlot_HV_Type' and searches for value in the flle 'Audit_HV_Type' when it finds a match, I would like to append the description value at the end of the order Number. When it finds no match, ignore the line.

Example

File AuditPlot_HV_Type.txt

"HV_000035_1061168","Plot 17 kicker lift "

Searches for 'Order Number' 'HV_000035_1061168' in the file Audit_HV_Type.txt

When it finds a match append the description at the end of the order number

"20 July 2018 01:51 PM","User1","User2 ","HV_000035_1061168_Plot 17 kicker lift","admin@somewhere.com ","Contractor1"

It sounds simple - I hope you understand

I installed UFT 14.03. Problem is that it is not recognizing some objects when I record and play .

Hi, Experts, I'm trying to get an item within the array where I use the first word of the item as its reference. I found a code from asp tutorial that may lead to solve the problem but I'm still not able to solve it. Hoping you (Experts) help me solving this problem. This is my array; fruits = Array("100 Banana","200 Apple","300 Orange") I want to get the orange using 300 as its refrence. I have the code below but I don't know how to make it right. Thank you!

<%
DIM findThis
findThis = "300"
fruits = Array("100 Banana","200 Apple","300 Orange")

If in_array(findThis, fruits, false) Then 
  Response.Write Orange & " is in the array"
Else 
  'Response.Write findThis & " is not in the array"
End If

%>

<%
Function in_array(element, arr, performTrim)
  Dim i
  in_array = False
  For i=0 To Ubound(arr)
    If performTrim Then '//there are some scenarios where you want to trim
      If Trim(arr(i)) = Trim(element) Then
        in_array = True
        Exit Function      
      End If
    Else '//and other scenarios where you don't
      If arr(i) = element Then
        in_array = True
        Exit Function      
     End If
    End If     
  Next
End Function
%>

Select all Open in new window

I would like to use HttpWebRequest and HttpWebResponse with ASP.NET VB.

This gives me an error:

<%

Imports System.Net

Dim myReq As HttpWebRequest
Dim myResp As HttpWebResponse

%>

Select all Open in new window

How can I properly import System.Net?

Hello to all of you.

I would like your help on a macro on excel

For the attached file, I want a macro that does :

1) it compares all the cells in B column with the number that I have in cell  I1. This number will be 6 in some cases, 5 in others, 7 etc ...

2) when it finds a cell in B column that has a number equal or greater than the cell in I1 (6 in this case), to copy the deg of that cell
in H column of the newSheet8.

for that case of 6, the H column of newSheet8 would have the degs:
3
20
26
33
56
etc


Any help?

Hi guys

I'm completely new to VLOOKUP tables and have been working on some tutorials. I have an Excel sheet that I have attached so that you can see what I am trying to do.

So basically, in worksheet 'User Details' I would like the column 'Organisation' (column C) to be filled in with the data in worksheet 'Mailbox Details' called 'Organisation A (also column )'. If you look at cell C8 in 'User Details', you will see 'contoso.com' which I have manually put in there.

Here's how I am trying to do it:

In the 'User Details' worksheet, the column A6 is the value I am looking up. As an example, my Lookup_value will be 'A8'.
The Table_array will be worksheet 'Mailbox Details' columns 'C5:D29'.
Col_index_num = 1 as that's the column I am trying to extract data from.
Range_Lookup = false

The issue I am seeing though is that in 'Mailbox Details' worksheet, in Column C there is a formula that has been dragged down and perhaps this is causing the issue?

If you're able to help me figure this out, that would be grand.

Thanks for helping
Yashy
ActiveDevicesUsageTracker-07-06-201.xlsx

Visual Studio Asp.net web using vb.  
I am trying to open a directory from my application.  It works perfect when  in debug mode but does not work when I publish to our intranet.  

    Protected Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
        Process.Start("explorer.exe", "c:\")


Any help would be appreciated.  The application is published on a 2008 r2 server running IIS

Need script to identify below files in startup folder on windows workstations

CHKDSK.vbs
Install.vbs
tvn.vbs
opera.browser.uninstall
webengine.dll.man

Dear Experts,

I'm looking for an excel macro to auto fill cells in Column B based on selected description from cells in column A. I tried using Vlookup but this is not completely successful.

Example:

Cell A1 - Hollywood/entries/Jan 2018 - result in column B1 should be - Hollywood
Cell A2 - Hwood/entries/Dec 2017 - result in column B2 should be - Hollywood
Cell A3 - Sales/Jan - Result in Column B3 should be - January

in above example, the source is not definite and specific information is sometimes expanded sometimes abbreviated, and this is just example, similar to Hollywood and Jan, the list is exhaustive.

Any help to crack this is highly appreciated.

I need to find a keyword in a word document title/name so that I can perform an if statement on the result

I have tried the following with a document that had the word "New" in it and this executed in the document open function:

    If ActiveDocument.Name = "New" Then
        MsgBox "New Found"
    Else
        MsgBox "New Not Found"
    End If

As you can guess...it didn't work out and that's why I am here!  :)

Problem:

We are trying to deploy a product with SCCM that requires a registry entry in HKEY_CURRENT_USER for the logged on user.   Yes - it is ridiculous that we can't install this product for "system" but oh well.  In SCCM I can set to ensure that the application only installs when the user is logged so there is that good news but...

From within a script, I need to find out who the currently logged on user is and then add a registry entry to that user's HKEY_CURRENT _USER.

Solution:

I'm half way there with a vbscript.  I was able to find the following script in another post which finds the currently logged on user.  The problem I'm having now is I'm not sure how to run "regedit /s "updateregentry.reg"" and put the entry in that user's hive.

Any help would be appreciated.  Below is the vbscript.

Option Explicit
Dim WSHShell, RegKey, Username
Set WSHShell = CreateObject("WScript.Shell")
RegKey = "HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Authentication\LogonUI\"
Username = WSHShell.RegRead(RegKey & "LastLoggedOnSAMUser")
Username = Mid(Username,7)
WScript.echo Username

Also - these are the registry entries I'm trying to add:

[HKEY_CURRENT_USER\Software\{08439167-4CA5-48E9-A810-A3A7C0B80B06}]

[HKEY_CURRENT_USER\Software\{08439167-4CA5-48E9-A810-A3A7C0B80B06}\Local]

[HKEY_CURRENT_USER\Software\{08439167-4CA5-48E9-A810-A3A7C0B80B06}\Local\CNS5T2Q540AHCQ6QU75GXH6DS1MCCCXFYF60W-102-292-280-A1]
"SiteMessage"="MyBusiness"
…

Hi Experts,
I am looking for a script that will read all files of a specific folder (.txt,.csv) and count how many records they're in total.
all files have fields header, however some files only contains the header and should not be count.
Thanks in advance.

Hello
I like to know more about excel sheet.
I have microsoft excel sheet with macro function and now i need to move this excel into google but by macro function not working on that.
Can you please help me to solve this ?