As in talking to a PLC from an Excel spreadsheet? That's what I think of when I think VBA. And if that is the question, I recommend using AdvancedHMI. Much simpler.
yes i want to load a parameter file's in a view SE screen when there is a change of equipment ... i have 180 equipments those values has to be changed based on the parameter file changing as we do in button touch -> parameter file .