How to error handling when I run Excel Macro

(0) Share

Report

Posted on by Miyuki

Hi, All

I try to use an Excel Macro which includs the following code.

----------------------------------------------------------------------------------

With Application.FileDialog(msoFileDialogFolderPicker)
    .title = "Choose Folder"
    .InitialFileName = "C:\Users\FLC004\Desktop\PDF"
        If .Show = 0 Then
            MsgBox "Interruption"
            End                                    ←←←
        Else
            myfolder = .SelectedItems(1)
        End If
End With

----------------------------------------------------------------------------------

When I use "Run Excel Macro" , the process goes through "End"(←←←part), nevertheless FileDialog is shown again.
I click "cancel" again and the error occurs(cf: attached file).

Do you know how to address this situation?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

MichaelAnnis 5,727 Moderator on at

Like (1)

Report
Copy link

Link copied!

With the adoption of Power Automate, we have removed any dialogue/message boxes from our Macros. As an alternative, we have proceeded to fill in necessary information elsewhere in the workbook, such as on an "Input" tab.

This allows a person manually running a process to simply fill in the information, and if PAD is doing it, then it can use the %Folder% variable to populate the cell prior to running the Macro.

Was this reply helpful? Yes No
Miyuki 73 on at

Like (0)

Report
Copy link

Link copied!

Hello, Michael

Thanks for your quick reply and I'm sorry for the late response.
(I couldn't input and click on this site due to Internet Explorer. Now I realize that this site adapt Microsoft Edge😓.)
I understand that I need to remake my Macro or PAD.

Miyuki

Was this reply helpful? Yes No