Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Where is the Template Wizard with Data Tracking Excel 2003? | Excel Discussion (Misc queries) | |||
Charts causing program to crash | Charts and Charting in Excel | |||
Does the add in Template Wizard exist for Excel 2003 | Excel Discussion (Misc queries) | |||
How to use the template wizard with office 2003 | Excel Discussion (Misc queries) | |||
Does anybody have a CD collection template | Excel Discussion (Misc queries) |