var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Xl from Acce$$
If you have an Excel file, which has data in the range say B1:F20. I want to manipulate if form Acce$$. Is there a way to know this range which contains the data? I started something like that
It functions ok, but say, for some reason the data will not start in B1, how can I know that? Or how can I determine where the data starts and ends i.e the data Range
Dim xlApl As Excel.Application
Dim xlWrkBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Dim xlRange As Excel.Range
Set xlApl = New Excel.Application
Set xlWrkBook = GetObject("c:\Temp\anyFileName.xls")
I found it, perhaps it is useful for you.
Good show sir.
One of my biggest pet peeves is when folks neglect to let you know what worked for them. It sort of gyps anyone else who has the same problem.