I'm writing a program that will be ran on a network, and my code pulls files from my computer and outputs files to the same directory. Can someone give me some sample code that can extract a file path in a cell without opening up a file dialogue box?
I'll assume that no one else so far has attempted to give an answer because what you're asking sounds so simple that they assume that there must be more to it.Can someone give me some sample code that can extract a file path in a cell without opening up a file dialogue box?
I can only assume that you need something more than:
If there was a file path in cell A1, now there is a file path in the variable sPath.
Please Login or Register to view this content.
I think he wanted the folder file path...
Try this, I've used this to pass the "path" to a string variable. You could easily output the string variable to a cell in the workbook if that is what you want to do. Take advantage of the difference in the fullname and name of a workbook.
myPath = Left(ThisWorkbook.FullName, Len(ThisWorkbook.FullName) - Len(ThisWorkbook.Name))
You could also assign the value directly to a cell if you're some kind of extra variable hating type
thisworkbook.worksheets("someSheet").cells(i,j).value = Left(ThisWorkbook.FullName, Len(ThisWorkbook.FullName) - Len(ThisWorkbook.Name))
Last edited by GeneralDisarray; 05-30-2012 at 10:07 AM.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
This was exactly what I needed! I knew it had to be pretty simple, but I'm EXTREMELY knew to programming with VBA. Thanks for your help!Originally Posted by StevenM
I'll assume that no one else so far has attempted to give an answer because what you're asking sounds so simple that they assume that there must be more to it.
I can only assume that you need something more than:
If there was a file path in cell A1, now there is a file path in the variable sPath.Please Login or Register to view this content.
To: GeneralDisarray,
In that case why not:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks