Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

can you help?

  Asked By: Margaret    Date: Feb 25    Category: MS Office    Views: 641
  

I would like to ask for a help, please, would be really nice :-)
I have to program one Tool in Visual Basic for Application (that
would be used under Excel), but have a small problem...
in the excel sheet will be imported one Report and this one later on
in the ¡§Tool¡¨ further programmed¡K it means that the Tool has to use
all information from the Report, that wont be that difficult, the
problem is that there can be 20 rows, but also 150¡K.
How shall I ¡§tell¡¨ the Tool, to use all rows from the Report, does
not matter how many of them will be there¡K but not more and not
less?

Maybe somebody can give me a hint if not help ļ

Looking forward to hear from somebody soon
Have nice evening and thanx once again for help ƒº in advance ¡K

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Venkat Rulez     Answered On: Feb 25

Here is a link to some code for importing from an Excel workbook:
www.erlandsendata.no/.../index.php

In terms of trolling through the active rows,
www.vba-programmer.com/.../...Cells_with_Data.html will
help you.

Please bookmark both sites. Many more useful examples in there. Since this is
for training purposes, you might want to write this yourself, and make sure you
understand what the code does.

 
Didn't find what you were looking for? Find more on can you help? Or get search suggestion and latest updates.




Tagged: