Trying to Enter data into a Save As box that another macro creates

Hello

Quick back story, I'm using a workbook that has various macros that I cannot access the code for. I'm able to find the macro names and run them, but am unable to access or change any of the code.

What I'm attempting to do to create my own macro which opens said macro, inputs new data, then runs one of the workbook's macros which produces a new file and save it.

I've made a macro that opens up said workbook, inputs new data where needed and then runs one of the workbook's macros. My issue is the workbook macro produces a "Save As" box which I'm not sure how to access via my own macro. I could easily do it if I prompted the Save As, but since the workbook macro did, I'm not sure how to give it a name and file path.


I'm still a novice at writing macros. I've created many, but it's mostly by looking up expressions and piecing it together. Never had any formal training.

Thanks in advance for anyone taking pity.

I'm unable to the other workbook macros as they are locked, also it does a great many things that I wouldn't know how to start if I tried to code it.

I've attempted to disable Save As, but that didn't work. If I was able to 'cancel' the SaveAs after it starts that would work too.

Here's the code with private info removed.


Workbooks("A").Activate
Application.CommandBars("Worksheet Menu Bar").Controls("File").Controls("Save As...").Enabled = False
Worksheets("PXC").Activate
Application.Run _
"A!Sheet365.RunXX_Click"

Application.Run _
"A!Sheet365.Typ_Click"

(It's the Typ macro that produces the Save As box).