James bolton
Member
Hi all,
I recorded a macro that enables my team to upload a text file from the desktop to the cell A2 and below (all within the same column) however - the macro looks for the file address which is specific to my C drive location C:\Users\MyUsername\Desktop.Filename.txt
I want my colleagues to be able to use the same excel tool, is there a piece of code you could share with me that could fix this, maybe by creating an prompt for a file upload - and an extra validation to ensure the file is always .txt would be even better, maybe even a filename validation so that the file is always filename.txt and .txt format.
I'm debating whether or not to just use a shared drive but I would be interested to see the code nonetheless.
Many thanks.
__________________________________________________________________
I recorded a macro that enables my team to upload a text file from the desktop to the cell A2 and below (all within the same column) however - the macro looks for the file address which is specific to my C drive location C:\Users\MyUsername\Desktop.Filename.txt
I want my colleagues to be able to use the same excel tool, is there a piece of code you could share with me that could fix this, maybe by creating an prompt for a file upload - and an extra validation to ensure the file is always .txt would be even better, maybe even a filename validation so that the file is always filename.txt and .txt format.
I'm debating whether or not to just use a shared drive but I would be interested to see the code nonetheless.
Many thanks.
__________________________________________________________________
Mod edit : post moved to appropriate forum …
