Macro not working correctly on different computer?

So I originally have a macro setup to distribute to other users that will open up a local file on a share drive, copy a vba module from that workbook, and paste it into the user's workbook. That macro works correctly after I had to make sure the users adjust their trust center settings to "Trust access to the VBA project object model."

Now I am running into a second issue when the users execute the macro that was copied into their file. The macro that was copied into their file executes upon saving their file and it pretty much creates a text file of their document. The code is below:

Please Login or Register  to view this content.

So there's 4 parts to this code:

1.) Removes any #REF errors from the tab
2.) Fills each column to the length of another column in a different tab
3.) Removes any zero amounts in two columns
4.) Creates a new workbook and copies this tab over to that new workbook. Then it filters for any blanks and removes those rows (this is necessary because some cells might have had formulas in them even though they were blank and copying and pasting as values doesn't "truly" make these cells blank). Then it saves the file as a text file

Now when I run the code on my computer, it runs correctly. However, when another user was testing this process, the text file created copied down the first row multiple times. Is there anything in my code that might signal why this would happen? Because the original tab in this person's file matches mine, but the text file created is different which does not make sense to me?

Is it possible that the Worksheets "Data Input" are not identical? If they were not, the value of EndRow could be different.

As a side note, you declared string variables named 'Path' and 'Name' but never gave them a value. Since both words have specific meaning in VBA, they may cause other problems...