Search results for query: *

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...

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...

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...

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...

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...

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.

I am learning VBA for use with Excel and have run into the following problem: For count = 1 To 20 ... Range("Ax").Select [x = 185*(count-2)+ 1] ... Range("Ax:Ay").Select Range("Dz").Select [x as above, y = 185*(count-1),z = 185*(count-1)+1] ... How do I set up x...

I installed a new HD and cloned my old one. The old HD is now the slave and everything works fine (OS is Win 2k). (1) I now want to remove everything on the slave drive. Will reformatting it work OK without affecting it being recognized? (2) Also, on start up I have the choice of drive to...

I screwed up installing a second drive and ended up with no drive C. The system/boot drive is D, e & F are CD drives and G is the slave drive. The OS is Win 2000. I want to change drive letter D to C and then I can change G to D; however, Disk Management won't let me change drive letter D...

I have a 40 gig Maxtor 5 4098H8 SCSI disk running under Win 2k. Often at start up the drive gives out a grinding sound and seems to stop. The drive isn't recognized by the BIOS and I'm told to insert a startup disk. A reboot may solve the problem but at other times I may have to restart the...

How do I go about calling FORTRAN subroutines from Excel? Is there a good book or other source that takes a person through the details step by step? Any help appreciated sbev