|
|
Hi Mike
I never used the Add-in myself so i can't help you.
Maybe there is anybody else that have experience with it.
Good luck
--
Regards Ron de Bruin
http://www.rondebruin.nl
"millemj" wrote in message ...
Ron,
Many thanks for your reply. I'm making some progress. However...
I do have a notebook computer with Office XP, which did not have the add-in.
I was able to successfully install it to the notebook and then copy the XLA
file to the desktop computer with Office 2003 (C:\Program Files\Microsoft
Office\Office 11\library).
I noted during the install on the notebook, though, that there was a DLL
(XLL?) installed, but it went by so fast I could not see its name or complete
extension (I saw two L's on the end, though). I figured that if XL2K3 needed
it, it would complain about it, so I pushed on.
I was able to see & activate the add-in in the O2K3 tools|add-ins dialog. No
mention of the missing DLL/XLL, but again, the toolbar from the invoice
template I'm using would not display. From the same customize dialog, I
clicked on "attach" and could see the custom toolbar (invoice) listed but
still it would not display.
So I decided to use the Macros list to execute the database update that I
need for tax purposes (databaselink). XL (VBA) complained that it could not
open the INVDB.xls database. I noted that the database it expected to find
was in a different path than where I had it, so I created the full path that
it was trying to find, copied the file there, and tried the databaselink
macro again. Still can't open the file, no explanation why.
Next, I told the macro to just create a new INVDB.xls, which then took me
through the wizard asking me to tell it which specific cells to use to
create/update the file. At this point I aborted, since I would have to go to
my old copy of the file and map cells to columns, one by one, and there was
no guarantee that what I mapped would be the same as what the update function
expected to see.
I can't help wondering if the invoice template I'm using, again a throwback
to O2K, has been superceded by one of the myriad of invoice templates I see
on MS's downloads page. The two I've downloaded have no capability to update
an XL database.
Unfortunately, Microsoft has hidden the worksheet with the template's
parameters, and password protected the VBA project for the template, so I
can't go in and just fix the damn thing myself. Certainly if I had the time,
I would just recreate the capability in my own add-in (which I may do when
things slow down in January).
I don't want to overstay my welcome here, but any final insight you have
would be greatly appreciated.
Mike
"Ron de Bruin" wrote:
Hi
The Add-in is working in 2003 only the install file is not working.
Copy the xla file from a PC with 2002 to the PC with 2003
and it will work(use Toolsadd-ins to browse to the file in Excel)
If you don't have a PC with 2002 then mail me private and then i send you
the xla file
--
Regards Ron de Bruin
http://www.rondebruin.nl
<snip
|