Search results for query: *

yes it is f,

JAZPpl (TechnicalUser) Sep 9, 2004 I took it out and it still the same (see code below) For i = 0 To Datapoint - 1 'ApplicationStatusBar = i Sheets("LogFile").Range("T20") = i 'Application.ScreenUpdating = False The content of...

I took it out and it still the same (see code below) For i = 0 To Datapoint - 1 'ApplicationStatusBar = i 'Sheets("LogFile").Range("T20") = i 'Application.ScreenUpdating = False The content of the text box only appears when the I...

Hello Everybody, I am running a code which takes a couple of minutes to compute and I would like the user to see what is going on. I want to avoid to put a process bar as I know it will slow the code even more. I have put an application.StatusBar with one of the loop but the form is...

Zathras, I have amended your code however it will oven the file as an excel file but what I need to use is the Workbooks.OpenText structure instead of Workbooks.Open. When doing so there is an error message. So the code has changed and looks like: Set WKB =...

Zathras, Thanks, the code looks perfect for what I want to do but is there a way to avoid using the Const FILE_PATTERN = "ABC*.xls" and use any file with extension say *.txt within the working directory ? Something like the following lines (I have copied this from a book) Dim Fname as String...

Hello all, I am trying to automate excel to open n number of file into a directory. The target is to open all the *.txt file which are in a directory, then grab a couple of values and copy them into an output *.xls file then open the next *.txt file and son on. The following sub does the job...

Hi, I am trying to automate the opening of 1000 of excel spreadsheet. Each spreadsheet say is named as 120500,120501..120599 The aim is to open each of these file in a loop and pick some of the values in each of the spreadsheet. Then after the file is open and the data extracted the file as to...