Import Table

[esskaykay]

Here's another question similar to my previous. Is it possible to have a macro prompt me for the path to a specific file/table I want to import?

Thanks,
SKK

 

[ted.martin]

You are going to need a bit of VB code but if you put this is a function, you can use a Macro to call it. I have used Public Variables just to avoid later problems

Function Path()

Public strPatch as String

strPath = InputBox$("Enter the path here", "Path")
'
' Some input data validation code would be useful here"
'
End Function

 

[ted.martin]

You are going to need a bit of VB code but if you put this in a function, you can use a Macro to call it. I have used Public Variables just to avoid later problems

Function Path()

Public strPatch as String

strPath = InputBox$("Enter the path here", "Path")
'
' Some input data validation code would be useful here"
'
End Function

 

[esskaykay]

Thanks Ted,

SKK