open excel from Access

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: dar (dar_at_discussions.microsoft.com)
Date: 01/04/05 

Date: Tue, 4 Jan 2005 10:41:08 -0800

I have Access 2000, with Excel on a Shared Drive.
I need to open a specific wkbk "ClinicTECList.xls" on the N: drive
I need to be able to loop through the 9 wksh and go to Column D and delete any
row (s) that have a Date earlier than today.
Most importantly, I NEED HELP in the coding, down to the basics.

Help would be appreciated.
Other forum sent me here. If code is supplied, please indicate where I
place it and
how I activate the code.

Relevant Pages

  • Re: open excel from Access
    ... If Excel is simpler, I'm all for that. ... "Tom Ogilvy" wrote: ... >> Most importantly, I NEED HELP in the coding, down to the basics. ... >> Other forum sent me here. ...
    (microsoft.public.excel.programming)
  • Re: Guitar pickup output impedance
    ... I don't use Excel much, ... FORTRAN program to do it. ... then *poof* the forum disappeared without warning. ... the string is moving opposite directions on the two bucker poles. ...
    (alt.guitar)
  • RE: Excel 2007 Starts in Ready Mode
    ... Security hang out, and I mean many). ... Optimal package and it's not Vista friendly. ... Vista but maybe not so well with Office 2007....or at least Excel 2007. ... scope or even the ability of this forum to deal with them all: ...
    (microsoft.public.excel.misc)
  • Re: Newbie needs help data collection, naming columns, pulling in data.
    ... I educate myself about the basics of Excel? ... You enter the title as text into a cell, for example a cell in the first row. ... "libertyforall" wrote in message ...
    (microsoft.public.excel)
  • Re: Create DLL in Visual Studio 2005 accessible by Excel 2002
    ... the basics. ... Reference" dialog in the Excel/Visual Basic editor's Tools menu? ... Excel 2002 to access it. ... I've studied everything I can find on COM Interop ...
    (microsoft.public.dotnet.languages.vb)