Anyway, here are some tips for all you macrophiles wishing to use this particular macro.
- Use UNC paths
- Unless you are using the drives on your PC or ar 100% certain that mapped drives will remain the same in your organizaion for all users that will be using your app, you are only asking for trouble. Bone up on what a UNC path is here: http://compnetworking.about.com/od/windowsnetworking/g/unc-name.htm.
- Make sure the file you're importing is allowed by Access.
- The allowed extensions are: txt, csv, tab, asc, tmp, htm, html, but if you are so insistent that you need to allow some other extension, you can hack the registry using this MS article: http://support.microsoft.com/kb/306144. Please note that if you are using a 64 bit OS with 32 bit Office, you may need to also look in the HKLM\Software\Wow6432Node\ for the setting.
- Make sure you have enabled macros.
- This one is kind of a gimmie, but can get overlooked.
- If you cannot see the macro in the dropdown list, make sure you are showing all macro actions.
- The Transfer Text macro is not trusted or regarded as "safe" so Access hides it by default (that should tell you macrophiles something right there).