Update cell in closed workbook

Can't seem to get past this. Your email address will not be published. Using Dialog box for opening and saving the w Basic file and folder examples using VBA in M Rename the worksheet module name using VBA in Combine Multiple Worksheets into One Google serves cookies to analyse traffic to this site. Information about your use of our site is shared with Google for that purpose.

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings. If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again. Toggle navigation.

Archived Forums. Sign in to vote. Hey, How do I, with VBA code, update a cell in a closed workbook when a cell in the active workbook changes? Best Regards Cathrine. Saturday, August 18, PM. Hi, This article maybe useful. Wednesday, August 22, AM. Log in. Remember Me Forgot your password? Password Reset. Please enter the email address for your account. A verification code will be sent to you. Once you have received the verification code, you will be able to choose a new password for your account.

About Us Our team. A:A,2,1 Notes : 1. You can change them based on your needs. If you want to manually select a worksheet to reference, please apply the below formula. After applying the formula, a Select Sheet dialog box pops up, please select a worksheet and then click the OK button. Then the certain cell value of this worksheet will be referenced immediately. Read More I want to use a similar process to SET the value of the cell to whatever I want, without opening the file.

Is that possible? Meaning you have valid fields arranged in columns with or without headers. For example:. Using ADO you can try:. Edit1: You can actually do this without using Recordset. See below update. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more.