Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening and Naming Files
Ed, I've tried this. It is the ideal solution I'm looking for, but I encoded
the application on Windows 7, and when I transferred it to my Vista Laptop, I got a runtime error 1004: '..\Desktop\403.csv' could not be found. It is on the local desktop. What could be wrong? Jim "Ed Ferrero" wrote in message ... This will work for any user, no need to get the user name Workbooks.Open Filename:="..\Desktop\403.csv" But if you really want to manipulate strings UserName = Range("G5").Value strPath1 = "C:\Users\" strPath2 = "\Desktop\403.csv" strFileNamePath = strPath1 & UserName & strPath2 Workbooks.Open Filename:=strFileNamePath Ed Ferrero www.edferrero.com "Jim Berglund" wrote in message ... I want to be able to open a file from any users desktop. From my desktop, the command is Workbooks.Open Filename:="C:\Users\Jim\Desktop\403.csv" How do I automate this, using UserName = Range("G5").Value So that if the user enters 'Dave' into G5, the code line will change to Workbooks.Open Filename:="C:\Users\Dave\Desktop\403.csv" ? Thanks, Jim Berglund |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening and Naming Files | Excel Programming | |||
Naming files | Excel Programming | |||
Creating and Naming a Folder and populating it with files | Excel Programming | |||
intersection naming transport between files | Excel Discussion (Misc queries) | |||
VBA - Looping thro same naming files in 2 directories........PLEASE HELP | Excel Programming |