Applying filter using VBA then exporting filtered output to GIF

S

sean pears

Hi all

Desperate for some assistance with Project VBA.

I had my macro all working fine for selecting records and exporting them to a GIF which was then posted to an Excel worksheet for a Dashboard.

I was using the select row function for testing on a semi small data set.

When I reached 10 select rows, I received a run time error due to the limits applied by microsoft.

I have since then been trying to apply a filter and then selecting all of the records displayed to have the same effect and my processing over the filtered info goes through all of the tasks not just the filtered ones.

Does anyone know how I can export to a gif the results of a filter using editcopypicture? i.e. Count used rows in filter and export?

Any help would be appreciated.

Thanks

Sean

EggHeadCafe - Software Developer Portal of Choice
Caching Pages and Application Data with Database Dependencies
http://www.eggheadcafe.com/tutorial...5-4a8530bde25f/caching-pages-and-applica.aspx
 
R

Rod Gill

If you have a filter applied the rows on screen feature might do, otherwise
select Task 1 then:
SelectCellDown Numcells:=5,Extend:=true

Change the 5 to be the number of rows to be copied.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com




Hi all

Desperate for some assistance with Project VBA.

I had my macro all working fine for selecting records and exporting them
to a GIF which was then posted to an Excel worksheet for a Dashboard.

I was using the select row function for testing on a semi small data set.

When I reached 10 select rows, I received a run time error due to the
limits applied by microsoft.

I have since then been trying to apply a filter and then selecting all of
the records displayed to have the same effect and my processing over the
filtered info goes through all of the tasks not just the filtered ones.

Does anyone know how I can export to a gif the results of a filter using
editcopypicture? i.e. Count used rows in filter and export?

Any help would be appreciated.

Thanks

Sean

EggHeadCafe - Software Developer Portal of Choice
Caching Pages and Application Data with Database Dependencies
http://www.eggheadcafe.com/tutorial...5-4a8530bde25f/caching-pages-and-applica.aspx

__________ Information from ESET Smart Security, version of virus
signature database 4525 (20091020) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4525 (20091020) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top