Cell Contents to identify source Filename

  • Thread starter Thread starter ThalesNate
  • Start date Start date
T

ThalesNate

Hi, all

I'm trying to build a macro that will allow users to input fil
locations, I'm having a hard time getting the macro to substitute cel
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. Wit
that accomplished, users can identify their source files withou
rooting around in the code. This can't be too hard, can it?

Thanks,

Nat
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Trigger Macro by Worksheet_Change 5
Add a input box to ask for a filename to macro 1
Error 1004-application or object error 9
How to change a Macro based on content of a cell 3
Put Filename Variable in Macro 4
Save spreadsheet using cell values as filename 1
Macro that uses a cell value to copy another cell 3

Back
Top