| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populated cells
How can I determine the start and the end of populated
cells in excel from a form in access. I am using access 97. thank you Al |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Populated cells
possibly
set rng = xlapp.ActiveSheet.Range("A1").currentRegion -- Regards, Tom Ogilvy "Al" wrote in message ... How can I determine the start and the end of populated cells in excel from a form in access. I am using access 97. thank you Al |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Populated cells
I am using the following line of code from withing access
to import from excel: DoCmd.TransferSpreadsheet acImport, 8, Me![NewTableName], Me![DirName], True, Me![SheetRangeName] Me![DirName] = the file path Me![SheetRangeName] = A named range that the user has to enter manually. How can I substitute the "Me![SheetRangeName]" for whatever populated range in excel automatically? -----Original Message----- possibly set rng = xlapp.ActiveSheet.Range("A1").currentRegion -- Regards, Tom Ogilvy "Al" wrote in message ... How can I determine the start and the end of populated cells in excel from a form in access. I am using access 97. thank you Al . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averaging only populated cells | Excel Worksheet Functions | |||
| copy to new cells if populated | Excel Discussion (Misc queries) | |||
| Cells to be populated from an workbook to another. | Excel Discussion (Misc queries) | |||
| how do populate empty cells with the contents of populated cells . | Excel Discussion (Misc queries) | |||
| Requiring Cells be Populated | Excel Programming | |||
Hybrid Mode
