Macro not more working with Win11?

Hello, i have the following small macro in my excel running fine with on Win10:
(its simply a button in the xlsm and when pressed the exe-file gets executed)

Sub calcConstr()
    Dim FN As String
    FN = Application.ThisWorkbook.Path
    FN = FN + "\constrCalc3.exe"
    Shell FN, vbNormalFocus
End Sub

But when i run the same xlsm and press the button i get this error:
2022-03-10 21_13_08-Microsoft Visual Basic.png

They only difference between the computers that on the one is running win11 and on the other win10
(excel is with 365 on both the same)

What can be the reason that this is not anymore working on the win11-pc?

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code] [/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I have added them for your because the section of code was very short. However, please take the time to review our rules. There aren't many, and they are all important.

Originally Posted by Rapid1898

They only difference between the computers that on the one is running win11 and on the other win10

I have seen dozens of questions like this, and that is never the only difference.

N = FN + "\constrCalc3.exe"

Does constrCalc3.exe actually exist in the same folder with the Excel workbook that is running this code?

The way I would troubleshoot this is to reproduce the Shell command in the Windows cmd window.

Add this line of code before the Shell command:

Debug.Print FN

Go to the Immediate window and copy the full path that was just printed.
In the Windows search bar type cmd to bring up a command window
Type a quote " then Paste in the command window (which will paste the path you just copied) then type another "
Hit Enter, and report back on what happens.

notfound.jpg

Originally Posted by Rapid1898

Then i started the button i get this message-box
Attachment 772061

But nothing else opened - and i can so no path-output anywhere to make the checks you described.

I tried to click on the Debug-Button - then i see the following (but again no path to check):
Attachment 772062

Your images didn't show up.

There is a bug in our image attachment feature. To attach an image, first click Go Advanced under your edit box. Then go ahead to press the image icon and attach your image.

I did it like this:

Option Explicit

Sub calcConstr()
    Dim FN As String
    Debug.Print "FN: " & FN
    FN = Application.ThisWorkbook.Path
    Debug.Print "FN: " & FN
    FN = FN + "\constrCalc3.exe"
    Debug.Print "FN: " & FN
    Shell FN, vbNormalFocus
End Sub

FN:
FN: E:\...\Downloads
FN: E:\...\Downloads\constrCalc3.exe

That way, you can see how the contents of the variable FN builds up.

The output will appear in the Immediate Window in the VB Editor. If you can't see it, press Ctrl-G.

Are you sure that the full path exists? And that there are no trailing spaces on the folder name(s)? Could it be something to do with permissions? Can you run the .exe file from that folder?

Thanks for your help - with the following line i was able to output the path-informaton

MsgBox "The value of FN is " & FN, vbInformation

I have to check this and get back to you asap.

Here are your images inline in a post, inserted by following my instructions:

4.jpg

2.jpg

It appears that this folder is in a OneDrive synced folder. If so, the .Path name will be the location where it is stored in the OneDrive cloud, not the path on your local machine. (This is one reason I don't like OneDrive. I don't have this problem with Dropbox.) I fixed this same problem for someone who worked for me by moving the Excel file out of the OneDrive folder into a folder on the local drive.

Like I said, I have seen dozens of questions like this, and that is never the only difference. You evidently did not use OneDrive on the Windows 10 machine.

There are ways but I've never done it. It's a little complicated. Normally we do not link to other sites but here is a page with a solution to your exact problem. There are multiple options discussed here so you will have to decide which one will work best for you.

The way I solved it for my employee was to move the folder out one OneDrive to a regular C: drive folder.