Microsoft Excel Forum

Can someone give some advices??? Id like to know if someone have a code for visual basic/ excel to calculate the exact difference of two numbers in a extremely huge sample, such as. 34 46 61 70 73 78 88 89 90 95 100 49 51 55 62 63 64 76 82 84 93 97 47 48 54 55 57 67 74 79 85 91 99 49 51 55 60 63 64 67 78 83 93 98...

I am working on a project to download the full list of domains that my home network has been to in a day (or days) from OpenDNS. I have most of this working, but one piece keeps hounding me. I can't activate the newly downloaded CSV file from OpenDNS to manipulate it. I can get it open, but even when I stop my code after it is open, I can't...

Hi guy, Datasheet form in Access is very good function, I can do the same thing in Excel by Sheets(i).Usedrange.copy Set NewBook = Workbooks.Add(xlWBATWorksheet) With NewBook .Sheets(1).Range("A1").PasteSpecial xlPasteValues, , True, False .Sheets(1).Range("A1").PasteSpecial xlPasteFormats, , False, False End With...

The following works well in local share network drive. However, when the file is transfer over to the open network (view from internet), the following excel file will show error: Run-time error: 52. Bad file name or number. I have change the fpath to the following instead of fpath = ThisWorkbook.path & "\" but still having the same error. ...

I am having issues with the data being placed in the master workbook which contains multiple worksheets that have data tables In one case if SHNames = "Proj Sum" then it is placed outside of the table and not recognized by Pivot table, the other if the shName = "ResPlan_Data", there are multiple rows of blank lines in the Table and no data is...

H, I'm hoping some of you can give me ideas on how to deal with our challenge. We are developing a system that will accept excel data files on counseling and health services accessed by users. The users may get the same or different services from multiple agencies in different locations. We want to analyse the combined data to report on the...

I created a VBA code to automatically sort(ascending order) a column containing Traditional Chinese characters on Excel 2003. It works well but when I tried running the code on a Excel 2013 version the sorted values differs versus on the sorted values on the Office 2003. I tried using Range("A2:A30").SortSpecial SortMethod:=xlPinYin and...

Rabbit has given code for a AES encryption for ACCESS. Which modifications would I have to use it in EXCEL ? Thanks for your help! Andreas

I have a sheet that I want to filter on a month. I have the month in Sheet Master Cell C4. If I use the filter as: ActiveSheet.Range("$A$1:$X$4831").AutoFilter Field:=5, Criteria1:=xlFilterAllDatesInPeriodApril, Operator:=xlFilterDynamic It works. When I use a variable in the AutoFiler if fails. Full Macro is: Dim vMonth As Variant Dim...

Hi Every1. I have an Excel worksheet that contains 4 columns. I select column A and B, and add a conditional formatting to change the color of DUPLICATE cells to a color. So, some cells in column A and B turn to color. Here is what I want to accomplish: NO CHANGE TO COLUMN A. Delete cells in column B,C,D that the B is NOT colored...

Hi All, I have the below macro that I've been using to select data from a sheet, copy the data, open a new workbook, paste special values and format columns C & D to date format. This works perfectly as is, however, instead of the filename for the new workbook being based off of cell H1 in worksheet "Upload to NBI" I would like it to be based...

One of my customers has an Excel 2003 document that appears to be corrupt. When I open the excel document I get the following error: "The file you are trying to open, 'database.xls' is in a different format than specified by the file extension. Verify that the file is not corrupt and is from a trusted source before opening the file. Do you...

favorite This question may already have an answer here: VBA Excel Function for returning file size in byte 2 answers For example: Cell A | Cell B

I have this sub i created for Excel. The idea is to populate multi column list box from values in an excel spreadsheet. I am stepping through the code which executes fine but no values are loaded in my list. Anyone have any ideas? Private Sub cmdContact_Click() Dim cell As Range Dim Rng As Range 'Me.lstEmployee.Clear 'Make sure...

Folks, Trying to do something simple here, I want to take a value that is a string and convert it to a control. Simply put I am looping through an array and when i find a value i am looking for, i want to grab that counter and generate the control. I am using a string to put the value together and then I simply want to convert it to a control...

please i need help i have add in data analysis plus in my excel, but when i want to run the for exemple the t-mean or Z-mean i receive this error "the event source ExceptionManagerInternalException does not exist and cannot be created with the current permission"

I noticed something when trying to sort a list of names. It may have been happening all the time and I never noticed it, but I'm not getting the results I'm expecting. I have three columns that contains each part of the person's name. Column A has the Last Name, Column B has the First Name and Column C has the Middle name. Given the list...

I have been creating queries in excel using ODBC to get data from my peoplesoft tables. Recently I've been getting an error and not able to complete the query successfully. All goes well up until I go hit the "close and load" button. the data does not load into the excel spreadsheet, and I get the following error message: iseries access ODBC...

I keep getting a runtime error when I try to add a value to my array. The error is Run-time error '9' Subscript out of range. I am pretty sure i have declared everything correctly but can't see to figure out whats wrong. Also the array should store string values. Dim myarr As Variant Dim c, r As Integer Dim tbl As ListObject

I am building a VBA code that I need to lookup multiple values into another sheet. The second part to this is I have a table which I filter programmatically and I only want the vlookup to match the values in that table that are filtered and return a salary value. Based on that this is what i have come up with after doing some reading but...

I'm using Microsoft Office Excel 2010. I have a folder containing 52 workbooks and in each workbook there are three worksheets. Not all of the worksheets have the same heading. I want to combine all 52 workbooks into one. I keep all the files into this folder directory: C:\Users\AS-4738G\Desktop\COMBINED DHL\BSB I want to use VBA but I...

When I bought it, it was in French or Spanish. How do I change language?

I have a macro button that will allow the user to open PDF's by inserting the PDF name. If the PDF does not exist, Excel crashes. I want to be able to handle the error, and give the user an output indicating the file doesn't exist. Private Sub pdflink_Click() 'this button allows you to follow the text box with the location of the pdf. On...

Please help me out! Excel error message: A file is corrupt and cannot be opened. It appears when opening .xlsx format file. I could open this file yesterday! Is there a way to recover Excel? I am on Windows 8 Thanks.

My work has banned MS Access databases. I am finding it hard to manipulate data as required in MS Excel. Attached is an excel workbook with 5 worksheets. The worksheet names are “PreviousFN”, “CurrentFN”,”Omissions”,” Additions” and “ChangedDetails” I receive a report every fortnight with 5,000+ records. The first thing I do is I delete all...