Search results for query: *

My apologies for such a long post, but this is a long formula and I would like to see if anyone can make suggestions to shorten it. I would post the entire spreadsheet, but I do not have any public space. It is a year-long timesheet consisting of 13 tabs - 12 months (Jan-Dec) & and 1 Months...

I have a spreadsheet with a vbModeless UserForm that works for one business unit. When I open this spreadsheet and Save As to a different name I can close it and open it with no errors. But if I double-click on the first tab and change the tab name for another business unit then save the...

I have an excel spreadsheet that has several command buttons to the right of the data which is in columns a:i. If I apply AutoFilter and select to hide data on the same row as the command button the command button gets hidden as well. I found through research that the Placement attribute 3 is...

I have the following vba code in an Excel spreadsheet with a cmdButton. When I click on the cmdButton I get an error that the file to be opened does not exist. When I step through in debug mode the file is created. I'm using the redirect output character ">" in the shell(cmd) which should...

I have a calendar for keeping track of employee time. I have several categories for not working on a weekday - Holiday, Plant Closed, Vacation, 1/2 day vacation, etc. Each of these categories need to be color coded, but conditional formatting only allows 3 conditions. Currently, I have the 3...

I am writing a VBA script in Excel 2003 to find all .pst files and their pathnames on the Network drives. I have the names, paths, but cannot find a property for the file size. I want to collect the file sizes so I can determine how to best fit them on a DVD for storage so I can get them off...

I have an Excel 2003 spreadsheet that has a dozen columns. Depending on the request the spreadsheet can be sorted logically by 4 columns. When you click on Data, then Sort, the column header selected last is still listed. I would like to create a Page Header containing the words "Sorted by...

I have an excel spreadsheet with 4 columns: GroupName, MemberName, EmailAddress, & FirstName. I have copied code from another working spreadsheet that sends an email, but that code has a specific # of lines. This spreadsheet can have from 1 to 100+ lines, depending on the members of the...

I have an excel spreadsheet with 4 columns: GroupName, MemberName, EmailAddress, & FirstName. I have copied code from another working spreadsheet that sends an email, but that code has a specific # of lines. This spreadsheet can have from 1 to 100+ lines, depending on the members of the...

I have the following code that works directly from a command prompt, but doesn't work from Excel VBA: retVal = Shell("cscript C:\Scripts\Exchange\Mailbox_Sizes_Info.vbs > C:\Scripts\Exchange\Mailbox_Sizes_Info.txt") if I remove the redirected output the script runs in the command window, but I...

I have the following spreadsheet, that I need to draw calculations from and the formula that is too long follows that which is used to calculate days of the week based on a value of Monday through Friday, but I keep repeating the same statements trying to keep from running COUNTIF's and SUMIF's...

I am currently exporting 5 Information Stores to csv files and manually adding each of them to an Excel spreadsheet so I can monitor the size of the mailboxes and email the owner that they need to archive or purge information from their mailbox. I have the code written and working to send the...

I am trying to get a count of rows (sorted by a size column) with a value greater than N15, in this case 700,000 (that's the easy part I'm using =COUNT(B2:B300,">" & N15) which returns 28). But I want to subtract any Exceptions (column E) that are checkmarked as a result of the following...

I discovered a mistake in the formula in over 700 spreadsheets. I came up with the following code to traverse the folders and put it into a spreadsheet, but I am unsure how to open each file, change the formula and insert a lookup range, save the file and close it before going on to the next...

I have a series of Daily planner files that I am opening and copying the value of specific cells ($K$49 in this case represents # of hours worked) into a spreadsheet for comparison and analysis. When I use the following snippet of code the first example puts the formula in the cell which...