Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Im trying to write a macro to prompt a user to select a file and then open it.
This is the link to the file that I keep trying: C:\Documents and Settings\All Users\Documents\Coop Students\Small Package Rates\UPS rates\2006\Air\ The file is then in that Air folder. The year (2006) is the second input box and the file name is the first. This is what i have so far: I keep getting error- GetOpenfilname application failed Sub Macro112_4() Dim filetypenm As String filetypenm = InputBox("Enter File Name you would like to compare") Dim nm As Integer nm = InputBox("Enter Year you would like to compare") Application.GetOpenFilename (["C:\Documents and Settings\AllUsers\Documents\Coop Students\Small Package Rates\UPS rates\" & nm & "\Air\" & filetypenm]) End Sub HELP PLEASE! Thanks in advance, Mikayla |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
open files run macro | Excel Discussion (Misc queries) | |||
Macro for multiple open files | Excel Discussion (Misc queries) | |||
Macro Open Files | Excel Programming | |||
Macro to open *.dat files and save as .txt (comma delimited text files) | Excel Programming | |||
Files won't open after running a macro | Excel Programming |