Link 2 compiled file

L

linkcode

New member
im using office 365 with windows 10. i want to link 2 compiled exe files. i try to add companion file but. companion files cant save i gues. and not prefer companion files for security.

i use both of excels =PLEvalVar(“XLSPath”) formula to learn virtual location. and force to update current connection links with this code:
Code: 
  Dim wbTrg As Workbook
    Dim sLinkNew As String
    Dim aLinks As Variant, vLink As Variant

        sLinkNew = Range("D2").Value & "filename1.xlsm"
        Set wbTrg = ThisWorkbook

        aLinks = ActiveWorkbook.LinkSources(xlExcelLinks)


        If Not IsEmpty(aLinks) Then
            For Each vLink In aLinks
                wbTrg.ChangeLink Name:=vLink, NewName:=sLinkNew, Type:=xlExcelLinks

        Next: End If
it didint work (i unchecked “do not allow loadinf/saving other…” option when i compile ). i didint use any formula protection option too.
to understand how to links works ; i try to copy 1 cell to another excel and paste special as link.
i saw this array formula:

{=Excel.SheetMacroEnabled.12|‘k:\Office\H4PTK\filename1.xlsm’!’!sheet1!R5C3’}

How can I solve this issue?

ps: same issue link a excel file (not compiled) to exe file(compiled)
 
Last edited:
It’s probably because workbooks are placed on virtual and random locations.
Moreover, the secure Excel instance isn’t allowed to exchange with other instances. To make it work, you must load the other workbooks with VBA into the secure instance that runs the main protected workbook.
 
i try “do not use virtual drivers…” option . but it didint work too.

questions 1
can save companion file ?

question 2
the secure Excel instance isn’t allowed to exchange with other instances
Click to expand...
is this optional ? because the secure exe we created should be able to work with another secure exe or another files. should be able to read or be read by a normal excel file other than the secure location. sometimes customers want a part that can work in their file system rather than a complete file system.

question 3
i think some problems with office 365… i tested some problems with formula protection (exp: filter formula.) When I used it in previous office versions, I don’t remember that the array formula appeared in the link paste process… When I pressed the = sign and clicked on the cell in the other opened workbook, it was linked. but now its not working. is it because of office 365 or Is there an update that I didn’t notice?

question 4
If the array formula in the address section is updated in the next version, I think the problem will be completely resolved. I want to link it as in normal: excel pressed the = sign and clicked on the cell etc…
Is such an update considered for next versions?
{=Excel.SheetMacroEnabled.12|‘k:\Office\H4PTK\filename1.xlsm’!’!sheet1!R5C3’}
instead of like
=‘k:\Office\H4PTK\filename1.xlsm’!’!sheet1!R5C3’

question 5
To make it work, you must load the other workbooks with VBA into the secure instance that runs the main protected workbook.
Click to expand...
can you upload example files ? because i didint understand how to do that… only the exe versions of the two files should be able to see each other with a link. each time the files are opened, I will manually enter the randomly generated location.I can update the new location using the button. During all these conditions, both exe files will be open.
 
Last edited:
question 3 update: sometimes the secure excel file can see the normal excel file in windows. Sometimes I can’t connect at all. I am extremely confused trying to figure out what the parameters depend on. and im completly lost

PS: still filter formula not works with formula protection in excel 365.

other questions still pending
 
Last edited:
You must log in or register to reply here.
Back
Top