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.


Beceriler: Visual Basic

Daha fazlasını görün: 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

İşveren Hakkında:
( 19 değerlendirme ) Fort Worth, United States

Proje NO: #33768

10 freelancer bu iş için ortalamada 165$ teklif veriyor


hi. please check pmb.

in 2 gün içinde100$ USD
(46 Değerlendirme)

will be as soon as accepted and escrowed.

in 5 gün içinde100$ USD
(23 Değerlendirme)

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

in 30 gün içinde100$ USD
(5 Değerlendirme)

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 Daha fazlası

in 2 gün içinde100$ USD
(2 Değerlendirme)

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 Daha fazlası

in 20 gün içinde250$ USD
(0 Değerlendirme)

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 Daha fazlası

in 10 gün içinde300$ USD
(0 Değerlendirme)

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 Daha fazlası

in 10 gün içinde300$ USD
(0 Değerlendirme)

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

in 30 gün içinde200$ USD
(0 Değerlendirme)

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 Daha fazlası

1 gün içinde 100$ USD
(0 Değerlendirme)

Thank you.

in 14 gün içinde100$ USD
(0 Değerlendirme)