Search This Blog

Tuesday 24 September 2019

An interesting feature of Microsoft Excel 2016

ZIP AND UNZIP FROM MICROSOFT EXCEL USING VBA

Indeed one of the most interesting features that has me quite excited, although I have not quite figured out how exactly to use it to my best advantage is the capability built into Microsoft Excel’2016 (do not try it in any other version below 2010, however) is that you can zip and unzip any .zip extension from within Excel. Just see the pictures below; I am not saying how useful it is exactly, until I try it out in depth myself, but you are allowed to put in your comments on how best you have used it to date.

Yes, it is true that you have to use VBA to do any of this, but the basic code is given in the picture – it comes from the book I recently purchased from amazon.in called “Excel 2016 Power Programming with VBA” by Michael Alexander and Dick Kuleska (Wiley Publications). Here is the module that unzips a file to the targeted directory:
‘===============================
’Module m_UnZipAFile.bas
’===============================

Sub UnzipAFile()
     Dim ShellApp As Object
     Dim TargetFile
     Dim ZipFolder

'   Target file & temp dir
     TargetFile = Application.GetOpenFilename _
         (FileFilter:="Zip Files (*.zip), *.zip")
     If TargetFile = False Then Exit Sub
    
     ZipFolder = Application.DefaultFilePath & "\Unzipped\"

'   Create a temp folder
     On Error Resume Next
     RmDir ZipFolder
     MkDir ZipFolder
     On Error GoTo 0

'   Copy the zipped files to the newly created folder
     Set ShellApp = CreateObject("Shell.Application")
     ShellApp.Namespace(ZipFolder).CopyHere _
        ShellApp.Namespace(TargetFile).items

    If MsgBox("The files was unzipped to:" & _
        vbNewLine & ZipFolder & vbNewLine & vbNewLine & _
        "View the folder?", vbQuestion + vbYesNo) = vbYes Then _
        Shell "Explorer.exe /e," & ZipFolder, vbNormalFocus
End Sub

=================================
Happy Programming !!
CA Vikram Shankar Mathur24-Sep-2019 | 12:55 Hours IST

Saturday 7 September 2019

vbacoder1962.com

www.vbacoder1962.com

