Can't see Macro in imported File

Hi. I'm fairly new to scripts and macros in excel and I have a small problem I can't seem to find a fix for.

I have hundreds of files that need to be imported to excel with an add-in. The add-in I'm using is TDM Excel Add-In.

The Add-In automatically detects the file extension in windows and I can directly double-click the file in windows to open it via the add-in.

I need to save these imported files as a specific name that is written in a specific row and column (A2).
This is the macro-script I'm using:

Private Sub Speichern_Click()
With Application.FileDialog(msoFileDialogSaveAs)
        .Title = "Datei speichern"
        .InitialFileName = Range("A2")
        .ButtonName = "Jetzt speichern"
        .Show
        .Execute
    End With
End Sub

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

It's working fine in other excel-files, but eventhough I've saved this macro within the Personal.xlsm file, so it is globally available, I don't see it in the development tab (nor can I use the shortcut).

I think this is happening, because my file-format (from the imported data) isn't .xlsx yet.

Is there a workaround to make the macro accessable?

My final goal is to have an .exe-file that I can drop inside of the folder with all my data files and upon execution it automatically imports all the data and saves it as an .xlsx file with the specific name. But I think I need Microsoft Visual Studio for that.

Anyway.. I'd really appreciate any kind of help or feedback to my problem. I couldn't find this specific case when using google.

Greetings from Germany!

Change your Macro Name

From

Private Sub Speichern_Click()

To

Sub Speichern_Click()

Unfortunately this didn't help.
When I look in the developers environment I don't even see my VBA Project PERSONAL.XSLM in the imported file. Even when I save it as .xslx beforehand.
Unbenannt.PNG

Maybe the add-in im using to import the file isn't opening a macro compatible excel sheet?

EDIT: I've tried saving the file after importing as an excel file with macros enabled. But still after saving there are no macros to be found anywhere. Only when I open a new excel sheet I can see my macros.

EDIT2: I've found a workaround. If I open excel first, and then use the add-in to import the file. I have full access to my macros. If I open the file via double-click (the excel add-in automatically detects the file format) I dont see any macros. This is kinda annoying still, cause I have to open all the files manually and save them with my macro, but at least I've made some progress.

EDIT3: Can anyone tell me, just in general (I'll do the research about "how" myself), if it's possible to create something like a batch file for example to automate the following process:

1. open excel
2. use add-in to import data
3. use macro to save the file with a specific name
4. close excel
5. repeat with the next file in the folder