Sudden Excel issues after Office 365 update

[Keebellah]

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

[Winon]

Hello Keebellah,

Please refer to you signature. LOL

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

[Keebellah]

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

[Keebellah]

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

[Keebellah]

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