opening and viewing an access-database
 

While I'm working in a worksheet I want to open and view an acces
database file.
So far I've been able to open access by using this code:

Dim accApp
accApp = Shell("C:\Program Files\Microsoft Office\Office\msaccess.exe"
vbMaximizedFocus)

But I want access to immediately open a database and this I have bee
unable to do.

I tried everything I could find on the internet, like

GetObject
Getfile
Run
Activate
Execute
etc.

Yet nothing I've tried does what I want.

Anybody help me, plz?!

Pee

--
Message posted from http://www.ExcelForum.com

opening and viewing an access-database
 

Are you attempting to retrieve data from that database for
use in your workbook? You can use something like ADO to do
that.

-----Original Message-----
While I'm working in a worksheet I want to open and view
an access
database file.
So far I've been able to open access by using this code:

Dim accApp
accApp = Shell("C:\Program Files\Microsoft
Office\Office\msaccess.exe",
vbMaximizedFocus)

But I want access to immediately open a database and this
I have been
unable to do.

I tried everything I could find on the internet, like

GetObject
Getfile
Run
Activate
Execute
etc.

Yet nothing I've tried does what I want.

Anybody help me, plz?!

Peer


---
Message posted from http://www.ExcelForum.com/

.

opening and viewing an access-database
 

If i understand you, you just want to open the xl file and
view the data.
link to it. first give the range in excel a name
Then in access click the table tab then
fileget external datelink tables
this will call up the link dialog box
in the bottom left combo box select microsoft excel
in the top left combo box select the directory the file is
in then double click the file.
This will call up the link spredsheet wizard.
select the show name range option then select the range
name you gave the range earlier.(otherwize the wizard will
select the entire excel sheet.)
click next. select first row has names
click next. give the link a access name. click finish.
The link will appear in the table part of access, you can
open it and view it all you want. you can even use it to
write querys because access now treats it like a table.


-----Original Message-----
Are you attempting to retrieve data from that database
for
use in your workbook? You can use something like ADO to
do
that.

-----Original Message-----
While I'm working in a worksheet I want to open and view
an access
database file.
So far I've been able to open access by using this code:

Dim accApp
accApp = Shell("C:\Program Files\Microsoft
Office\Office\msaccess.exe",
vbMaximizedFocus)

But I want access to immediately open a database and
this
I have been
unable to do.

I tried everything I could find on the internet, like

GetObject
Getfile
Run
Activate
Execute
etc.

Yet nothing I've tried does what I want.

Anybody help me, plz?!

Peer


---
Message posted from http://www.ExcelForum.com/

.

.