Suljettu

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.

thanks!

Taidot: Visual Basic

Näytä lisää: vba with, vba excel programming, programming number, programming vba, programming excel vba, number programming, generation web creation, excel programming vba, excel access programming, basic programming computer, basic computer programming, vba generate invoice number, incoice, incoice software, vba time, vba for, in vba, basic needs accounts, were, vba word, vba excel, vba access excel, say, prevent, invoice example

About the Employer:
( 19 reviews ) Fort Worth, United States

Projektin tunnus: #33768

10 freelanceria on tarjonnut keskimäärin 165 $ tähän työhön

gaffapi

hi. please check pmb.

100 $ USD 2 päivässä
(46 arvostelua)
6.0
rajanlengde

will be as soon as accepted and escrowed.

100 $ USD 5 päivässä
(23 arvostelua)
4.9
abhijitcari

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

100 $ USD 30 päivässä
(5 arvostelua)
3.2
rajiv0911

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 Lisää

100 $ USD 2 päivässä
(2 arvostelua)
1.7
ProvatiTech

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 Lisää

250 $ USD 20 päivässä
(0 arvostelua)
0.0
yogeshkhatri

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 Lisää

300 $ USD 10 päivässä
(0 arvostelua)
0.0
websoftinfo

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 Lisää

300 $ USD 10 päivässä
(0 arvostelua)
0.0
magiedou

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

200 $ USD 30 päivässä
(0 arvostelua)
0.0
Resolutions

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 Lisää

100 $ USD 1 päivässä
(0 arvostelua)
0.0
fluentcoder

Thank you.

100 $ USD 14 päivässä
(0 arvostelua)
1.8