Search results for query: *

Are ALL the workbooks to be opened by the macro, in this path? Yes Are ALL the workbooks in this path to be opened by the macro? No Please don't put anymore time into this. Thanks to you I have solved 98% of the problem. The Tom, Dick and Harry workbooks are few in number and can be handled...

The folder is C:\Work\Database\Data Workbooks\

I've used your loop and concatenation to sequentially open the workbooks and modify the Window.Active line. Everything works great. Thanks a lot for your help. How do I set up a pre-determined list? Do I put the names in an array dimensioned as variant?

Whoops, I understand your confusion. I've provided a bad description (I'm a newbie at VBA). When the macro is run, Workbook1 is already open and active. So let me try again. Workbook1 open and active. Then (a), (b), (c) and (d). Now comes Windows("Workbook1.xlsx").Activate. Then (e) on. What I...

After OPEN (a) sheet 2 to the last sheet are grouped, (b) a cell is copied, (c) the result is pasted into another open workbook (call it Otherbook), (d) B2:K2 is copied from the now grouped sheets in Otherbook, (e) the result is pasted as values into the OPEN book, (f) a certain cell is...

Say the first time the macro is run, (let's call it) Workbook1.xlsx is activated. Then I change the name to Workbook2, run the macro, change the name to Workbook3, run the macro again, and on and on.

I use an Excel 2007 macro laid out as ... Windows("Filename.xlsx").Activate ... ActiveWorkbook.Save ActiveWindow.Close ... It works fine but I have to edit filename to open up the next workbook and there are 400+ workbooks in the directory. Is there a way the workbook names can be...

Thanks salgerman, the solution works great.

I need to create numerous symmetric Toeplitz matrices from different beginning 1-dimensional arrays. It is straight forward to do with DO loops, but want to know if it can be done efficiently with intrinsic functions in 90/95. The problem is: Given n numbers, x1, x2, ..., xn, form an n by n...

Thanks, everything is OK now.

I'm learning Dreamweaver MX 6.0. I don't know what I did but now when I request a preview of a page in a browser the program hooks up to my remote site and tries to find the directory/file. I want to stick to my local site, the way it worked before. Any ideas on what I can change? Any help...

Win won't disable (uninstall) the drive; it hangs indefinitely when asked to. I've tried booting without power to the drive and then rebooting with it powered up but the same problem remains.

I ejected a disk from my read CD drive during a disk copy and since then Win 2k won't detect a disk in the drive. It says the device and drivers are OK so it seems to be a software problem. The busy light never goes on and no software recognizes a disk. Selecting the drive in Explorer often...

I ejected a disk from my read CD drive during a disk copy and since then Win 2k won't detect a disk in the drive. It says the device and drivers are OK but the busy light never goes on and no software recognizes a disk. Selecting the drive in Explorer often produces the error message...

Thanks for the help. I'm crunching along now.

I want to read through a workbook and on each worksheet give the first nonblank cell in column 15 the local name FirstValue. Count is a loop counter for the worksheets and mRowCtr is a loop counter for the rows on a sheet. Both the following generate error messages: ActiveWorkbook.Names.Add...

Thanks DrBowes, I'll try it out.

Thanks Sarun. It wouldn't work as given but I added a Then to the Range("D" ... statement and changed the end select to an end if. You have saved me many hours of work,

I have a large number of worksheets with 20,000 - 40,000+ rows of data. Irregularly scattered on a sheet are unwanted rows signaled by cell Dxx being blank. How can I scan through a sheet picking out the unwanted rows and deleting or hiding them? Any help appreciated.

Hi Skip, Thanks, it works great. Sbev