2

My requirement is: I have been given an excel (the user uploads it to our server) and then my program should automatically add a macros code (defined in a text file maybe) to the excel file and then send it back to the user. I found a similar question but the solution only works in Windows but since our server is Linux based, I haven't found a way to do so.

Link to the similar question: Use Python to Inject Macros into Spreadsheets

Rahul R Badenkal
  • 61
  • 1
  • 11
  • If you put the macro in the Personal Workbook, it is then available to all workbooks. – Solar Mike Jul 06 '18 at 05:32
  • My requirement is: I have been given an excel (the user uploads it to our server) and then my program should automatically add a macros code (defined in a text file maybe) to the excel file and then send it back to the user. Since our server is Linux based, I haven't found a way to do so. I think my question wasn't clear enough so I have changed it accordingly – Rahul R Badenkal Jul 06 '18 at 05:40
  • why not make an installer code - less file transfers... – Solar Mike Jul 06 '18 at 05:45
  • It is an additional feature that is being added to an existing web application that the users are already using and I think it would be better to keep it all in the web application. – Rahul R Badenkal Jul 06 '18 at 05:55
  • I would not EVER send you an excel file with all my work / functions just for you to add a macro - you get to keep all my material... – Solar Mike Jul 06 '18 at 05:58
  • did you find any good solution? – benzkji Nov 15 '18 at 15:56

1 Answers1

1

Assuming you're being sent a file in xlsm format, you need to following capabilities:

  1. Open the file as a zip file
  2. Locate the .bin part path from the rels files - see Microsoft Open Packaging Conventions
  3. Locate and open the VBA project's .bin stream
  4. parse the .bin stream as a Compound Binary File Format file
  5. Parse the binary streams that describe and list the module contents of the file, as documented in Office VBA File Format Structure
  6. Add your module text as a new stream, and update the files from step 5 with the new contents.

It's not a small undertaking. The work has already been done in Python, and a lot of the libraries for working with zip files and compound binary format files are already in .NET for Windows. Otherwise, as far as I'm aware, there aren't any other pre-built tools, other than the tools from aspose

ThunderFrame
  • 9,352
  • 2
  • 29
  • 60