Selecting filename in cell from file browser
I have an Excel spreadsheet that a user needs to fill out with meta
data and also attach a hard drive link to a document. Is there a way in Excel to pull up a file explorer window to pick files from their or network drives, select the filename, and place that in the cell? Secondly, is there a way to physically copy that file to the same location as the spreadsheet when they do this? Thanks for the help in advance. JR |
Selecting filename in cell from file browser
John,
Check out the GetOpenFileName method. Filename = Application.GetOpenFilename For copying the file, check out the CopyFile method. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "John" wrote in message om... I have an Excel spreadsheet that a user needs to fill out with meta data and also attach a hard drive link to a document. Is there a way in Excel to pull up a file explorer window to pick files from their or network drives, select the filename, and place that in the cell? Secondly, is there a way to physically copy that file to the same location as the spreadsheet when they do this? Thanks for the help in advance. JR |
All times are GMT +1. The time now is 09:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com