> You don't insert the VBA code into Excel, you create the code in Access and
> have Access establish its connection to Excel.
> The sample link below should give you a little sampling of the coding.
> Use google to give a search for "Excel Automation"
> Take a look at what you can find. If you have any direct questions about
> some of what you find, let me know.
> Rob Mastrostefano
> FMS Professional Solutions Group
> Software Tools for .NET, SQL Server, Visual Basic & Access
> "JimS" <JimS[ at ]discussions.microsoft.com> wrote in message
> news:858DE4D1-D26C-40DC-BCC3-0F615FB092CB[ at ]microsoft.com...
> > Thank you for responding. I appreciate your interest.
> > I've read up on using VBA within Excel, but I don't have access to the
> > Excel
> > Spreadsheet to insert VBA code (what I assume you refer to....) I have
> > read-write access to it, and I am familiar with its structure. I need to
> > work
> > with a range that is NOT the entire sheet, and is carefully structured. I
> > need to update about three cells per row, and there are 99 rows of
> > interest
> > in each sheet, 20 sheets per workbook, 10 woorkbooks. I'm using Access to
> > load up the contents of those cells, then later to update one column per
> > row.
> > In the meantime, a user must use the spreadsheet to post his/her results
> > within the same range (not simultaneously). Any references and/or
> > strategies?
> > --
> > Jim
> > "RobFMS" wrote:
> >> Jim
> >> Sounds like you need to perform some Excel Automation. Is the worksheets
> >> in
> >> some particlar ordering that you know what rows and/or columns you need
> >> to
> >> touch? Have you ever performed Excel Automation?
> >> Here's a sampling:
> >> Tip #2: Excel Automation: More than just a formula
> >> http://www.fmsinc.com/free/tips.html#ExcelautomationVBA
> >> Rob Mastrostefano
> >> --
> >> FMS Professional Solutions Group
> >> http://www.fmsinc.com/consulting
> >> Software Tools for .NET, SQL Server, Visual Basic & Access
> >> http://www.fmsinc.com
> >> "JimS" <JimS[ at ]discussions.microsoft.com> wrote in message
> >> news:297CAA2C-BC17-4B56-B60C-AB335CE6BFC6[ at ]microsoft.com...
> >> >I want to read in an Excel spreadsheet (multiple sheets from a
> >> >workbook),
> >> > update some of the cells, then transfer that range of cells back to the
> >> > spreadsheet. I don't mind treating the whole sheet as a table, but the
> >> > ADO
> >> > Update method doesn't work and I can't find any other ways other than
> >> > "export
> >> > spreadsheet" method, which requires transferring the whole sheet at
> >> > once.
> >> >
> >> > Strategies?
> >> > --
> >> > Jim