Posts by KalilMe

it just open my computer not open my file

may you explain me why I have to change directory despite of it's the same drive ?

here is the file

royUK nothing changes still I have to write the file without extension

royUK do me favor,please ? if it's possible add warning message when write extension then should show the message" please, write only file name"

the aim of this to overcome for this problem when write extension and the code doesn't work

thanks again

royUK actually your code works perfectly. my mistake is writing file extension . it shouldn't be when write the file name .

thanks so much for your solution

royUK thanks but nothing happens and no error

actually I did not see where is the location the file in range

hi experts

I face showing this error ' compile error' in word open in this line

AcroApp.Open searchFolder & fileName

the code should open file from pdf extensions when write in A1

any help to fix it

Private Sub Worksheet_Change(ByVal Target As Range)

    Dim searchFolder As String, fileName As String

   Dim AcroApp As Acrobat.CAcroApp
    
    searchFolder = "C:\search\files\reports\"
    
    If Right(searchFolder, 1) <> "\" Then searchFolder = searchFolder & "\"
    
    If Target.Address = "$A$1" Then
        fileName = Dir(searchFolder & Target.Value & ".pdf")
        If fileName <> vbNullString Then
            If MsgBox(fileName & " exists.  Do you want to open it?", vbYesNo + vbInformation, "Open PowerPoint file?") = vbYes Then
                If AcroApp Is Nothing Then Set AcroApp = CreateObject("AcroExch.App")
                AcroApp.Open searchFolder & fileName
            End If
        End If
    End If
    
End Sub

it's solved for benefit just follow the link

crossed posted

https://www.excelforum.com/exc…orkbooks.html#post5528906

hello

I have two files what I want match COLS B,C,D in two files if files INV1 contains data are not existed in file REPORT1 should highlighted by red and if file REPORT1 contains data are not existed in file INV1 should highlighted by blue color and if I change the unmatched data becomes matched data then delete

note : about the file REPORT1 every time increases the columns , it should highlight to the last column

highlight the color sorry if my explain are poor

this the first pot if anybody wants more explain please inform me

thanks in advance