part price calculation in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi- we would like to be able to use an existing spreadsheet for the
calculation of part prices and transfer the price to our db. I know how to
transfer the query for a part's dimensions and specs to Excel (w/
transferSpreadsheet) and how to transfer that calculated price back to
Access, but I don't know how to do all at the same time - the worksheet is
linked to the temporary file created by the export- or if that is even the
best way to go - can someone point me in the right direction? Thanks.
 
I'm sure that it's doable, but I hate the idea. You'd be playing with
exports, imports, linked spreadsheets or maybe Excel automation. Horrible
however you do it I think. Why not just do the calculation in Access? I
assume it's a complicated one, but you can always just write a function to
do it.
 
I was afraid you might say that. Yes, the scenario is that there are
worksheets to calculate part prices for about 50 styles and the queries to
replicate them are quite extensive. Would it help to know that noone else
would be using that spreadsheet, it simply is there for price calculation
only - so there wouldn't be any sharing issues.
 
I'm afraid that I've had a play and I can't get it to work sensibly. I
think you'd have to fall back on automation (which I hate).

Take a look at this http://www.mvps.org/access/modules/mdl0006.htm

It sounds like you may be able to get away with just dumping your values
into a sheet, saving it, then linking to the file.
 
Back
Top