current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0

Tagged Questions

0
votes
0answers
2 views

Email notification on submission (response) to Excel Survey

How can I receive an email notification every time a submission is made to an online Excel Survey?
0
votes
0answers
5 views

How to make combobox lose focus automatically

I have an excel workbook with multiple sheets and a have a home page where there are some hyperlinks which also lead to some tabs in the workbook.. I also have a combobox dropdown on the home page... ...
0
votes
0answers
11 views

Excel VBA using Find to update data in different worksheets

I'm trying to create a Macro that will allow me to compare data in two worksheets and update based on any differences (updates, insertions, deletions, etc.). This what I have so far - but it keeps ...
0
votes
0answers
9 views

Excel.exe*32 not closing in task manager. Runing VBA from Access. Runing Office 2013

The excel.exe*32 process remains open in the Windows Task Manager even though I am closing it in VBA. I am running the following VBA code from Access. I have looked and tried various solutions to no ...
-2
votes
1answer
28 views

VBA excel passing an array to sub fired by button

As in title I would like to pass an array to the sub which is executed by a button (That's why I don't know ho to pass it to the sub). Array is calculated in the Sheet before you can exectue sub with ...
0
votes
2answers
43 views

Excel VBA Application-defined or object defined error

I'm struggling with this bit of VBA code. For some reason I keep getting: "Run-time error '1004': Application-defined or object defined error" message. My only thought on why this may be is that I ...
0
votes
2answers
14 views

Comparing two Cells in two different Worksheets

I keep getting the following error message when comparing two cells in two different worksheets: Run-Time Error '1004' Application-defined or Object-defined Error For j = 2 To 10 For k = ...
0
votes
2answers
16 views

Type Mismatch Run Time error 13 for excel VBA

I have requirement to write some function which will accept Range as input and I need to return value of first non empty cell. I have tried in one excel sheet and finding non empty cell was working ...
-7
votes
0answers
23 views

Have some quick queries on macro can you please help me? [on hold]

Please Help!!!!!!!!!! I need to copy paste file from one folder to another and then rename the files to present month and clear content in all the excel file and all the worksheets within it. Nextly ...
-3
votes
0answers
27 views

Excel macro to generate sql create table [on hold]

Hi I need a help on the below scenario. I have a below excel sheet STUDENT S_NAME CHAR 10 1 STUDENT S_LAST CHAR 10 2 STUDENT S_GRADE CHAR 1 3 STUDENT S_MARK NUM 0 4 TEACHER T_NAME ...
0
votes
1answer
14 views

Importing dozens of xls files into Access

I have an excel spreadsheet that has 5 different tabs. I would like to create this spreadsheet in access represented by 5 different tables. My first attempt at this is to import in the files. I have ...
1
vote
1answer
26 views

xlLastCell only works half of the time

I am trying to remove the duplicates in excel via the following code: Set rng = Range("A1", Range("A1").SpecialCells(xlLastCell)) rng.removeduplicates Columns:=8, Header:=xlYes This method ...
0
votes
0answers
10 views

ActiveX component can't create object. Hasp in Excel VBA

I wanted to create object of HASP app in VBA in Excel, but I have such error: Run-time error '429': ActiveX component can't create object. I installed hasp_com_windows.dll in SYSWOW64 folder and ...
1
vote
1answer
18 views

Excel VBA OnTime for less than 1 second without becoming Unresponsive

I have a userform which runs a script every 100ms. The script handles images on the userform and is used to animate them, while the form continues to receive user input (mouse clicks and key presses). ...
0
votes
0answers
11 views

Add-ins not loading when opening excel file programmatically

I've seen some similar problems described by others before but no real solution. And I'm sure there is one. I have a .XLA-add in configured to be loaded when I open up Excel. It works fine when I ...
-3
votes
1answer
27 views

If A1 present in E:G, display E contents [on hold]

Kindly provide me a solution for this problem asap. I want A1 to be searched in cells E1, F1 and G1, if A1 is present in any of these mentioned cells, display the whole content of that cell in a new ...
0
votes
0answers
16 views

Need help in an excel Filter

My requirement is to make a filter such that if I select checkboxes 1,3 and 5 then it should return a single row with comma seperated values as 1,3,5 For eg I have the below data in a sheet. Name ...
0
votes
0answers
12 views

