View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default Opening *.txt by code with varible path

Take a look at GetOpenFilename in VBA help.

--
HTH

Bob Phillips

"carloshernandezy" wrote in message
ups.com...
Hello to all,


I´m triying to open a *.txt file in a variable path and with a
variable name.


C:\.....\year\weekXX\

After opening the select dialog box I select the *.txt file and convert
with comma delimiters.



-year- is the value of a cell in worksheet
-weekXX- is the value of a cell in worksheet


Thanks for your help