Home |
Search |
Today's Posts |
#31
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting data from a closed wbook
I have tried, but not managed to make the ADO method I posted last fail.
If there are no fields at all then it will give one row number less, but that makes sense, as it will consider the first row with data the field row. Hiding rows and columns, merging cells, autofilter and linebreaks in cells didn't cause any problem. So, not sure what causes the problem in your wb. RBS "Geoff K" wrote in message ... I mentioned in my first post here that I was looking at using a formula to include MATCH(99^99 or MATCH("ZZZ" etc The idea is to get a row value for every field, then get the maximum which will give me the last used row and original record count. It coincidently looks similar to Ron de Bruin's code in his Main Program at the bottom of the page. What is interesting is how he turns formulae into values. I insert my formula on my hidden Add-in wsheet. But last night I was getting stuck on how to convert the results into a value - so that snippet will be useful. But - even this method fails with the largest UsedRange flaw. The wbk justs hangs. And even with normal wbks it can be very slow. I have to check all fields for end of row because required fields are not always in the same order and I need th get the original count prior to processing. Geoff "RB Smissaert" wrote: Did you try the fixed code that works with ADO? RBS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get values from 15 sheets in a Wbook | Excel Programming | |||
updating wbook from other... | Excel Programming | |||
transfering data from 2 wbook | Excel Programming | |||
transfering data value from 2 Wbook... | Excel Programming | |||
Read And Write On A Closed Wbook | Excel Programming |