Hello,
I created different subroutines in different modules and use variables such as
dim x as excel.application
xn = “fn1.xlsx”
Set wb = x.workbooks.open(p,false,false)
Then I created these variable for another excel file in different module.
xn = “fn2.xlsx
I get ambiguous name detected wb, x, xn etc. how do I resolve this ?