Thread: VBA Excel method Not working
View Single Post
 
Old 01-07-2022, 11:19 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Shouldn't those forward slashes be back-slashes?
I don't think Excel will recognise xlsm as a fileformat. Try either xlOpenXMLWorkbookMacroEnabled or 52 or miss it out altogether.
Reply With Quote