Vikram Shankar Mathur (vsm.link)

vikramshankarmathur.link

vikramshankarmathur.link

Here’s a concise summary of the contents of [vikramshankarmathur.link] for the blog:

1. Professional Background: Vikram Shankar Mathur is a Chartered Accountant based in Ahmedabad, Gujarat, India, specializing in accounting, auditing, tax consultancy, and financial advisory[https://www.vikramshankarmathur.link/p/about-author?citationMarker=43dcd9a7-70db-4a1f-b0ae-981daa162054 "1"].
2. Technical Expertise: The firm has expanded into VBA and Python programming, offering advanced Excel and VBA solutions since 1995[https://www.vikramshankarmathur.link/?citationMarker=43dcd9a7-70db-4a1f-b0ae-981daa162054 "2"].
3. Business Philosophy: Their motto is _"Our work starts where your problems lead to,"_ emphasizing precision and customer-focused solutions[https://www.vikramshankarmathur.link/?citationMarker=43dcd9a7-70db-4a1f-b0ae-981daa162054 "2"].
4. Firm Evolution: Initially founded as Vikram S. Mathur & Co., it merged with Kartik T. Vayeda & Co. in 2012, integrating financial expertise with technical training[https://www.vikramshankarmathur.link/?citationMarker=43dcd9a7-70db-4a1f-b0ae-981daa162054 "2"].
5. Future Outlook: The firm aims to adapt to evolving technological trends, ensuring continued relevance in financial and programming services[https://www.vikramshankarmathur.link/?citationMarker=43dcd9a7-70db-4a1f-b0ae-981daa162054 "2"].
6. Contact & Location: Based in Bodakdev, Ahmedabad, with contact details available for inquiries[https://g.page/r/CUfq4NvPxio7EAE/?citationMarker=43dcd9a7-70db-4a1f-b0ae-981daa162054 "3"].

===== AI Generated Content =====

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 Mathur
Posted:    24-Sep-2019 | 12:55 Hours IST
Updated: 17-Dec-2024 | 18:33 Hours IST
=================================

[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: B-404, Shashwat Flats,     Atithi Dining Hall Lane,     B/h GNFC INfotower,     Adj. AUDA Garden, Zanzarwadi Road,     Bodakdev, AHMEDABAD-380054.     Cell: +91-9998090111 / +91-8460890111     Email: vsmathurco@gmail.com | exceltrainerahmedabad@gmail.com     Email: vikramsmathur@gmail.com     Web: http://vbacoder1962.wordpress.com/vba-excel.htm