How to run a vba macro for multiple excel files -

How to run a vba macro for multiple excel files -

i naive user of vba , looking vba macro next task

delete 3 tabs file , delete first 6 rows remanining tabs. perform excel files (2013) , save xlsx in same or different file folder.

i tried code available on link run same excel macro on multiple excel files

at line filename=dir(pathname & "*.xlsx") , getting error says run time error "52" bad file name or number.

i have changed this:

pathname = "\c:\users\desktop\test\try\"\

is correct?

not sure if it's problem,

\c:\users\desktop\test\try\

should

c:\users\desktop\test\try\ (without first backslash)

*i realize should comment--i'm under 50 rep, however.

excel excel-vba