0

I got excel file : '.xlsx' file.

And there are some custom function like =BlahBlah(par1,par2,par3,par4)

I want to extract the source code of this function.

But in VBA (when I push alt + F11 button), there are no source in module. So I made '.zip' file to see '.vb' file in my '.xlsx' file. However, there is only '.xlsx' file in '.zip' file.

Because custom function works well, I think there should be a source code which constitute for this custom function. But I don't know where it is.

user13232877
  • 205
  • 1
  • 9
  • Did you check worksheets codes rather than module? Also there may addin installed to the computer. – Harun24hr Jun 07 '21 at 05:46
  • @Harun24HR xlsx doesnt hold any code so its nothing related to the file, just an addin – West Jun 07 '21 at 06:11
  • 1
    The code is probably loaded from an add-in or some separate .xlsb file. The probability of the source being an add-in is higher. – Roy Jun 07 '21 at 07:00
  • Thanks for all replies. I didn't think about it. I'll study about add-in. Thanks sincerely. – user13232877 Jun 07 '21 at 07:18

2 Answers2

0

The '.xlsx' file doesn't store VBA code and it could be an add-ins. More details seems to be described. Good Luck.

ALIREZA.SOLOUK
  • 1
0
  1. Rename your MyExcel.xlsm to MyExcel.zip
  2. Explore MyExcel.zip to find \xl\vbaProject.bin
  3. Tailor approach according to these Microsoft guidelines: Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel

Let us know how you make out!

Mike G
  • 712
  • 5
  • 9