Novice
Windows 7 64bit 
Access 2010 64bit
Hello,
I am needing to create a macro to export information from a cell in microsoft excel to a table in access. I would also need to have a macro set up to take information from said database and have it be put into a cell in excel as well. Any help would be much appreciated.
VIP
Windows XP Access 2010 32bit
This is a common topic. Search forum or google.
Need VBA code to open the Excel file as an object that VBA can manage.
Review http://www.vbforums.com/showthread.p...ave-excel-file
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Advanced System Analyst
Windows XP Access 2007
Data Import.zip
View the sample DB to upload data from Excel fixed cell location
Posting Permissions
Reply With Quote