Importing/exporting Excel VB modules

Mark Carter cartermark46 at ukmail.com
Thu Jun 19 05:06:39 EDT 2003


I have the excellent win32com python module. What I'm trying to do is
import and export VBA modules into Excel programmatically.

Does anyone know how to enumerate the modules?

>From within the VBA editor I tried:
  x = ThisWorkbook.Modules.Count
but it came up with the number 0 (which isn't correct).




More information about the Python-list mailing list