Closed

VBA and Excel Access Collaboration

Hi ,

Please let me know the feasibility of doing this. I hope you are good in MS Access. The requirements as follows.

We have 26 sheets (23 Input sheets and 3 dashboards) that need to be interlinked.

We tried linking through a Master database file but it's taking very long time for macro to update the master after each file is updated

Create Access database with each table (sheets) linked by product ID and link each sheets to the appropriate tables in Access. I think this way access tables and excel sheets are updated in real time

So when you open the excel you it should fetch data from its access table in the mapped Access DB. And any change made in excel should be updated in the same table in the same Access DB.

And the access tables should be inter liked with unique Ids, so if one table is updated with the change made in its excel then all tables which are linked should be automatically updated. so when we open the excel file mapped to that table, the updated data should be obtained.

Please not the following.

Don't take long time for files to open/close/update

Allow multiple users using the files (at any point only one user will use the sheets but users can use different sheets at the same time. for example Malaysia Medical can be used while Malaysia Regulatory is used)

Skills: Excel, Visual Basic for Apps

See more: vba excel collaboration, ms access excel vba, excel vba db, excel malaysia, excel access vba, vba time, me vba, excel vba long, excel 2013 vba, master excel, vba excel, vba excel macro, VBA and excel, vba access excel, user inter, ms access vba, ms access 2013, Macro vba, Excel Macro VBA, collaboration, excel database visual basic, vba open access, vba update excel, access vba open, think vba

About the Employer:
( 0 reviews ) India

Project ID: #4349659

16 freelancers are bidding on average $231 for this job

Premshanks

Your suggestion wont it create circular reference? i.e., access tables linked to excel, and excel sheets linked to access?

$140 USD in 5 days
(70 Reviews)
5.0
djain01

Hi, I have done similar work.. Lets discuss more for your project., Thanks djain01

$1000 USD in 30 days
(14 Reviews)
4.4
diegogarcia0531

Hi, I can do the job, MS Access expert, software developer for a several years, Please refer to PMB for further details Regards Diego

$350 USD in 7 days
(10 Reviews)
4.3
nayabsiddiqi

can provide you the automated and linked solution in limited time.

$325 USD in 3 days
(6 Reviews)
3.7
JeffLee21

Expert VBA programmer

$250 USD in 6 days
(2 Reviews)
3.2
shagoon2u

Hello There, We are vba experts who are creating VBA Solutions integrating MS Access and MS Excel. Please share the files.

$199 USD in 5 days
(3 Reviews)
2.9
epdailo

I have done a similar process before so I believe I can help you. Please see my PM

$140 USD in 14 days
(2 Reviews)
2.2
srdas2012

Hi,We are VB/VBA/Access Expert is Doable but need to checked in Practical Environment Regarding time,Please check PMB

$250 USD in 5 days
(2 Reviews)
2.1
MarlinSoftware

Hi, I am a developer with over 22 years experience building complex database systems. Please see PM for further details.

$300 USD in 5 days
(1 Review)
1.8
ishant1501VBA

VBA expert here, I have done a similar project before. Please see my PM

$100 USD in 14 days
(0 Reviews)
0.0
sumanagg

i have 7 years of MNC corporate experience in working on excel and MS access. I promise to deliver the final solution in 3 days of getting the project.

$100 USD in 3 days
(0 Reviews)
0.0
acekumarvw

please check PM for offer details

$200 USD in 6 days
(0 Reviews)
0.0
ugurarikanfl

I am experienced in all Office programs and VBA. Currently I am giving MIS lectures at a university where I am teaching how to collaborate Office programs effectively, especially Excel and Access.

$140 USD in 3 days
(0 Reviews)
0.0
moallam

I have experience in developing software solutions to factories and electrical power stations. I am lunching my profile in this site, so I am giving max service with lowest price. I will develop you whatever you want a More

$30 USD in 7 days
(0 Reviews)
0.0
sorin1970

Good afternoon. I'd like attachments the works of interest

$140 USD in 14 days
(0 Reviews)
0.0
parama4u

I have 5 years of experience as a VBA Automation Programmer in MNC and working based on india. Ready to start.

$75 USD in 5 days
(0 Reviews)
0.0
darizkipratama

I'm a experienced VBA and office automation. Please send me the detail requirement and I'll do that

$100 USD in 3 days
(0 Reviews)
0.0