excel 10 vba code

Hello I'm in need of help. Right here is the back story, I'm currently away with the United Nations and a apart of my job is to search peoples names and registration before they enter the base. At the moment we have to search over 500 peoples names on a sheet of paper... I've made an excel...

Hello I'm in need of help. Right here is the back story, I'm currently away with the United Nations and a apart of my job is to search peoples names and registration before they enter the base. At the moment we have to search over 500 peoples names on a sheet of paper... I've made an excel...

I will admit I am not a excel savvy person, so I could really use some help. Currently all of my inventory is saved to an excel 2010 spreadsheet, about 162 items. Each item has an ID number & description. Also on the spreadsheet are the quantities in my 2 locations and lastly the unit of measure...

Hi everyone, I am trying to transfer Excel data to a password protected Access 2010 database. So far I have the following code that works perfectly if the database is unprotected (minus the JET OLEDB Password part) Dim MyConnXLS As String Dim MyConnADODB As String Dim MyConn As New...

Good day, I need to submit a piece of work today, however every time I click on a check box a popup appears: "Cannot run the macro "Filename'!CheckBox1_Click'. The macro may not be available in this workbook or all macros may be disabled." I was trying to clean up any macros that I was not...

Hi, just one more question... For this codes: The one which is highlighted in red, how can I make it to dynamic range too? Sheets.Add ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "Residential Raw!R1C1:R659C34", Version:=xlPivotTableVersion14). _...

Hi! This is the codes which I'm currently working on. Just wondering how can I make the range (highlighted in red) into dynamic range such that all the data will be captured no matter the number of rows there are. ActiveSheet.Range("$A$1:$AH$995").AutoFilter Field:=21, Criteria1:="=FH*"...

Hi All: I'm trying to copy data from one sheet to another. The following code is working but the problem is that it only copies the first line and it does not select any other breached or warning ticket(see attachment) If you open the sheet the code won't work because I set the Range to...

I've been working on a userform at my house. All I have done so far is the userform1 page design and a button on the excel spreadsheet itself to run the macro. On my laptop and my desktop at home, they work just fine. But on my work computer(s), they bring up the Error 2110. I'm not sure how...

I did this 10 years ago so I admit I am rusty at this but here are what I had in my notes that worked with Excel XP. I am currently using Excel 2010 With ThisWorkbook .HasRoutingSlip = True With .RoutingSlip .Delivery = xlOneAfterAnother .Recipients =...

Hi Guys., I got stuck into a problem while using Macros. I would like to find the difference of two values in the same column if the particular criteria matches.. Actually i was trying in Excel using the formula =IF(($V$2=V3)=TRUE,J3-$J$2,""). Could some one hlep me with macros program as I'm...

Learning VBA on the job, I'm not able to get the following code to work. Would appreciate some support. I receive Runtime error '91' at Line 6 Dim xlApp As New Excel.Application Dim xlBook As Excel.WorkBook Dim xlSheet As Excel.WorkSheet Dim FoundCell As Range xlApp.WorkBooks.Open...

Hi I need to save single sheet from workbook (sheet7) as text file in specific folder (c:\Test) if the file exists a warning should show if you would like to over-write the file. And et the end change file extension from .txt to .dat Thanks Zibi

Hi I have timesheet spreadsheet application,and this spreadsheet require to add new sheets for new employee using vba iam adding new sheets by copying sheets("sample") for every new employee,and this sheet("sample") contains Named ranges with scope to workbook,but the problem is : every new...

Hi ... i have Myspreadsheet.xlsb then i converted to Myspreadsheet.exe . so when i want copy sheet from : Source: Myspreadsheet.xlsb to Destination: Myspreadsheet.exe i faced the source dont see the Dest. as open workbook ,so what shall i do with this ,and can i know from expert why...

<COLGROUP><COL style="WIDTH: 48pt" span=26 width=64><TBODY> 1007A1 VTC VLB9 a b c d g h i j k 2011 0 0 0 0 0 0 0 0 0 0 0 0 </TBODY> Hi i need the above sheet to be converted into following format in another sheet:confused: <COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY> 1007A1 VTC...

I create workbooks that have a significant amount of private data that is used to generate charts and reports. We want to distribute a workbook with just the charts and reports without any links to the data. No big deal - use vba - create a new workbook, copy over the charts to the new workbook...

Hi Guys, I am trying to close my active window without saving, using (SaveChange = False) and I receive a compile error stating 'Cant find project or library' I am using Excel 2010 and it was working before the upgrade, any ideas?! Full Code below and thanks for your help in advance! :eeek...

why do i get "range out of bounds" for v(i) = x(i) * y(i)? Function element_mul(x, y) Dim i As Long Dim v() ReDim v(1 To size(x)) For i = LBound(x) To UBound(x) **v(i) = x(i) * y(i)** Next element_mul = v End Function Sub main_ols() Dim x, y...

hey, i'm creating a database on excel and i've come across a problem, on sheet "database" i have data starting from b2-e2, headed, reference number, product name, description , date respectivley there is data underneath and keeps adding. what i need is a macro code to do the following, i want...