Share via

MS Visual Basic function - unable to open in Excel file

Giridhara Shriyan 1 Reputation point
2022-09-23T02:54:55.29+00:00

244075-ms-visual-basic-for-applications-excel.jpg

MS Visual Basic function - unable to open in Excel file

Developer technologies | Visual Basic for Applications
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 40,086 Reputation points MVP Volunteer Moderator
    2022-09-23T14:29:48.163+00:00

    Such errors are common when switching from 32-bit to 64-bit version of Office. You must then update the declarations of API calls such as ShellWait. Search your application for the "Declare" statement and read up on how to convert them using the PtrSafe attribute.

    0 comments
  2. Giridhara Shriyan 1 Reputation point
    2022-09-26T02:40:06.267+00:00

    Thanks, I have updated the Declaration for the ShellWait module with private declaration PtrSafe. Macro functions now.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.