Cancelled

Excel VBA Inventory Management in the Cloud Project

I have an excel vba project I built that is a basic inventory management program that does the following simple tasks

1) Click “edit inventory” button

2) User form pops up that says “scan barcode”, currently user scans barcode using scanner attached to pc

3) After they scan another userform pops up that says “enter qty”, user inputs qty

4) Then anther userform pops up with two buttons, “Add to inventory” or “Remove from Inventory”

5) When user clicks either one it takes the barcode from step 2, and looks it up in a different master inventory sheet and either adds or subtracts the qty entered in step 3 from the current stock qty for the item

What I was wondering was if there was some way to put this spreadsheet in the cloud or somehow make it available remotely so the user could use an iphone app to operate (use iphone as scanner). As far as the cloud option, I don’t think this can be done but Im not positive. I did some research and unfortunately Excel Online (office in the cloud) doesn’t let you do VBA. I did find that it may be possible to convert the vba project to google docs via googleappsscript (see link) but its not the same as excel and I have no clue how to do (may be interested in giving this a shot if someone knows how).

[url removed, login to view]

The other option I was thinking about was somehow using a remote access software like teamviewer to make it work.

Here is an app already built that could be useful: [url removed, login to view]

If anyone thinks they might have some ideas give me a quote and PM me. thanks

Skills: Cloud Computing, Excel, PHP, Visual Basic for Apps

See more: what was the, spreadsheet in html, remote excel, online barcode, inventory management ideas, how to find projects online, how to find a blogspot, how do you find an app, google docs vba, find software projects online, find php projects online, find master program, convert excel to html form, blogspot online, barcode online, app vba, what is vba in excel, what is vba, what is google docs, use excel online

About the Employer:
( 20 reviews ) Gates Mills, United States

Project ID: #5810882

3 freelancers are bidding on average $20/hour for this job

bldroid

Hi, I'm an expert software developer and have been working with several clients, particularly from Australia, UK and US who had similar system requirements. They had their own Excel spreadsheets with formulas and wa More

$23 USD / hour
(3 Reviews)
5.2
navaratantech

Dear Sir/Madam, I am Shyam Visamsetty and we are consultants for Google Apps and have helped various small/medium businesses deploy and use Google apps for their business. I am a senior Ruby on Rails/Javascript deve More

$21 USD / hour
(8 Reviews)
5.0
toxicman

Hello I'm a good developer in excel macro and scheme, I can create you system and put it google docs or put it in remote server and every one has user pass can access it, but better way is creating access version and More

$16 USD / hour
(11 Reviews)
4.1
KevsT

hi sir the project consist of the taking data from the bar code the data can be accepted by using the C executable file directly. The project is based on the Inventory management system using VB for Apps and I've done More

$17 USD / hour
(0 Reviews)
0.0