Grouping common file address into a string

[alexnkc]

Hi

Below are my current macro which work fine for me. I find out that the disadvantage was when the file location was change, I need to change the strDataOnePath and strDataTwoPath adress one by one.

Please Login or Register  to view this content.

Therefore, I try to group up the common address (which the code show below). I believe it will be much more easy to edit the file location if the file location been change. However, below code is not working. Please help

Please Login or Register  to view this content.

Best regards,
KC

[hectop]

What exactly is the problem with the code? The difference between the two sets is that you've added " ' " between the path & Sheetx.

[millz]

Please Login or Register  to view this content.

[jindon]

Is this how you wanted?

Please Login or Register  to view this content.

[alexnkc]

Hi jindon,

Thanks for helping. Code that you share is not workable for me.

Hi millz,

Thanks for helping. Your code is working Great for me.

Please Login or Register  to view this content.