Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where is the Template Wizard with Data Tracking Excel 2003? liz braford Excel Discussion (Misc queries) 8 December 7th 05 06:50 PM
Charts causing program to crash Fysh Charts and Charting in Excel 1 December 16th 04 10:12 PM
Does the add in Template Wizard exist for Excel 2003 Casey Excel Discussion (Misc queries) 2 December 2nd 04 05:55 PM
How to use the template wizard with office 2003 choppernigel Excel Discussion (Misc queries) 3 December 1st 04 01:56 PM
Does anybody have a CD collection template PeterM Excel Discussion (Misc queries) 2 November 27th 04 05:46 PM


All times are GMT +1. The time now is 06:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"