Have you looked at import-excel (powershell)? I’m guess if you’re at the VBA level it’s probably too primitive, but thinking of ideas.