Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can not save if this code is in the workbook
I am not sure what the problem is with this code. If this code is
present in any workbook, it will not let me save the file. It says they may be a problem with the read writes, but this is not true since I can save it willout the macro just fine. Any help would be greatly appreciated. Thanks, Jay Sub CopyOneModule() Dim FName As String With ThisWorkbook FName = .Path & "\code.txt" .VBProject.VBComponents("modTest").Export FName End With ThisWorkbook.VBProject.VBComponents.Import FName End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Before Save code | Excel Worksheet Functions | |||
How to save my VBA-code | Excel Worksheet Functions | |||
FILE 'SAVE AS' IN VBA CODE | Excel Discussion (Misc queries) | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
copy and paste using code from workbook to workbook | Excel Discussion (Misc queries) |