Search results for query: *

Hello, I have a workbook with two sheets. I am trying to use VB to make sure the totals on each are equal, as they should be. This is my code thus far. Private Sub Compare_Click() Handles compare.Click Dim oxl As Microsoft.Office.Interop.Excel.Application Dim oxlbook As...

Hello, I am using the following code to copy a range from one sheet, and paste it into another. I had thought the code works, but something is wrong, as no matter how I change it, I get the entire data range pasted regardless of what I set to copy. My code is as follows: copyrange =...

Hello, I am using VB Express to automate some functions in Excel. Currently I am trying to populate several cells with text. I was able to do this quite easily using the VBA built into Excel, but I want to automate everything through VB, rather than running a macro from another sheet. The...

Hello. I have a code that runs through a DIR of Excel sheets and updates them. What I am looking to do, is before it refreshes my Excel query, I want to insert a date on the current workbook. But I want a calendar to pop up and the user to select the date. My code is as follows: Do While temp...

Hello, I am combining and saving an excel file. Currently, this is how I am doing it. newName = "Z:\2009 Combined Delinquencies\April\" + path oxlBook1.SaveAs(newName) What I would like to do, is create a listbox of the 12 months in the above directory, and have the user choose the month in...

Hey everyone, I am using some code to combine two workbooks in Excel into one. I am using the DIR command to run through directories of the original files. My problem is, the first Dir seems to work, but the second one doesn't. My combined file has each of the first directories file, but only...

Hello, I am using Visual Basic 2008 to open an excel sheet. I want to run a macro from a separate sheet, as I don't want clients having access to running it, as well as most clients have macros disabled and it throws an error when they open it. Anyways, my code looks OK I think.. Dim oxl As...

Hello, I am trying to use the Macro recorder to get some coding going. I need to set several filters, then autofill column A. When I use the recorder, I get Range("A1").Select ActiveCell.FormulaR1C1 = "Total" Range("A1").Select Selection.FillDown I know from prior excel VBA coding...

Hello I am using Visual Basic 2008 and Quickooks SDK to interact with and pull data from Quickbooks. I don't know if anyone here is familiar with the QBSDK, but so far I have been able to successfully open QB, connect to it, request a report and have it returned. The report is in xml. Being...

I am using Visual Basic 08 Express to open and excel workbook, refresh the ODBC queries in it, and save and close it. I have not added the code for the save and close yet, but my question is two fold. First, my workbook has one sheet with 80 or so queries. When I ran my code, it opened the file...

When I use the record macro function in Excel, and I try to record this in a cell =IF(AND(MATCH(MAX( OFFSET($K$1,MATCH(J2,$J$2:$J$5000,0),0,COUNTIF($J$2:$J$5000,J2),1)), OFFSET($K$1,MATCH(J2,$J$2:$J$5000,0),0,COUNTIF($J$2:$J$5000,J2),1),0)<=COUNTIF($J$2:J2,J2),(E2<>0)),E2,IF(A2<>"","Total",0))...

I have some excel files I need to write some code for. This is a monthly process, so I'll need to do it frequently. This is how my data is setup. ColumnA ColumnB ColumnC ColumnD Balance Row 1 Row 2 John Row 3 400 11/27/08...

Hello, I have two sheets. Sheet 1 has all of my information on it, save one column of data, which is on sheet two. I need to check to see if the name on sheet1 matches the name on sheet 2. If it does, I want to populate the cell in sheet1 with the data from 2, for each customer. My problem is...

Hello, I'm looking for some help with a Macro. It needs to be code because I need to run it 90 times per month, in the span of one day, so it needs to happen quick. I have columns A through G filled in a delinquency list for payments. If the cell in column G is 0.00 for a specific customer, I...