|
|
what program do i need for this
|
|
|
|
Dedicated MacNNer
Join Date: Sep 2000
Status:
Offline
|
|
i have 5 price books in excel format 2002 to 2007
i want to build an app that will look up a part number in each price book
and display by year and line in a window.
example
year part number description cost list activity code
2002 01012688 gasket rubber .25 1.25 a
2003 01012688 gasket rubber .30 1.50 a
etc etc
needs to be web based or xp compatible
thanks fred
|
|
|
|
|
|
|
|
|
Posting Junkie
Join Date: Apr 2007
Location: Iowa, how long can this be? Does it really ruin the left column spacing?
Status:
Offline
|
|
I'm sure you could build an Excel sheet (or VBA script) to handle this.
|
|
|
|
|
|
|
|
|
Dedicated MacNNer
Join Date: Sep 2000
Status:
Offline
|
|
the people i'm making this for are excel access handicapped.
i dont want it program dependent
fred
|
|
|
|
|
|
|
|
|
Posting Junkie
Join Date: Oct 2005
Location: Houston, TX
Status:
Offline
|
|
Combine the excel files into one spreadsheet and then export as HTML.
|
|
|
|
|
|
|
|
|
Dedicated MacNNer
Join Date: Sep 2000
Status:
Offline
|
|
ok
then what?
how do i look up a number?
|
|
|
|
|
|
|
|
|
Clinically Insane
Join Date: Mar 2001
Location: yes
Status:
Offline
|
|
Does the information need to be searchable? If so, Excel -> MySQL -> home grown search interface
|
|
|
|
|
|
|
|
|
Dedicated MacNNer
Join Date: Sep 2000
Status:
Offline
|
|
Isn't there some kind of program that will let export an access file to a exe program??
fred
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forum Rules
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|