+ Reply to Thread
Results 1 to 5 of 5

Sudden Excel issues after Office 365 update

  1. #1
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Sudden Excel issues after Office 365 update

    Hi, I think this is serious.
    I also posted this same question here, but would like to know if others have encountered subbed issues with Excel these last 10-12 days:
    https://www.myonlinetraininghub.com/...5-update#p8953


    Hi this is a general question about 'sudden' issues some users are running into after the latest Office 365 update. The reaso I know it's due to this is because one of the people I wrote an Excel application was using it yesterday without problems and her PC was updated early this morning and it no longer works.

    It happens when the shell command is run that I use to list a number of files to a temporary file written to the user's temp folder:

    Please Login or Register  to view this content.
    You can rest assured that the variables are all correct and when I run it directly from the command prompt no problem but in the VBA code if fails

    The first line KILL works, the file is removed, but the Call Shell line throws the error

    The Error message is Error 5 invalid procedure or invalid argument (freely translated from the Dutch message box

    Apart from that, but of course not everything can be tested now it seems it runs Okay,

    Have any of you encountered problems since let's say a week or two?

    I asked their network engineer to look at it and he noticed that the Office updates started March 29 and it was just her system that was updated this morning

    I'me very curious and worried, I did not read anything on any blog or site about Office 365 modifications to the good old MS-DOS commands

    Will need to write an alternative code for it
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Sudden Excel issues after Office 365 update

    Hello Keebellah,

    Please refer to you signature. LOL

    "May the (vba) code be with you... if it isn't; start debugging!"
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Sudden Excel issues after Office 365 update

    LOL, but this is serious, I asked a friend to test something for me, he runs both Office versions, 365 and 2016 and 2016 works tops 365 ERROR so yes.
    I guess Microsoft will need to read my signature too

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Sudden Excel issues after Office 365 update

    PS I just posted the same question of the Microsoft Community site
    https://answers.microsoft.com/en-us/...=1554236013787

  5. #5
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Sudden Excel issues after Office 365 update

    This is the full code.
    GetProjectlogBestanden is the modified version that I rewrote so that it works
    GetProjectlogBestanden2 is the original code that fails with Office 365 Business

    Please Login or Register  to view this content.
    Both Functions return an Array if files are found

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 06-14-2018, 03:27 PM
  2. Conditional formatting with udf issues with Office 2016 / Office 365
    By andikeep2580 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-22-2016, 10:58 AM
  3. Update from Office 97 to Office Professional Plus 2016
    By billd73 in forum Excel General
    Replies: 0
    Last Post: 12-28-2015, 05:15 PM
  4. [SOLVED] Office SP2 update causes Excel automation crash!
    By Rob Schripsema in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-27-2006, 08:20 PM
  5. [SOLVED] Office SP2 update causes Excel automation crash!
    By Rob Schripsema in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2006, 06:16 PM
  6. [SOLVED] how do why update my Excel microsoft office
    By sam in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-16-2005, 02:05 PM
  7. Replies: 0
    Last Post: 03-05-2005, 07:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1