There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Business Applications
Go to first new post Winword 32 remains running hogs CPU
Go to first new post Macro to find duplicate values in column ...
Go to first new post Access 2010 database
Go to first new post Cant open Excel and PDF files
Go to first new post Word 2007 opens previous document
Go to first new post Solved: Sending a Automated Email Throug ...
Go to first new post Solved: two command buttons in a userfor ...
Go to first new post Excel help? A1*B1+C1*D1+...
Go to first new post Virtual software
Go to first new post Solved: Extracting info from column
Go to first new post Macro to select subfolder to copy works ...
Go to first new post Excel formula to copy number of rows?
Go to first new post Excel Script Help (extreme n00b warning)
Go to first new post Combining 2 worksheets into 1
Go to first new post MS Access VBA - Convert Word to PDF
Tag Cloud
access acer asus batch bios bsod computer crash desktop driver drivers error ethernet excel freeze gaming hard drive hardware hdmi internet laptop lcd malware memory modem monitor motherboard network printer problem ram registry router slow software sound toshiba trojan usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless xbox
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications >
macro on close[access]

Reply  
Thread Tools
spdstr's Avatar
Junior Member with 12 posts.
  
Join Date: Aug 2009
Experience: Intermediate
18-Aug-2009, 01:44 PM #1
macro on close[access]
i have a database that has data from an excel worksheet. the database allows u to edit and add new data. what i want to have access do is when it closes have it run a macro or code to update any changes in the data and save it to the original excel file. can this be done?
Register for free to hide this ad!
OBP's Avatar
OBP OBP is online now
Computer Specs
Distinguished Member with 14,665 posts.
  
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
18-Aug-2009, 03:31 PM #2
Yes it can, but requires fairly advanced VBA code.
spdstr's Avatar
Junior Member with 12 posts.
  
Join Date: Aug 2009
Experience: Intermediate
19-Aug-2009, 09:18 AM #3
do u know where i can find how to do this
OBP's Avatar
OBP OBP is online now
Computer Specs
Distinguished Member with 14,665 posts.
  
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
19-Aug-2009, 12:14 PM #4
I can do it for you, but I need things like a Copy of the database, the excel Worksheet Names (Preferably a copy of the sheet) and what fields need transferring to what columns. etc
Email This Email  Print This Print  Tweet This Send to Facebook Send to MySpace Send to StumbleUpon Digg This | More Services More
Reply

Tags
access, close, code, export, macro

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!

« Previous Thread | Business Applications | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
Thread Tools



Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
Contact Us - HelpOnThe.Net - Archive - Terms of Service - Top
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 09:05 AM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

 Powered by Cermak Technologies, Inc.