I am trying to create a UserForm X. If, for whatever reason, form X
already exist, I want to remove it and re-create it again.
Sounds simple, right?
Here's the code:
Dim TempForm As Object ' VBComponent
On Error Resume Next
Set TempForm = ThisWorkbook.VBProject.VBComponents("Bob")
Two essentials:
http://www.cpearson.com/Excel/MainPage.aspx
http://www.ozgrid.com/
If you have basic Programing knowledge, these two sites should have nearly
everything you need. If you don't, get a basic cours in programing first.
--
---
That solution, although not entirely wrong, would not work on all
computers.
This is mainly caused because there are many potential problems :
1) the date items separator (here ".")
2) the date structure of the text field (here it is "ddmm")
3) the date structure as used by your system (could
Good day everyone,
I have a small fleet of Excel apps who, sometime, need updating.
For modules, I simply
ThisWorkbook.VBProject.VBComponents("WhateverModule").Export
tempFile
DestWbk.VBProject.VBComponents.Import tempFile
Kill (tempFile)
But I can not use the same code to import int
Good day everyone,
I have a small fleet of Excel apps who, sometime, need updating.
For modules, I simply
ThisWorkbook.VBProject.VBComponents("WhateverModule").Export
tempFile
DestWbk.VBProject.VBComponents.Import tempFile
Kill (tempFile)
But I can not use the same code to import int
