I have various VBA macros in my personal macro workbook, "Personal.xlsb." Is there an easy way for me to send these to others without copying/pasting from the code window?
In other words, is Personal.xlsb a workbook that can be opened and emailed as an attachment? Even If I can do that, the recipient would have to copy/paste my code to his/her personal code window.
Thanks!
It is, but people may have their own. Just export the module from Personal.xls to a .bas file and email that.
Entia non sunt multiplicanda sine necessitate
Thanks for your thoughts. However, as a test I saved the module and emailed it to myself. Outlook removed the attachment, writing "Potentially unsafe attachment removed!"
I can probably change Outlook to prevent that from happeinng, but thenmy recipeint would also have to do that.
Create an excel addin
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I agree with Roy's suggestion.
To the issue of Outlook stripping attachments, zip them.
You could also just rename the file as .txt rather than .bas before emailing it. Simpler than altering the Level1Remove registry key.
Everyone who confuses correlation and causation ends up dead.
Say what?Level1Remove registry keyIs that more osbcuria, more arcania?
The only reason to keep the .bas extension is that it's compatible with importing in the VBE. If you're going to send a text file, just copy and paste into Notepad from the VBE.
Whilst that is usually true, if you've tweaked it (e.g. to change the instancing or add a default property or the ability to enumerate your own collection) you want to export the module, not just copy it. That probably does count as arcana though...Originally Posted by shg
I don't grok that at all. Is that unique to class modules? It results in the exported bas file including attributes other than just module name?
Outlook blocks certain extensions by default. You can create a registry key called Level1Remove that lists extensions that should be allowed. I thought everyone knew that...
(For details see here.)
I think it is unique to classes - I can't offhand think of anything you could do to a normal module. (which is not to say there isn't anything)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Larry.LeBlanc@O 
Register To Reply
Bookmarks