Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jun 2015
    Posts
    26
    Thanks
    7
    Thanked 4 Times in 4 Posts

    Kingsoft Office Pro VBA compatible with MS Excel 2003 VBA?

    Kingsoft Office Professional (Paid version) has its own VBA version that is supposed to be compatible with MS VBA.

    Has anyone run a MS Excel 2003 VBA macro program in Kingsoft Office Professional Spreadsheets program?

    How compatible is Kingsoft VBA? Do you have to rewrite a lot of code to get the Excel VBA macro to work?

    I'm interested to know what other people's experience has been, before bothering to download the free 30-day trial version of Kingsoft Office Professional with VBA.

  2. #2
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    Do you currently have Ecxel workbooks with Macros?

    The point of a 30-day free trial is for you to test our spreadsheets and macros to see if the will work. If it were me I would test my macros with the 30-day trial.

    Curious, have you looked into Office 365 Personal? You get the Office Professional Plus suite at a great price.
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  3. #3
    New Lounger
    Join Date
    Feb 2012
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I tried WPS Pro a few months ago and it crashed and burned on a very simple macro. They were supposed to notify me when they had rectified the problem. But as of yet, I have heard nothing.

    Woody

  4. #4
    Lounger
    Join Date
    Jun 2015
    Posts
    26
    Thanks
    7
    Thanked 4 Times in 4 Posts
    FYI for our readers: Kingsoft Office was renamed last year to WPS Office, based on the names of the component programs which make up the office suite -- Writer, Presentation and Spreadsheets. The current free version of WPS Office 2015 does not include their version of VBA. The Professional suite, available for $69.95, does include their VBA. There is a separate download for the VBA plug-in to activate VBA/Macro support in Spreadsheets.

    @Woody -- Which year version of WPS Office did you try?
    What may seem a simple macro program to you or I may in fact be quite complex. Did your macro involve multiple files of workbooks or a single file with multiple worksheets?

    When you stepped through the macro in WPS Spreadsheets, where did you receive an error message? Was it with a worksheet function? Or was it with a VBA function?

    What was the error message? Were you able to fix the macro by re-writing the code to Kingsoft VBA?

    Here is a link to a screenshot of the Kingsoft Visual Basic Editor:
    http://www.kingsoftstore.com/images/...-screen-01.png

    It looks like the Microsoft Visual Basic Editor. The window is even labeled Microsoft Visual Basic. I'm wondering what does it say under the Help menu About item.

    My question: "Is this Microsoft VBA? If not, how compatible is Kingsoft VBA with MS VBA?"

  5. #5
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    The VBA editor and the VBA runtime engine are not the same thing.


    In Office 2003, all the application that have VBA (called Macros in some products) all share the same VBA Edits. It is also used by Visual Basic 6. Each application executes the VBA code. The way the VBA code is executed is not shared.

    My question: "Is this Microsoft VBA? If not, how compatible is Kingsoft VBA with MS VBA?"
    Microsoft used to license VBA to other software companies. The core of the Visual Basic Language is the same. The object model would be added based on their own Application (The A in VBA) Things Like If .. Then .. Else are the same in all flavors of VBA and VB6.

    What is different in each flavor of VBA is the A or Application object model. In Excel you have Sheets(), in Word you have Documents().

    How compatible Kingsoft Office/WPS Office is with the Excel VBA Object model will depend on how well the programs can recreate all object model's functionality. If they can duplicated it then it should be able to run VBA code created in Excel. Sounds like a huge task.
    Last edited by HiTechCoach; 2015-09-05 at 12:52.
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •