i want to be able to autoamtically use Foxpro Import/Append commands to read
all worksheets in an xls and write data to a foxpro .dbf file. I need to
know how i can access the worksheet (tab) names w/o having to hardcode them.

dim i as integer

for i = 1 to activeworkbook.sheets.count step 1

msgbox sheets(i).name

next i

Adjust it for what you need, but that's how to get the sheet name.


"stuart" wrote:

i want to be able to autoamtically use Foxpro Import/Append commands to read
all worksheets in an xls and write data to a foxpro .dbf file. I need to
know how i can access the worksheet (tab) names w/o having to hardcode them.