Find Jobs
Hire Freelancers

Excel VBA Inventory Management in the Cloud Project

$15-25 USD / hour

Cancelled
Posted about 10 years ago

$15-25 USD / hour

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). [login to view URL] 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: [login to view URL] If anyone thinks they might have some ideas give me a quote and PM me. thanks
Project ID: 5810882

About the project

3 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
3 freelancers are bidding on average $20 USD/hour for this job
User Avatar
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 wanted me to build a full blown subscription-based Web system they could use to sell their service. I can provide you with samples and logins for various systems to test out or do a demo over Skype or Teamviewer. I believe if you want to take it to the cloud, you should build a system on top of it, not just utilize scripting languages and spreadsheets. Give me a chance to discuss this further, and to understand what are your requirements and vision for your inventory management app. Looking forward hearing from you Boris
$23 USD in 40 days
5.0 (3 reviews)
5.2
5.2
User Avatar
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 similar project of Inventory management system for local store, that i'm familiar with it. All the computations could be done with the vba and with use of complex dialog boxes we can add certain visual effects also to it. Indeed sir I don't have the sound knowledge of cloud computing but i'm looking forward to it as if the app send the data(Bar code) to the PC (say via Bluetooth) then we can make necessary amendment to take data from that source . with regards, KevsT
$17 USD in 8 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Gates Mills, United States
5.0
20
Payment method verified
Member since Jun 15, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.