VBA QueryTables.Add fail to import text data in newly created sheet

Private Sub CommandButton2_Click() Dim MyFile As String Dim s As String Dim sheetname As String Dim curFile As String Dim dirpath As String Dim dirpathwild As String Dim ...
0
votes
1answer
36 views

Using Match function to copy rows with more than 1 criteria and incrementation

I had been trying to do matching of 2 criteria in a row on one worksheet and copy the whole row to another worksheet in the same workbook. As the loop goes on, the criteria will also increase like 1, ...
-1
votes
1answer
24 views

Excel.Application.Cells.SpecialCells(xlCellTypeLastCell) returning bottom of worksheet, not last data cell

I'm writing a method in VBA in Excel 2013 to loop through the rows in two worksheets and compare the text in a column from each. However, when I loop through, I'm finding that the code is looping ...
0
votes
1answer
16 views

Referencing cell containing filepath for sub

I'm using the following code to grab and resize a picture from file so I can print it out as part of a form. Private Sub CommandButton1_Click() ActiveSheet.Pictures.Insert ...
1
vote
1answer
31 views

Сondition on a cell that contains an IF stmt

I have cell A6 with a formula that looks for a content match of SS #'s in another cell B10 within a range of cells and displays the first record number if it there is a match: ...
0
votes
2answers
24 views

VBA to paste only values instead of paste every thing

I am working on a small project which requires me to search for a word through one column then copy the entire row that contains my word into another sheet. This is my code and what I have so far: ...
0
votes
1answer
48 views

Can someone help me optimize the VBA loop in excel

My worksheet have 6000 rows. This loop takes me more than 20minutes to finish. It is too long for me because I have many columns to run this loop. Can someone help me? Dim i As Integer For i = ...
0
votes
1answer
28 views

excel VBA : how to skip blank cells between 2 cells that contain values?

I am working out a button that can auto sum value at column C that column A = column B like the picture : PIC: I can only copy the value in column C (that the word in column A = column B) to column E ...
0
votes
0answers
30 views

Excel VBA - Split multiple sheets to multiple files with pre-defined format

I have a master file with 3 sheets as below: Sheet 1: (has 8 columns, I just use 2 columns as example) NAME VALUE1 A1 1 A1 2 A2 2 A2 3 Sheet 2: (has 9 cols) NAME VALUE2 ...
0
votes
0answers
16 views

Excel custom function, time execution (runtime) issue in a conditional sum

APPROACH: I have the following Excel sheet called “Daily Planning” for daily planning of tasks for some projects: http://es.tinypic.com/view.php?pic=i4pp4w&s=8#.U945LWMs8tE (I can not upload ...
2
votes
0answers
40 views

Excel VBA repeated change of a control cell hogs memory

I have searched on the web quite extensively, but have not managed to find any similar experiences. Any ideas? I have a simple subroutine in VBA that changes a control cell. This control cell is used ...
-3
votes
2answers
37 views

Using Excel VBA to Find, Convert and Replace Currency in a String

