I tried the CALL excel 4.0 macro sheet and it didn't work either. In other words, it works fine in Excel 2011, but not Excel 2016. If this can be solved, then I'll let everyone have my routine for loading bitmap files in userforms at runtime. Is there any way to call DLLs in Office 2016? Private Declare Function GetDC Lib "Applications:Microsoft Office 2011:Office:amework:MicrosoftOffice" _Ĭalling GetDC in Excel 2011 works fine but in 2016 it says the file is not found. Private Declare Function GetDC Lib "Applications:Microsoft Excel.app:Contents:Frameworks:amework:MicrosoftOffice" _ While I can open this file with VBA the API calls say that this is file is not found even though it exists (and it is in Excel's sandbox area). The equivalent file for Excel 2016 seems to be inĪpplications:Microsoft Excel.app:Contents:Frameworks:amework:MicrosoftOffice However, I think the sandbox is becoming a problem in Office 2016. I used these to write a routine to load a picture into a userform at run time (YES - at runtime). Despite the nay-sayers, the Windows APIs are available in:Īpplications:Microsoft Office 2011:Office:amework:MicrosoftOffice
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |