excel & vba 2007

Hello Guys, Please help me.. I have large data in Excel sheet in following format <tbody> A 32423 2234325 12131 11231 2534R 323422 1245 224241 112125 21212 353453 464363 545352 12423 123525 22424 B 114343 12342 2E23R 1342 1423R 25346 1324 1234 2525 1234 2522 </tbody> I want to...

I'm looking for a formula that will sum together cells in a column but only if the data comes from 6 weeks before todays date. The column with data would be B1:B999 The column with dates would be A1:A999 I'm presuming it would be something like =SUMIF(B1:B999,"<"&TODAY(),A1:A999) however this...

Hi, I have an excel containing userforms,formulas and 2-3 tables and i want to create a webpage for the same so that it can be accessed via webpage and excel file will no longer be required. Is there any way to do this?

I have the below code to enter the data in the range A2:B6 using Userform. I want to make changes to it,I want to check if combobox value already exists then i just update the corresponding textbox otherwise add a new row.Comboxbox has values-Class 0 to Class 4 and Textbox has numeric values...

The function GetOpenFileName does not work in Excel 2010 (32 bit) in Windows 7, but does work in Excel 2007 (32bit) in Windows. The window does not open and returns "false" to Output. To test the code, you need to run the sub startit. The problem happens in thCommonFileOpenSave, Line containing...

Can I set the default format for phone number? I know the Format Cells feature of MS Excel. But I want some extensive kinda requirements. Like if user enter phone number +1 923-456-7890 then it should automatically formatted by removing extra spaces, special characters and the country code...

Hello, I am having issues making this line of code work. I used record macro and plugged in the formula I created. It is too long for VBA and I cannot properly continue on the next line. Can someone help me break this formula into multiple lines on VBA? ActiveCell.FormulaR1C1 = _...

Hi Guys, I have two vlookup formulas in two columns of a sheet which validates the value whether it is "Pass" or "fail" from another sheet of the same workbook. Here are the below 2 formulas :- 1) =IF(VLOOKUP(BY2&G2&BG2,Sheet2!A:I,9,0)>=BV2,"Pass","Fail") 2)...

I am new to VBA coding. I want some data from NSE-Company tracker websites. I tried using below code Private Sub IE_Automation() <code style="margin: 0px; padding: 0px;">Dim R As Long Dim IE As Object Dim ieurl As String Set IE = CreateObject("internetexplorer.application") IE.Visible = True...

​Hi, I have an issue and I hope someone in this forum could help me. I am trying to retrieve "XML Data" of a sequence . I am connected to SQL Server and I am able to query the Database. However when I get the Result XML Data, I don't get the complete data. It seems that I am only getting the...

Hi Guys, I'am trying to write a small script to delete the "Cancelled" word in a column and keep the "Shipped" and "delivered" words. Below is the code Sub removecancelled() Dim st As String, i As Integer, lastrow1 As Long st = WorksheetFunction.Match("Status", Range("1:1"), 0) lastrow1 =...

Hello Im an intern at a ecommerce company, and every day i have have to produce 80 Powerpoints from data that i recieve in an excel file. So i have an powerpoint template, where i need to change 10 fields, fields that i have to pull from the excel file. Each line containing 10 columns of...

Greetings. I am writing a custom tab ribbon and I discovered that sometimes the program will switch to "Home" tab. I would like to add a command line that will assure that the program will remain in my custom ribbon tab. any Ideas? thanks.

Hello, Any ideas as to why this will not run. I've been playing with it all day and can't figure out why it stops after the If statement is evaluated. I'd bet money it's something minute I'm overlooking but I can't find it. I have changed everything I can think of in the two statements...

Hi, I am very new to macros and try to use them by visiting similar queries and trying out the suggested codes. But this one problem I am not able to solve. I am not sure whether this exact thing has been covered or not hence I am posting this. 1. So I have a set of values in a drop-down(from...

Hi Guys, I would like to know how to print next 20 leap years in vba program I have a function to find leap year as below, but how to print the years in excel A column can you help me ? Public Function isLeapYear() ' returns FALSE if not Leap Year, TRUE if Leap Year isLeapYear =...

Hi All, I have a question. I have the following code saved in my macro: 'Open ITEM MASTER SKU Workbooks.Open Filename:= _ "R:\Shared\TEAM\VMI FILES\ITEM Master SKU (NEW).xlsx", ReadOnly:=True, Notify:=False However, I would like to add in some code that will open a...

Hi All,<o:p></o:p> <o:p></o:p> I am using this autofill code for my macro.<o:p></o:p> <o:p> </o:p> Sheets("Data").Select<o:p></o:p> 'This counts the # of Rows in the Coulmn A<o:p></o:p> IngoMaxRo = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row<o:p></o:p> <o:p> </o:p><o:p>...

Hi Experts, I am really in need of yours help. I am using Excel 2007 Version. I have around 3000 rows of data in excel and in each row there is a text "AB10" I want all of "AB10" replaced with different series of words. "AB10" Replaced with "A1" "AB10" Replaced with "A2" "AB10" Replaced...

I am working on a excel sheet, where I have a 4 cells that i enter information into. I am trying to make a button inside this sheet that has a macro assigned to it. The button needs to copy the cells (E3:E6) in the column (E) once it has copied the data from these cells paste them to another...