Excel VBA to activate Powerpoint window by name -


i have macro in excel transfers data excel tables in powerpoint file. macro runs smoothly on computer, but, when had colleague try on his, gets run-time error '5'

the error gets thrown portion of code:

vba.appactivate (dir(sfilename)) 

sfilename defined right before file in shared folder on our network.

is there better method of switching between specific excel window & specific powerpoint window?

or, know might causing difference in macro's ability run on laptop vs coworkers? both have windows10 & office 2016.

thanks,


Comments

Popular posts from this blog

php - Embed BBCode within itself not working -

three.js - how to load gltf in three JS -

sql server - T-SQL: Access DB objects in same schema without qualifying? -