Import Filtered Excel Data Into Access

[Navron]

I am trying to import a filtered excel sheet into access. However, whenever I execute the command, the entire table is imported instead of the filtered results only. The command is:

DoCmd.TransferSpreadsheet acImport, 10, "Table1", CurrentProject.Path & "\" & "Reports.xlsm", True, "Sheet1!a1:F360"

 

[Sektor]

Access doesn't "see" filtered range. You need to copy the filtered cells somewhere and refer to them.

 

[Navron]

The thing is, the filtered range is dynamic. As such, the filtered values re continuously changing.

 

[Sektor]

The thing is, the filtered range is dynamic.

And is it problem to copy filtered range somewhere?

 

[Navron]

Right, since the values are changing and I wish to do the copy automatically (VBA).

 

[Sektor]

Ultimately, someone filters a range. If he filters, then he can also save the result of filtering somewhere. Then it'd be possible to refer to this result.

 

[Navron]

You are not understanding what I cam saying. I am saying that the filtering will be done automatically using a macro> I need the copying to be done automatically as well. However, the values are dynamic. As such, I cannot just use a recorded macro.