CA Vikram S. Mathur (vbacoder1962)
vbacoder1962.wordpress.com
vbacoder1962.wordpress.com
========================================================================================
RSS FEED
=======================================================================================
<title>The Google Assistant comes to more devices at home</title>
<link>
https://www.blog.google/products/assistant/google-assistant-comes-more-devices-home/
</link>
<description>
<html><head></head><body><div class="block-paragraph"><div class="rich-text"><p>With the Google Assistant, we’re helping you get things done around the house—whether your hands are full in the kitchen, you’re too tired to get up from the couch after a long day or you’re rushing to get out of the door. Just ask the Assistant to play your favorite show, turn off the lights, arm your security system, pre-heat the oven or set the thermostat to 72 degrees. So you can use the Assistant on a device that works best for you and your family, we’re at IFA 2019—one of the largest trade shows for consumer electronics and home appliances—to highlight the partners that have brought the Assistant to new speakers, phones, headphones, TVs, and smart home appliances. </p><p><b>Making your Android phones and tablets more helpful in the home </b></p>While your mobile device is charging on a nightstand, living room table, or kitchen counter, it can still help you stay on top of your day. Google Assistant's Ambient Mode is a new visual overview that makes it easier to see notifications and reminders, start a playlist and control smart home devices on the lockscreen of your device. When you’re done, your screen will turn into a personal digital photo frame linked to your Google Photos account to add another personal touch. Ambient Mode will be available on the upcoming Lenovo™ Smart Tab M8 HD (when placed in its smart charging station) and Lenovo Yoga™ Smart Tab (when you pop out its handy kickstand), as well as when you start charging your new Nokia 7.2 and 6.2.</div></div><div class="block-image_full_width"><div class="article-module h-c-page"><div class="h-c-grid"><figure class="article-image--large h-c-grid__col h-c-grid__col--6 h-c-grid__col--offset-3 "><img alt="Ambient Mode gif" src="https://storage.googleapis.com/gweb-uniblog-publish-prod/original_images/E000_Ambient_Mode_Tablet_INT_2.gif"/><figcaption class="article-image__caption "><div class="rich-text"><p>Introducing the Google Assistant’s Ambient Mode</p><p><br/></p></div></figcaption></figure></div></div></div><div class="block-paragraph"><div class="rich-text"><p>The Assistant already <a href="https://www.blog.google/products/assistant/hey-google-whats-new-assistant-ces-year/">works with popular messaging services</a>to help you read and send messages. Now you can make hands-free audio and video calls with the Assistant starting in the WhatsApp Android app. Just say, “Hey Google, WhatsApp video John.” </p><p><b>Find the Assistant on portable smart speakers and Smart Displays, new TVs and headphones</b><br/></p><p>A few months ago, we brought the Assistant to your <a href="https://www.blog.google/products/assistant/google-assistant-your-sonos-system-gets-even-smarter/">Sonos</a> and <a href="https://www.blog.google/products/assistant/bose-speakers-get-smarter-google-assistant/">Bose</a> speaker systems for the first time. They’re now available in the U.S., U.K., Germany, Canada, France, Australia and The Netherlands, with more countries to come before the end of the year. Even better, the Assistant will be available to help you anywhere in the house and the backyard, with new battery-powered smart speakers, like the Sonos Move, Bose Portable Home Speaker, and JBL Link Portable. </p><p>And so you can pick an entertainment experience that fits best for you, this week the Assistant is coming to a wide range of new voice-activated speakers and soundbars, including the JBL Link Music, Phillips AW25 and TAPN805 (soundbar), Konka G1, SEIKI Tough and Cigar, high fidelity Braun Audio LE01, LE02 and LE03. We’re also expanding the Assistant to more Android TVs from top brands, including Hisense, Sony, TCL, Philips, Changhong, Haier, Skyworth, Metz, Vestel, Sharp, JVC , XGIMI Projector, RCA and SmartTech. </p><p>Meanwhile, we worked with Lenovo to announce a new 7-inch Smart Display that has been redesigned to fit in smaller spaces in your house. The <a href="https://news.lenovo.com/pressroom/press-releases/smart-home-innovation-smart-display-yoga-smart-tab-m8-google-assistant/">Lenovo Smart Display 7</a> comes with all of the Assistant visual features you expect on a smart display for controlling connected devices or catching up on the news and will be available next month in select European countries and will roll out to more markets over time. The recently launched <a href="https://www.blog.google/products/assistant/rise-and-shine-new-alarm-clock-features-assistant/">Lenovo Smart Clock</a> will be expanding to new countries around the world, including Spain, Norway, Denmark, The Netherlands and Sweden, to help improve your bedtime and morning routines. </p><p>More Assistant-powered headphones are also on the way, including the JBL LIVE300 TWS, Harman Kardon FLY ANC, Bose NC700, Cleer Flow II and Halo, Phillips PN505 and PH805, and Sony WI-1000XM2 and WH-H910N. When you pair them to your phone, you can talk to the Assistant instantly with just a touch of the button on the headphone, whether you want to skip a track to hear the next song, listen and respond to your messages, or set reminders.<br/></p><p>Together these new Assistant-powered devices, along with Google Nest product, lets you easily control all the connected devices in your home, from lights, to thermostats, appliances, all in one simple place. This week, the Assistant will be supported in <a href="https://www.home-connect.com/global">Home Connect</a> to work with home appliances, like dishwashers, washers, dryers, hoods, and vacuums, from brands Bosch, Siemens, Neff, Thermador and Gaggenau. You can also upgrade your kitchen with the Assistant with the upcoming Electrolux Oven and Liebherr SmartDevice. The Bosch SmartHome Plug, Thermostat and Light, as well as the Nuki Smart Lock and door opener, will also work with the Assistant.</p><p>With the Assistant now available in more than 30 languages and 80 countries, and all these new devices, you have even more ways to get help, whether you're at home on the go.</p><br/><br/><br/><br/><br/></div></div></body></html>
</description>
<pubDate>Thu, 05 Sep 2019 18:30:00 -0000</pubDate>
<guid>
https://www.blog.google/products/assistant/google-assistant-comes-more-devices-home/
</guid>
<category>Google Assistant</category>
<media:content url="https://storage.googleapis.com/gweb-uniblog-publish-prod/images/STORYBOARD_08_2019_07_16_HM.4344322686884609.max-600x600.jpg" width="540" height="540"/>
<og xmlns:og="http://ogp.me/ns#">
<type>article</type>
<title>The Google Assistant comes to more devices at home</title>
<description/>
<image>
https://storage.googleapis.com/gweb-uniblog-publish-prod/images/STORYBOARD_08_2019_07_16_HM.4344322686884609.max-600x600.jpg
</image>
<site_name>Google</site_name>
<url>
https://www.blog.google/products/assistant/google-assistant-comes-more-devices-home/
</url>
======================================================================================= 

Monday 2 September 2019

[02.09.2019]-First Post


Software

VISUAL BASIC FOR APPLICATIONS
We have been doing programming in the Visual Basic Editor (VBE) provided by default in all versions of Microsoft Office since Office’2000, especially in Microsoft (MS) Excel and Access. The details of this expertise are too technical to be mentioned on this page alone, but essentially we use Class Modules, Code Modules and Userforms in the Visual Basic for Applications (VBA) environment to suit the purpose of the final program.
EXCEL SPREADSHEET – ADVANCED FORMULAE
For instance, we have created a Cashbook program that only handles the Cheque Payment Voucher in one separate worksheet and it’s listing on another worksheet. Another instance of the pure programming using advanced formulae is the Cheque Mapping Software developed by us 10 years ago for handling the outsourcing of Cheques received for the Loans Department of a high-profile International Bank operating all over India, but for the city of Ahmedabad only.



What is VBA-Excel About?

We have been programming the Visual Basic for Applications as the back-end of Microsoft Office 2000 / 2007 and 2013) as well as the versions before that also since the year 2000, so we have been effectively  programming in this environment for more than 15 years now. Basically, in all these years, there was no commercial exploitation being done of these capabilities, which essentially began as an extension of the Macro-Programming available in Lotus 1-2-3. However, as on date, there is a lot more being done in this area by us than just macros! We are basically OOP (Object Oriented Programmers) and our biggest strength is that we are a Chartered Accountancy firm who provides these services mainly to our own clients.

Contact Us

We can be contacted at the address given at the foot of this page, where an office exists for the rest of the times other than those specified below:

OFFICE ADDRESS:
A-107, Doctor House,
Above Parimal Railway Underpass,
Off Chimanlal Girdharlal Road, Ellisbrige,
AHMEDABAD-380006, Gujarat, INDIA
Cell: +91-9998090111 / +91-8460890111
Email: vsmathurco@gmail.com | vsmathur@vsmathur.co.in

Phone: +91-79-26462131
Email: vsmathur@vsmathur.co.in
Web: http://vbacoder1962.wordpress.com/vba-excel.htm