Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Opening Access database | Excel Discussion (Misc queries) | |||
Viewing Access Code in Windows 2000 | Excel Discussion (Misc queries) | |||
opening access database using macro | New Users to Excel | |||
Problems opening Access database from Excel VBA | Excel Programming |