xlsx to xlsm conversion

[HopDevvil814]

Hello all,

I am trying to automate some reports out of DBeaver. When the scripts run as a scheduled task they are put into a folder as a xlsx. If I wanted to run macros on these reports they will need to xlsm, so how can I do this conversion? Or a I missing something?

[Norie]

Where is the code you want to run on the files located?

[TMS]

If I wanted to run macros on these reports they will need to xlsm

Why?

A .xlsm is a macro enabled file, that is, it has macros in it. You can save a file as a .xlsm file even though it dowsn't have macros in it. Equally, you can process the data in an .xlsx OR an .xlsm file.

Not sure why you see it as a problem. What macros are you using to process these files?

[HopDevvil814]

This is all new to me, but I thought that if I wanted to run macos the file needed to be .xlsm. So you're saying that can run macros on a .xlsx file? Coming from DBeaver, I do not have the option the save the file as.xlsm.

[TMS]

You have to save a file as .xlsm if it has macros in it. But, if you want your macro enabled file to process other files, they could be .xlsx, or xlsm, or even .xlsb files.

Again, what do your macros do?

[HopDevvil814]

I just want to understand the flow so I will start small. The plan is to add 3 columns, 2 of them would have default text and the 3rd just left blank.

[TMS]

So, you don't have any code? Ok, if you have, let's say, a master file that has your code in it, it can open any other type of Excel file. If you want to add columns, the process would be:

Open the file
Select the sheet (though not strictly necessary)
Add your three column headers
Add your static data
Save and close the file.

Repeat for each file.

[HopDevvil814]

I think I might try to record the macro, if not I will code it. But the end goal is to not touch the files at all, I want everything to completely automated.

[HopDevvil814]

Please Login or Register  to view this content.

This will convert my xlsx to xlsm

[TMS]

Fine. But I still don't understand why you believe you need to convert them.

[Norie]

Why not use the loop in that code to add the columns you mentioned in post #6 to each file in the folder?