Solved

Unique Invoice Number

Posted on 1998-04-16
6
376 Views
Last Modified: 2006-11-17
Greetings,
I'm new to VBA with Excel. I was wondering how I can have a unique Invoice Number  printed on an expense report I have created. It is in a protected Excel 97 template. There will multiple users and I need the invoice number counter to increment by one each time the template is opened. I'm sure some one has run into this before. If the code exists please let me know where to find it. I'm very familiar with VB just not the Excel API.

Thanks for your help in advance,
Brad
0
Comment
Question by:bhummel
  • 3
  • 3
6 Comments
 

Accepted Solution

by:
Acmatics earned 100 total points
ID: 1612505
You could create a shared database (.mdb) with an AutoIncrement field in your Invoice record. As you add new Invoice records a new number will be generated.  
0
 

Author Comment

by:bhummel
ID: 1612506
I was trying to avoid that. I wanted to keep it all with in Excel. But, it's looking more and more like that is the only way to go. Question how do you name a cell in Excel? You can Book Mark in Word is there similiar functionality in Excel.

Thanks,
Brad
0
 

Expert Comment

by:Acmatics
ID: 1612507
This is a new question of course, but you should have no problem playing "Name that Range".

0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:bhummel
ID: 1612508
Did that. I used MSQuery and and an .mdb as you suggested. For some reason Excel keeps putting a header above the AutoNumber from the .mdb. Can I get rid of that column name? Also, the spreadsheet will be protected, I have unlocked the cell and it gives me an error saying the sheet is locked. How Can I get around that?

Thanks,
Brad
0
 

Expert Comment

by:Acmatics
ID: 1612509
Again another set of questions, but did you set protection off, did you try using overriding your column heading to "", did you consider doling out a few points?;)
0
 

Author Comment

by:bhummel
ID: 1612510
Thanks for your help. Here are your points.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to convert JSON file to csv? 7 85
OCT or Config.xml 2 56
Input Data Using a unique ID from another sheet in Excel 3 45
MS office 2010 activation 4 40
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
Outlook Free & Paid Tools
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question