Format excel from Access (borders in cells)

[Guest_imported]

Hi,

I am sending some data from Access to Excel and would like to set some borders in some specific cells in Excel.

I have tried:
oSheet.Range("G" & intI).Borders(xlEdgeTop).LineStyle = xlContinuous
oSheet.Range("G" & intI).Borders(xlEdgeTop).Weight = xlThin
oSheet.Range("G" & intI).Borders(xlEdgeTop).ColorIndex = xlAutomatic

But Access does not take it, and I don't know where to find help.
Any ideas?

Thanks,

Herrman

 

[jebry]

Hi Herrman!

What you have looks good, but you might try this:

Dim strRange As String
strRange = "G" & Format(intI)

Then use strRange for your range.

hth Jeff Bridgham
bridgham@purdue.edu