Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Contents to identify source Filename
Hi, all I'm trying to build a macro that will allow users to input file locations, I'm having a hard time getting the macro to substitute cell contents for a hard-coded string. I have this: Workbooks.OpenText Filename:= _ "S:\Departments\Shop Public\Support\stats_liste_MvtStock.txt" _ I would like to instead have something like this: Workbooks.OpenText Filename:= _ "cell(D6)" _ In this case D6 would contain the file address on the network. With that accomplished, users can identify their source files without rooting around in the code. This can't be too hard, can it? Thanks, Nate -- ThalesNate ------------------------------------------------------------------------ ThalesNate's Profile: http://www.excelforum.com/member.php...o&userid=31037 View this thread: http://www.excelforum.com/showthread...hreadid=549610 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Contents to identify source Filename
Try
Workbooks.OpenText Filename:=Worksheets("Sheet1").Range("D6").Value -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ThalesNate" wrote in message ... Hi, all I'm trying to build a macro that will allow users to input file locations, I'm having a hard time getting the macro to substitute cell contents for a hard-coded string. I have this: Workbooks.OpenText Filename:= _ "S:\Departments\Shop Public\Support\stats_liste_MvtStock.txt" _ I would like to instead have something like this: Workbooks.OpenText Filename:= _ "cell(D6)" _ In this case D6 would contain the file address on the network. With that accomplished, users can identify their source files without rooting around in the code. This can't be too hard, can it? Thanks, Nate -- ThalesNate ------------------------------------------------------------------------ ThalesNate's Profile: http://www.excelforum.com/member.php...o&userid=31037 View this thread: http://www.excelforum.com/showthread...hreadid=549610 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get a number or letter to represent cell contents? | Excel Discussion (Misc queries) | |||
Using contents of a cell in a formula | Excel Discussion (Misc queries) | |||
cell contents | Excel Discussion (Misc queries) | |||
Insert value of a cell as a filename | Excel Worksheet Functions | |||
Display actual contents of cell | Excel Discussion (Misc queries) |