Re: performance question

thanks for the reply. there are other files in the folder, so i have no idea
how i would differentiate between the ones i need and the ones i don't. when
i tried the evaluate option. i just got #value in the cells, unless i had
the workbook physically open. then it worked.

--


Gary


"abcd" <temp.nospamdc2@xxxxxxxxx> wrote in message
news:O5v969jiFHA.3448@xxxxxxxxxxxxxxxxxxxxxxx
> you must remember with a formula, you also have a link (since something
> change in a book, your formula gives the new value)
>
> If you need the value, you may evaluate the string, without writting it
> first in a cell (vba function evaluate)
>
> But, if this link is precious, the formula is probably the better way.
>
>
> Whatever, you should look on the web the way to list a folder, so you'll
> be abble to construct this formula with a loop (and not the explicit
> names). I don't know the rest of the code, just a suggestion that might
> help


.

Relevant Pages

  • Re: Copy and paste to corporate sheet
    ... it copied cell A1 in my CSB file - I have input in other cells it is not picking up. ... And is the sheet where you want to copy to also named Substandard? ... > Dim basebook As Workbook ... Do I need to>>> create a folder to save them all in for this to work? ...
    (microsoft.public.excel.programming)
  • Re: Disabling error checking.
    ... Then in the workbook open event, look for the cells that should ... I have an add member macro. ... > that all look up to the right folder and file. ...
    (microsoft.public.excel.programming)
  • Re: Split file, saving each tab/worksheet to a new workbook, w/tab asworkbook name?
    ... copying contains cells that have more then 255 characters. ... sheet only the first 255 characters in each cell will be copied. ... it off to my "personal" root network work folder. ...
    (microsoft.public.excel.programming)
  • Consolidating tab-delimited text files
    ... I am in the business of consolidating about 60 text files onto one worksheet as follows: ... Opening a tab-delimited text file in the same folder as ThisWorkbook. ... Copying all non-empty cells ...
    (microsoft.public.excel.programming)
  • Re: Perform task on multiple sheets in a folder
    ... How could I have the folders locations selected by look at Cells A1 ... I would like th template file value selected from cells A2 of the ... I also want the output placed a folder using the value from A3 so the ... Dim mybook As Workbook ...
    (microsoft.public.excel.programming)
Loading