PDA

View Full Version : Enabling Content in access db with Excel VBA



dilipramadas
06-03-2016, 04:25 AM
Hi,

I need some help on a macro, I’m almost done with it. But there are a few things which are not working as per my requirements.
By using an excel sheet form I’m sending the data from excel to access(linked to SharePoint) saved in a shared drive which in turn will push the data to SharePoint. After updating the database, it will send a mail to someone based on a cell reference.

Problem: it works in my PC but not in anyone else’s PC. Yesterday we did a screen share session and tested it with an onsite user. The mail was triggered but the data didn’t get pushed to the database. What am I doing wrong in this entire macro?

Any help is good enough for me!

Please let me know if I should I post the VBA code I've 3 modules. (Since I'm a newbie to VBA, I like to create multiple modules to know what went wrong and where)