Link to home
Start Free TrialLog in
Avatar of TheDetective
TheDetective

asked on

Excel Autonumber from Access

Hello,


I have multiple files in Excel format. They are invoices that need a  a unique sequential number populated in a cell.

Is there a way to use MS access to generate this number with like a primary key, populate the cell, and record the filename in an access table??



Thanks,
Omar
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Yes, this is doable by using VBA codes.
Avatar of TheDetective
TheDetective

ASKER

Great, can you share the code?
yes, but you need to give more detailed info...

a sample db and a sample excel file will help.
ok here are 4 spreadsheets with dummy invoices and and Access DB with a table.  Look at Cell B5  in the spreadsheet

My invoice schema is XXX-1, XXX-2, XXX-3, and so on.  I want to pull the number from access.

I want to use access to maintain the primary key and also to record the Invoice title for reference.


I can do some code, but I don't know the best way to interface between the two programs

Thanks for your help
not sure if the attachment made it
Invoices.zip
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This is great.  Works like a charm.  Thanks so much!!!!!