Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Good day everyone,
I have a small fleet of Excel apps who, sometime, need updating. For modules, I simply ThisWorkbook.VBProject.VBComponents("WhateverModul e").Export tempFile DestWbk.VBProject.VBComponents.Import tempFile Kill (tempFile) But I can not use the same code to import into ThisWorkbook as I do for modules. ThisWorkbook.VBProject.VBComponents("ThisWorkbook" ).Export tempFile DestWbk.VBProject.VBComponents.Import tempFile Kill (tempFile) Instead of replacing (or adding) the code within ThisWorkbook, it creates a new Class Modules named "ThisWorkbook1". Do you have any suggestion on how could I fix that? The only other solution is to manually set all my events to something static refering to a module. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I import raw HTML source code into Excel? | Excel Programming | |||
import xml in excel workbok using VBA code | Excel Programming | |||
Code to import from txt to excel | Excel Discussion (Misc queries) | |||
Import HTML code into Excel | Excel Programming | |||
Code: Using Excel Application level Events | Excel Programming |