I have a Cell with a String like this (H/Y): As per un-audited half yearly accounts as on 30.06.2014 (Jan'14 to June'14), the Company has reported consolidated net profit after tax (excluding ...
0
votes
1answer
21 views

Sum function referenced to column number VBA

I need to reference columns by number in Sum function (i.e. Column B =2, C=3, E=5, etc) i tried this code but it didn't work (ColN is the column number read from a listbox index) Range("M5") = ...
1
vote
1answer
27 views

Why is my subscript out of range in vba?

I wanted excel to go through every single cell of a column, perform an operation on it and then copy the results on another column. This was my initial code: For i = 2 To dataRows ' Cells(i, ...
0
votes
1answer
49 views

Macro from Word does not work in Excel can it be modified for excel?

I realize that it is probably not supposed to work, but I have this visual basic code from a Word Macro that opens a piece of software linked to a piece of fluke equipment connectded to the computer ...
0
votes
0answers
37 views

Match Columns heading and Copy data across 3 worksheets

I have been trying to solve this issue for several days now with my limited VBA knowledge. I have also searched several forums and google in order to the desired solution but to no avail. While ...
0
votes
2answers
29 views

Excel: VBA to TRIM initial strings that vary in lengh

Good Day to all, I have VBA script that trims a specific lengnt of characters and then copies and pastes the remaining characters on another sheet but I've recently come across an issue. The initial ...
0
votes
0answers
23 views

Excel VBA: Populate combobox with column A if B = xxx

I'm relatively new to VBA and I'm stuck here. I have to populate a lot of dropdown menus (combo boxes, most of them in userforms) based on one database. The dropdown menus are in the sheet "TeamChart" ...
0
votes
0answers
39 views

Excel Macros: create dynamic sql by reading values from a column in the worksheet

I am creating a macro sheet wherein we'll be firing queries based on the query id selected at runtime. Eg: When a user runs the macro, he will be prompted for entering the query id. {completed} ...
0
votes
1answer
27 views

Controlling PowerPoint Using Excel-VBA (Minimize etc)

I just altered my code to make it compatible with all versions of office (hence independent of the PowerPoint 15.0 library). While the code works, I'm running into minor problems I need to address for ...
0
votes
2answers
27 views

Subscript Out of Range Error in Code

I have a macro that moves data from a master sheet to their respective sheets in a workbook by group and then creates a separate workbook of each of those sheets... But I have been getting an error ...
0
votes
1answer
33 views

How to obtain the data from cell from 500 .xls Excel files?

I'd like to ask you how can I get the data from few determined (and always same) cells from many Excel .xls files, I.e. I have a list of .xls files in one folder, and each file has the same table ...
1
vote
1answer
27 views

Strange behavior from VBA DataObject. GetText returns what is currently on the clipboard

I posted a question earlier about an error raised by the MSForms DataObject as accessed from Microsoft Office Excel 2013 VBA. As I was writing that post, I discovered other odd behavior that is even ...
0
votes
1answer
19 views

VBA Excel Context Menu - Hide all buttons and add my buttons only

I am looking for a way to hide all the buttons from the Excel context menu and just leave my buttons I created. I haven't found about it on internet. How can I do that? Thanks!
1
vote
1answer
21 views

Copying cells from one workbook to another works on step through but not when run

I'm writing up a sub which grabs specific cells from the active workbook (order form), opens a specified workbook (report) and drops in the values in a particular order. Oddly, this works just fine ...
0
votes
0answers
32 views

DataObject.PutInClipboard raises error “Not Implemented”

I'm attempting to use the MsForms DataObject to preserve the contents of the windows Clipboard during VBA code operations which use Copy/Paste methods of the Range object. Unfortunately an error is ...
1
vote
2answers
48 views

Excel VBA: Looking for Advice Avoiding an Infinite Loop

Imgur Album with screens of worksheets: http://imgur.com/a/6rFWF Long story short, I am writing an Excel VBA utility that will assign two types of security shifts (called coverages and weekend ...
0
votes
2answers
32 views

“Out of Range” error using record function to sort on Excel

I have a bit of experience programming but I have absolutely none with VBA. I have been using the record macro function in Excel with success, but I run into problems when I try to do a sort. All I do ...
2
votes
1answer
48 views

Disable all dialog boxes in Excel while running VB script?

I have some code in VB that saves all XLSM files as XLSX. I already have the code that will do that for me, but dialog boxes show up for every action. This was fine for a few dozen files. However, I'm ...
0
votes
1answer
42 views

Using a tree data structure in VBA

I am getting more familiar with VBA and I am attempting to do a machine learning program for Tic Tac Toe. I don't want to just hard code the possibilities to win. The best I have come up with for a ...
0
votes
1answer
30 views

Calling an existing worksheet with vba by using its code name in excel

I am trying to set the formula of a cell to an if formula that uses data from an already existing sheet within the workbook. However whenever trying to reference the sheet i get a file dialog box ...
0
votes
3answers
28 views

How would I put VBA process into a loop?

Edit: I figured it out, thanks to a helpful post. My final code is below. I am using Excel, and I've got this VBA script that looks for a string, copies it, then pastes it two cells down. What I'd ...
0
votes
4answers
38 views

Looping through cells, building a range in VBA

I am looking to loop through cells and build a range for a graph. My main issue is that I cannot figure out how to incorporate the 'i' into the range. Example: Dim name As String Dim newChart as ...

1 2 3 4 5 … 237