{"id":8045,"date":"2015-09-25T20:57:00","date_gmt":"2015-09-25T20:57:00","guid":{"rendered":"http:\/\/tayosolagbade.com\/sdnuggets\/?p=8045"},"modified":"2015-09-25T20:57:00","modified_gmt":"2015-09-25T20:57:00","slug":"excel-vb-apps-can-be-made-networkable-to-enable-you-remotely-view-generate-timely-reports-for-decision-making","status":"publish","type":"post","link":"http:\/\/tayosolagbade.com\/sdnuggets\/excel-vb-apps-can-be-made-networkable-to-enable-you-remotely-view-generate-timely-reports-for-decision-making\/","title":{"rendered":"Excel-VB Apps Can be Made Networkable, to Enable You Remotely View & Generate Timely Reports for Decision Making"},"content":{"rendered":"

I've recently noticed a gradual increase in the number of enquiries I'm getting from online prospects, about my Excel-VB Poultry Farm Manager app<\/a>.<\/p>\n

Interestingly, more of them now ask if the app can work across an intranet. In other words, for those who have a network of interconnected offline PCs, or those who use apps that send and receive live updates via the web, the Farm CEOs ask me if my app offers similar functions.<\/p>\n

Now, I could be wrong, but the more I get asked this question after I answered someone else not too long ago, in the affirmative, the more I cannot help feeling that the same people are the ones coming back through proxies to ask me the same question again.<\/h3>\n

Why would they do this?<\/p>\n

Well I suspect it's the same reason some of my past clients did so. Knowing that my app is built using MS Excel, which is NOT designed to be multi-tasking, they find it hard to imagine how ONE app like mine can possibly be used at the same time on multiple terminals across a network.<\/p>\n

Rather than argue, I will simply tell the reader that I have done it more than once, and for GOOD pay too. Way back in paid employment I developed a Training Records Database application for use by departmental heads across the brewery via the intranet.<\/p>\n

Each head was able to launch the app from where I'd placed it on the server, using the shortcut I'd placed on their PC desktops. They then quickly\/easily generated training reports for individual employees in their departments, for printing.<\/p>\n

Now, despite the fact that the above happened, it was only good for VIEWING and report generation\/printing.<\/h3>\n

If data entry needed to be made, that had to be done by posting into the app on the server, and then advising ALL users to close and re-launch the app to view the latest updates.<\/p>\n

As you can imagine that option did not appeal to the CEO of a hotel I got invited to build a Hotel Records Management System (HRMS) for.<\/p>\n

In his case he wanted the different sections of the hotel where data recording happened (e.g. Accounts, Reception, and Bar\/Restaurant) to post their data as and when needed in a way that would promptly reflect in the report generation interface of the app, once it is REFRESHED.<\/p>\n

In my usual way, I thoroughly investigated the possible options available online until I found a perfect solution described by an Excel-VB developer named Pierre LeClerc.<\/p>\n

Even though his method did not suit the hotel's purpose, a little creative thinking quickly helped me develop an adaptation that did.<\/h3>\n

2 months later, I'd successfully trained the staff in the different hotel data entry sections, to use the app across the company's intranet.<\/p>\n

After overcoming the usual teething problems, they soon got up and running using the app. I still recall being asked by the CEO to call up the app on his laptop so he could view latest reports drawing from data being posted in the different sections.<\/p>\n

It is the same method I used for the hotel that I would use as a guide for developing a network-able version of my Poultry Farm Manager app.<\/p>\n

I cannot give details of how I would do it, but once completed, it would enable a Farm CEO readily access any latest posted data updates the staff may have done, from ANY terminal - including the web.<\/p>\n

If you're interested in using my Excel-VB driven Poultry Farm manager<\/a> across a network, click here to send me details of your needs<\/a>, and how you'd like me to help you.<\/h3>\n

In my response, I will send you a one page annotated diagram that depicts the approach conceived by Pierre LeClerc, which I modified to develop the HRMS mentioned above.<\/p>\n

Below is a small version of the diagram:<\/strong><\/p>\n

\"Click<\/a><\/p>\n

The larger version I will send to everyone who submits this web form<\/a>, will come with boldly written explanatory notes, labels and generic information.<\/p>\n","protected":false},"excerpt":{"rendered":"

I've recently noticed a gradual increase in the number of enquiries I'm getting from online prospects, about my Excel-VB Poultry Farm Manager app. Interestingly, more of them now ask if the app can work across an intranet. In other words, for those who have a network of interconnected offline PCs, or those who use apps […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,8,1375,133,266,10],"tags":[1931,1932],"class_list":["post-8045","post","type-post","status-publish","format-standard","hentry","category-employeescareer-persons","category-entrepreneurs","category-excel-vb-solutions","category-farm-biz","category-my-dn-travel-news","category-self-development","tag-excel-vb-apps-can-be-made-networkable","tag-to-enable-you-remotely-view-generate-timely-reports-for-decision-making"],"aioseo_notices":[],"views":963,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/8045","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/comments?post=8045"}],"version-history":[{"count":2,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/8045\/revisions"}],"predecessor-version":[{"id":8048,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/8045\/revisions\/8048"}],"wp:attachment":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/media?parent=8045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/categories?post=8045"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/tags?post=8045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}