Rick
6th April 2011, 11:34.25 AM
The HTR Templates has been updated to remove the Import Macros.
Because of the problem I was having getting all the Import Macros to run correctly, I converted all the Import Macros to VBA.
So when you use the Import Buttons on the Control Panel it runs the VBA code.
For anyone doing exports in a directory other than C:\htr, my recommendation is to Move the export file to c:\htr before importing into Access.
That way you don't have to worry about changing any of the import code.
Zabkat http://www.zabkat.com/x2lite.htm has a free version of their xplorer2. This program can display 2 directories side by side. That way it is easy to move or copy a file from one directory to another.
When moving from directories on the same drive, you can just left click on the file name and drag it to the other directory. When moving from one drive to another you have to do a right click drag and then select Move.
The only change is that I removed the Import Macros. The previous version was using the VBA code for importing.
Because of the problem I was having getting all the Import Macros to run correctly, I converted all the Import Macros to VBA.
So when you use the Import Buttons on the Control Panel it runs the VBA code.
For anyone doing exports in a directory other than C:\htr, my recommendation is to Move the export file to c:\htr before importing into Access.
That way you don't have to worry about changing any of the import code.
Zabkat http://www.zabkat.com/x2lite.htm has a free version of their xplorer2. This program can display 2 directories side by side. That way it is easy to move or copy a file from one directory to another.
When moving from directories on the same drive, you can just left click on the file name and drag it to the other directory. When moving from one drive to another you have to do a right click drag and then select Move.
The only change is that I removed the Import Macros. The previous version was using the VBA code for importing.