VBA - Incoice Number Generation

Here's what I'm looking for:

The creation of five files:

Four Word files and one Excel file...

The four Word files (docs or templates) would all generate invoice numbers from the same master file (Excel). So if the Word files were named "Doc1", "Doc2", "Doc3" and "Doc4" and an invoice number in Doc2 was, say "10727" then the next invoice number to be generated would be "10728" regardless of which document it is going to or who requested it. Additionally, it would need to be possible for two users to have "Doc2" open at the same time. Preferably, to prevent accidental deletion/change, these files would be protected from being saved as their original name.

One note about the sequencing requirement... it needs to be accessible to both "limited" and "computer administrator" accounts. For example, if I log in as a "computer administrator" and the invoice is 10727 and then I log on as a guest with "limited" access, the next invoice number needs to still change to 10728. When I cut and paste the VBA programming I have seen on the web, it does not correct this. It only updates the invoice number if it is done by someone with "computer administrator" access.

To "create" this invoice number either one of the following two methods to generate an invoice number when inside a word document:

- creating a button on the toolbar that would generate the invoice number (preferred method) or....

- creating a button in the Word document itself that would generate the invoice number.


Evner: Visual Basic

Se mere: what is vba programming, what is a method in programming, vba with, vba programming in excel, vba excel programming, programming number, programming in vba, programming in excel vba, number programming, generation web creation, excel programming vba, excel and access programming, excel access programming, basic programming in computer, basic computer programming, software development invoice number generation, vba generate invoice number, incoice, incoice software, what is vba in excel, what is vba, vba time, vba for word, vba for, in vba

Om arbejdsgiveren:
( 19 bedømmelser ) Fort Worth, United States

Projekt ID: #33768

10 freelancere byder i gennemsnit $165 på dette job


hi. please check pmb.

$100 USD in 2 dage
(46 bedømmelser)

will be as soon as accepted and escrowed.

$100 USD in 5 dage
(23 bedømmelser)

I can do this job within the stipulated time frame that I have given.

$100 USD in 30 dage
(5 bedømmelser)

Dear Sir, I am an expert in VB6 and VBA along with MSAccess, Sql Server and ORacle. I would like to do this for you. But i need some more clarification. I need to have some rating so i can do this for a better price as Flere

$100 USD in 2 dage
(2 bedømmelser)

Dear Sir! We are an efficient and dedicated team of professionals. We offer our large experience and professionalism to make all qualitatively. We provide post-developing support until all Your requirements are complet Flere

$250 USD in 20 dage
(0 bedømmelser)

I myself am a MICROSOFT CERTIFIED PROFESSIONAL and am running a software company in New Delhi for the past 6 years. We can provide you with the solution just as per your requirement. We can assure you of the best of Flere

$300 USD in 10 dage
(0 bedømmelser)

Our bid is for really very high quality work for your VBA - Incoice Number Generation that will be made to be upgradable in case you need some upgrades in future. We will always be available for upgrades. Our bid incl Flere

$300 USD in 10 dage
(0 bedømmelser)

I'm waiting for your chosen, please check my profile.

$200 USD in 30 dage
(0 bedømmelser)

Hello, We are a software development organization based in India. We have made several applications on VBA and are sure of completing this to your full satisfaction. We can do it for $95. Hoping for a favourable Flere

$100 USD på 1 dag
(0 bedømmelser)

Thank you.

$100 USD in 14 dage
(0 bedømmelser)