programming

I don't know if this is possible but I am hoping so. I run several performance reports daily and weekly. On Monday's I have to run the reports twice, once to compile the prior week recap and the second time to produce the current weeks performance. Currently between runs, I have to archive...

We run several daily performance reports. The files are created by day of week with a DOW identifier built in. All of the files are structured the same way, (columns, headers, etc) but with varying number of rows per day. I need to create a macro that will open each of the daily CSV files...

Hi there, I have a rather complex problem and wonder if anyone can help. I have 3 columns A, B and C, with each row representing a different company. Essentially I am trying to calculate the number of days between orders for different companies, by inputting the latest order date. So...

The error is "else" without "if". What's the solution for this? import java.io.*; public class edward{ public static void main(String args[]) throws Exception{ String a; int y; System.out.print("Enter Message: "); x=input.readLine(); for(y=0; y<A.LENGTH(); p y++){<> if (x.charAt(y)=='a' ||...

I have a file in excel 2007 I designed with some table and form automation to show where employees are on disciplinary issues. I wanted to have this set up with a tab for each employee so it would be easy for the clerks to keep it straight and up to date. My problem is we have 157 employees and...

Dear All, I need help on Excel 2007 Macro , the below coding searches for a string "recvtiming" in a cell as a wildcard and delete it entire row once it founds it in a single active sheet. Question, 1. How do I manupulate it to search for the same string and upon finding a) Delete its cell...

I have a worksheet with 6 pivot tables linked to an Access database. Each pivot table is filtered for a particular month. I do this manually every time. Is there a way this could be done automatically with a macro? <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office"...

Could anyone help me how to program in excel using the variables. I have done a coding for a set of data's in a sheet to copy and display in the Index sheet. Similarly i have to do the same for the remaining 46 sheets. Could anyone help me how to do that with a single program, by changing...

Hi I was wondering if someone can help me. I have a conditional formatting VB running on my spreadsheet that I need help amending and I am lost. I can master basic but I now need to alter this to include a bit extra. Currently I have data on a worksheet that is amended daily. I have a...

Hi, my problem: I need to export data in a GridView to excel without having office installed on the <nobr>server</nobr>. I need to do this with both freezing a row so it will show on every <nobr>page</nobr> when printed. This can be accomplished in excel 2007 using "Print Titles". The other...

Many years ago I wrote some structural analysis programmes in BBC Basic. I still use them but the hardware is now getting old and I am worried that, if it packs up, so do my calculations. The calcs. in BBC Basic include many subroutines which, basically, run the same calculation numerous times...

Hi all, I searched the board and couldn't quite find anything that addresses this so I apologize if it is already solved. I am using a script posted on Microsoft's website to programmatically select every nth row in a range in Excel here. I have posted the code below: For the most part, it...