I thought I had this right, but I was wrong.
I want to export a module, but I want to specify exactly where I wanted exported to i.e. Desktop or My Documents or wherever...How?
The export procedure is
(Dunno why it's showing in preview as Ex port)Sub ExportModule() Application.VBE.ActiveVBProject.VBComponents(1).Export ("Version101.bas") End Sub
TIA
John
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
I'll let Mark know about the word Export being splitted for some reason.
You just need to specify the path with the file name.
Option Explicit Sub ExportModule() Application.VBE.ActiveVBProject.VBComponents(1).Export _ ("c:\Version101.bas") End Sub
Thanx Jake,
Works a treat.
(I specified the path differently for import and it worked so I assumed it'd work for export as well, but it don't)
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
You're Welcome
Take Care
Posting Permissions
Reply With Quote
