Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding the right file
I'm having trouble getting what I need out of Excel's 'get external data'
function. I need to get some data from some MS Access queries I have written, but I need Excel to ask me which .mdb file to get the data from before it retreives it. can anyone help? thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding the right file
I'm not sure if this helps in your specific case but, in general, you ask
for a file like this: Sub a() Dim FName As Variant FName = Application.GetOpenFilename("Access files (*.mdb),*.mdb") If FName < False Then ''Your code Else MsgBox "user cancelled" End If End Sub -- Jim "lou sanderson" wrote in message ... | I'm having trouble getting what I need out of Excel's 'get external data' | function. I need to get some data from some MS Access queries I have written, | but I need Excel to ask me which .mdb file to get the data from before it | retreives it. can anyone help? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
finding where a file is stored | New Users to Excel | |||
Finding/Opening a File | Excel Discussion (Misc queries) | |||
finding a file | Excel Discussion (Misc queries) | |||
Finding and Hyperlinking to a file | Excel Programming | |||
Finding the last cell used in a file... | Excel Programming |