Link to excel spreadsheet


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 6 of 6

Thread: Link to excel spreadsheet

  1. #1
    Join Date
    Jan 2013
    Posts
    3

    Link to excel spreadsheet

    Hello,
    I am an IT student looking at focussing on Artificial Intelligence, and to pass my course I am required to code my own program; for this program I've chosen to create a program that allows the kitchen I work in to track what stock they have, and how much they have left.
    For this I am going to input data into a spreadsheet, and create a program that allows you to select an item of stock from the spreadsheet, and then either add an amount of stock or retract stock. Would this be possible? and if so, could someone direct me in the correct direction. Although I'd like some help, I also want to work some of this out myself, so any help/ideas would be greatly appreciated.
    Thank you, Jordan.

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Would you be using a backend database to hold the actual inventory, or would you be doing all of this directly from one excel spreadsheet?

    Would this be a single or multi user application? If multi user, how many computers would it be running on and what kind of network would the spreadsheet reside on?
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  3. #3
    Join Date
    Jan 2013
    Posts
    3
    Just from a single excel spreadsheet, and a single user.

    Thanks for the speedy reply.

  4. #4
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Then this should be pretty simple. Do you have any experience in writing VBA code?

    How many individual stock items do you need to keep track off?
    What pieces of information do you need to store for each item?
    Do you need to maintain a history or are you just interested in keeping a "right now only" inventory?
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  5. #5
    Join Date
    Jan 2013
    Posts
    3
    I'm in the process of learning programming as part of my course, and as such have linked a Microsoft Access database storing usernames to a log in screen, which I believe is vba?

    Not too sure on the amount of items needed to be kept track of, but for certain will need product name, product code and supplier, and the amount in stock.
    Then when stock is low, convert said information into a .txt document to allow for easy ordering.

  6. #6
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    I would store everything in the database, not just usernames.

    Create other tables for your inventory, and use an Access Form as your front end. No need to get Excel involved at all.

    Since it is just a single user app, you don't even have to worry about contention issues.
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

Similar Threads

  1. Replies: 1
    Last Post: 08-22-2008, 01:00 PM
  2. Using an Excel spreadsheet from VB
    By anonymous in forum VB Classic
    Replies: 3
    Last Post: 05-19-2003, 07:14 AM
  3. VB and an Excel Spreadsheet
    By Dale Boyer in forum VB Classic
    Replies: 6
    Last Post: 01-29-2001, 12:57 PM
  4. VB and an Excel Spreadsheet
    By Dale Boyer in forum VB Classic
    Replies: 0
    Last Post: 01-26-2001, 02:22 PM
  5. Excel Spreadsheet
    By Kent in forum C++
    Replies: 1
    Last Post: 01-22-2001, 07:14 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center