How to export VBA code (NOT "VBA code to export other items")

[ahseenam]

I'm working on someone else's database. Windows 8, Access 2010.



When I have a VBA module I'm working on sometimes I can right click on it and export it. Some modules though, when I right click and select "Export File" nothing happens. Nothing... like no error message, it doesn't hang, nothing at all. I can go do anything else immediately afterwards. What would cause this to happen?

I've been trying to google this but I keep getting results for how to use VBA code to export other items, not help on how to export VBA items themselves.

Thanks!

[ranman256]

I notice Access will have little quirks that stop working for various people.

If you tried export via table side of access, did you try the export in the VBE side?
Here you right click, export, but you must export to a file (not to another db)
if that works, goto the other db, then VBE, then import the module.

[ahseenam]

Yes... sorry my initial question wasn't clear. I am trying to just export file, not export to another db. When I'm in VBA and I right-click on a class/module/etc and try to Export File, sometimes it works fine. Other times (for some modules I actually need to export) nothing at all happens... no freezing, no errors, nothing at all. Look at the image to see what I'm clicking on in a sample db. Could there be some settings in the module I'm trying to export that prevents exporting? I'm not getting any error so I'm not sure that's it.

EDIT: Additional note... I do have full rights to edit anything in this db. I have no restrictions.

[ranman256]

Yeah, we're back to the quirks. sometimes my TABLE MANAGER stops working. Other days its fine.
I HATE THAT.

If the export dont work,
open the module
Ctl-A (select all)
copy
paste into notepad.

[ahseenam]

Thanks. That's what I've been doing all along as a workaround -- just copy & paste into txt file, and then ask the recipient to copy the code back into their database. Just trying to figure out why export file does not work.

[ssanfu]

Have you been editing the code just before trying to export? Possibly the code changes are not saved.

Also try "Compile", then save before exporting.
Maybe even "Compact and Repair" before export.

I have not had this "quirk" occur to me (yet).

[ahseenam]

Yeah, I've tried to decompile/compile, I've run C&R.

I just can't figure out why Export File silently fails, and only on some modules.