Full Version: Look for file
UtterAccess Forums > Microsoft® Access > Access Forms
CHKarcher
Currently I have code to look for a specific file to process hard coded and brings it in as a table
'-**************************
'Creates table “Lese_Numbers” for excel file

DoCmd.TransferSpreadsheet acImport, , "Lease_Numbers", "C:\TEMP\LEASEIMPORT.xls", True
'-**************************
Instead I would like to have code prior that wil let you search for the file in any location and place the location in the TransferSpreadsheet script.
TIA
Steve
doctor9
Steve,
Search the UA Code Archive for keywords like "file" and "browse" and you'll find a few examples like this one.
Hope this helps,
Dennis
CHKarcher
Worked Great thanks
andru be with you
Steve
doctor9
Glad to help!

"Landru"? Dude, did you just hit me with a forty-year-old Star Trek reference?

...And by recognizing it, I not only reveal my age, but bury the needle on the geek-o-meter at the same time. sad.gif

Dennis
"Have no fear... Sargon is here!"
Geek-o-meter: [......./.]
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.