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
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
Yes, this is doable by using VBA codes.
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.
a sample db and a sample excel file will help.
ASKER
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
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
ASKER
not sure if the attachment made it
Invoices.zip
Invoices.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is great. Works like a charm. Thanks so much!!!!!