find adress in Excel using Access VBA

[March]

Hello All,

I would like to write the VBA to find the cell (address) in Excel
application.

In my excel sheet has contains the date, for example, starting from 1/1/2000
to 12/31/2010, in column B. It begins from B2 and so on.

With writing Access VBA, I would like to find 1/27/2009 in excel. What
should to start writing the code. I already have the code to open the excel
workbook. Then what next should I do?

Please give me suggestion.


Thanks.

 

[Tom van Stiphout]

On Tue, 27 Jan 2009 12:50:06 -0800, March

Read the value in B2. Then, assuming the dates are sequential, you can
calculate the location of any date; you wouldn't have to go find it.

One good way to learn about Excel VBA is to record a macro that
performs a task; then look at the VBA that was created.
Another one is to ask questions in an Excel-related newsgroup.

-Tom.
Microsoft Access MVP

 

[March]

Thank you for you answer. However, I got the way to deal with the problem.
All I need is how to write VBA in Access, not in Excel.


Thanks

 

[Tom van Stiphout]

On Wed, 28 Jan 2009 11:14:09 -0800, March

The VBA code is almost the same. In Access you would start with
creating an Excel.Application object using:
dim objXL as CreateObject("Excel.Application")
objXL.Visible=True
There are TONS of examples all over the internet.

-Tom.
Microsoft Access MVP