Excel-VBA (Visual Basic for Applications for Microsoft Excel) is the dominant programming language for Microsoft Office Excel. It is an event-driven and object-oriented programming language for writing macros for Microsoft Office applications like Excel.
0
votes
0answers
13 views
VBA Excel Copy Clipboard data to array
I am working in a project where i have to to copy some text from a web page using Crt A + Crt C then i want to use this Data in Excel
the copyed text is about 100 lines with defrent sizes let say ...
2
votes
1answer
22 views
Trying to find the last non-empty row in Excel with VBA, but it's acting weird
I have a really simple program to make, there are some textboxes and a button, which when clicked writes the values in the textboxes in a row, here's a screenshot: https://i.imgur.com/CmwK8Q4.png
And ...
-1
votes
2answers
24 views
How do I enclose an Excel cell contents with parentheses for an entire column?
I have an Excel document with data needs to be enclosed with parentheses.
data for 1 cell would look like:
1234,'2000-01-01',3750000.000000,3750000.000000,3750000.000000,3750000.000000,0
I ...
0
votes
0answers
10 views
Excel 2016 not writing data in any cell when trying to set values of a range having locked and unlocked cells
I have an excel workbook with one blank worksheet such that the worksheet is protected and in that, the protection of few cells, say A1, A3 and A4 is set as unlocked whereas that of cell A2 is set as ...
0
votes
2answers
21 views
Faster Workflow
I have a table (Table 1) with a whole bunch of well data (versions, MD, HD, etc.) and I want to create another table (Table 2) that will only show the data for the well I am interested in.
I have it ...
0
votes
2answers
14 views
Selecting multiple variable cell ranges in Excel with VBA to draw borders
I have a tab that automatically receives data extracted from another part of the spreadsheet. There are always three columns with data for the report: col A has task descriptions, col B has labor ...
0
votes
0answers
3 views
Can't download file via Webdav for Excel 2013 in VBA
I am trying to download a file via Webdav in VBA and it works for Excel 2010 and 2007, but does not seem to be working for Excel 2013 (may have to remove "PtrSafe" to get 2007 to work). Any thoughts ...
-3
votes
1answer
17 views
Loop through value is column and delete the row if any values that starts with 35
I am new to VBA for excel and I am stuck with a little problem. I trying to find a way for looping through all the values in column B in my spreadsheet which is the account number of a customer.
I ...
0
votes
3answers
10 views
Set variable columns between worksheets
Who wants easy points? I am trying to set a range of columns from one sheet to another using variables. startm will always be an integer. I know I can do something like this or this but I hate ...
0
votes
2answers
24 views
Processing Excel files
I have some 40-50 excel files that have useful information in the first 20x25 cells and then junk beyond these cell. What is the easiest way to clean up the junk from all the files in one fell swoop, ...
-4
votes
0answers
17 views
It's a VBA : I want to import two text files from a specified folder
Excel VBA : I want to import two text files(from a specified path) and save them in individual sheets of the same workbook with the same name as the text files. I recorded a Macro but it doesn't seem ...
-2
votes
0answers
17 views
Autofill formulas
I am using Excel 2013.
What is the macro code to autofill formulas till the last row in a column?
The last row may vary every time I run the macro, it might be Range B140 or Range B1111. If I ...
1
vote
0answers
22 views
ActiveX spreadsheet control disables workbook_open event
I have inserted an ActiveX spreadsheet control into an Excel VBA form.
I have written a procedure in the ThisWorkbook.Workbook_Open() event and it will not execute upon opening the workbook when ...
1
vote
2answers
22 views
How do I Sum a total based on Grouping
I've got data (which changes every time) in 2 columns - basically state and number. This is an example:
Example Data
State Total
Connecticut 624
Georgia 818
Washington 10
...
1
vote
0answers
14 views
Disable “… not supported by Excel for Mac 2011” dialog box
When I use the following line to open an xls file, sometimes there is a dialog box popping up.
Workbooks.Open Filename:=path & fFile, UpdateLinks:=xlUpdateLinksNever, Password:="", ReadOnly:=True
...
2
votes
1answer
28 views
Counting Colored Cells from a Conditional Formatting statement
So I'm revisiting this from yesterday:
Multi-column vlookup conditional formatting
Everything is working as intended with the conditional formatting statement that Scott Holtzman provided (Thanks ...
-1
votes
1answer
12 views
Duplicating an excel spreadsheet and titleing them from a list
I Have a Workbook I'm using as a base template that I need copying many times and I need the excel workbooks to be named from a list I've created in Excel.
Any help would be much appreciated!
1
vote
0answers
14 views
Searching contact in Outlook by UserID using VBA
I'm new on this forum so let me say hello to everybody first.
I've been working around VBA for some time now and usually was able to get where I need with my own wits and some help from this forum ...
0
votes
1answer
19 views
How can I do a simple join on a subquery?
I've been at this for 2 hours and have no idea what the issue is. Although I have worked a fair amount with SQL, I'm struggling with the idiosyncrasies in Access queries relative to SQL queries when ...
2
votes
2answers
21 views
Returning array from subroutine gives: Compile error: Can't assign to array
My goal is to return array from subroutine. I've been following this tutorial. Here is my code:
Function FuncReturnArray() As String
Dim Films(1 To 5) As String
Films(1) = "Lord of the Rings"
...
0
votes
1answer
8 views
Application-defined or object-defined error (run-time error 1004)
I am getting the run-time error 1004 when trying to clear the contents of cells and reset their respective colour. I unprotect the worksheet first, then try to clear the cell contents and reset cell ...
-6
votes
0answers
14 views
How to copy only formatted cells into rows with column name in vba
How to copy only formatted cells from one sheet to another into row wise with their column name from vba in excel
-1
votes
0answers
14 views
VBA code to convert a PDF to a word document and excel sheet
Currently, I need help in VBA Code.
I need VBA codes that can help me convert a PDF to a word document and excel sheet.
0
votes
1answer
17 views
RunTime Error 91 Object variable or With block variable not set
I am new to VBA for excel and I am stuck with a little problem. I have a list of data and I have two task I want to complete.
The first will delete rows with any values in the J column that is equal ...
0
votes
2answers
18 views
Loop stops working and does not continue when the value is wrong
I am creating a code for sending email. The program will do a looping in every row and check whether the value in the first column is "yes" and then send the email.
The program seems work well when ...
0
votes
0answers
18 views
How to get started building Excel Add- Ons? [on hold]
I would like to get started making my own Excel Add-Ons. I honestly do not know much about how or where to start, except for maybe in Visual Studios project templates option for making Excel add-ons. ...
3
votes
1answer
43 views
Regular Expressions in Excel VBA
I'm using the Microsoft regular expression engine in Excel VBA. I'm very new to regex but I have a pattern working right now. I need to expand it and I'm having trouble. Here is my code so far:
Sub ...
0
votes
1answer
30 views
How do I grab the string and adjacent number in multiple columns
I want to run a loop to group the text by certain criteria and add up a total, but I need to be able to grab both bits of data.
Connecticut 624
Georgia 818
Washington 10
Arkansas ...
1
vote
0answers
11 views
I would like to create a Macro within an Excel Workbook that will compare tables in another workbook to corresponding tables in DBX
I am very inexperienced with VBA but I am trying to create a macro in and Excel Work Book that will compare static data in another workbook to its corresponding table in SQL DBx
I can successfully ...
0
votes
0answers
20 views
Create/copy/duplicate form button in shared workbook
I'm trying to create/copy/duplicate or whatever in excel VBA in shared workbook. My goal is to create new button, when workbook is shared.
In standart worksheet mode I tried which works in standart ...
0
votes
1answer
17 views
How to Have User Specify Run Location of Macro?
I would like to create a multi-purpose macro workbook with a bunch of different macros attached to various buttons. I would then like the user to be able to click a certain button and then be able to ...
0
votes
0answers
28 views
How to convert an array into recordset in vba (either column wise or directly)
I have an array which need to be converted to a recordset using VBA Macros.
I have code which is converting the array to a recordset by cellwise. it is taking too much time to update the recordset.
...
0
votes
0answers
17 views
Excel-VBA: Userform window reposition with ScreenUpdating = False
I've created a few userforms in a Excel workbook and whenever a user starts one I set Application.ScreenUpdating to false.
But when the user moves the userform around it always leaves a copy behind ...
0
votes
0answers
14 views
Send selected range via email with htm signature by vba
I need to send selection range from excell by email and add signature from htm file. I have next code to send selection and it works well:
Sub Send_Selection()
'Working in Excel 2002-2013
Dim ...
0
votes
0answers
18 views
Reference external open workbook.worksheet“sheetname” for search then select
I am using Excel 2010 and successfully used excel formula to search for a string in column A from workbook1, worksheetA for text based on the text entered in cell V18 in workbook2, worksheetB. My ...
1
vote
1answer
19 views
attachement in email VBA excel
I am trying to send an email through vba in excel, all works fine excpect the email attachement. It doesnt seem to link it. Where could be the issue ?
The string attach is pointing to the right file.
...
-3
votes
0answers
20 views
I have 1 Excelsheet in which Have Saveral Columns
Can you please help me below question i am in big trouble please help me
I have 1 Excelsheet in which Have Saveral Columns and i wanted to show that data in listbox if data is duplicate then it would ...
0
votes
1answer
17 views
VBA Excel - How to Automatically Fill a date in multi-columns if i filled column A
This is my first time to write a code and i try to write a code thats helps me to fill Columns B, C and D Automatically thats will happen when i fill Column A by myself.
this is the picture of that ...
0
votes
1answer
12 views
How to do Vlookup to fill down entire column till the last data
I need the vlookup to fill down the entire column in D the (department name) of the relevant cost code, starting from D6.
Column B of the data has cost code.
Column D is where I want the department ...
0
votes
0answers
31 views
Do While loop not working to perform a task with excel
I was working with a vba code but while running my code is not able to loop through the cell values in coloum B of the worksheet. Its just copying the first value and pastng in internet explorer as ...
0
votes
1answer
22 views
Update Access table from Excel- says current record has been deleted?
Basically I've got some code here that updates Access from Excel, it does this via seeing if the 'Monitoring ID' equals the 'IngID' which is essentially the Monitoring ID. So basically if they match, ...
0
votes
2answers
15 views
ExecuteExcel4Macro - Run-time error 1004
Keep getting Run-time error 1004 "The formula you typed contains an error."
MyCode :
Private Sub UserForm_Initialize()
Dim wbPath, wbName, wsName, cellRef, Ret As String
Set xlApp = ...
0
votes
1answer
13 views
VBA Web Scraping: How do you save a pdf doc to your personal folder
Is there away to save a pdf Document opened in an IE Web Browser to your personal desktop folder using VBA? sorry, I don't have code, because I really don't know where to start.
Thanks.
0
votes
0answers
15 views
Filter the list in a combox in vba form as you type
I have a problem on how to apply filter in a combo box and requiry records.
I am using a combo box named Customers which contains names of all customers (approx 3000) from an array called ...
0
votes
1answer
26 views
Just want to show a Popup Or Status bar during running of VBA code
I have a long code & taking approx. 1 min 30 sec to execute , So I want to show a Status bar showing "Please wait...running" or a popup with the same message or anything else which on will be ...
0
votes
1answer
16 views
Get the last column character dynamically and pass it
Excel VBA: I am trying to get the last column character dynamically and pass it as last column while selecting the range for sorting. But it doesn't seem to work here is the code
Sub ...
1
vote
2answers
19 views
Excel Formula or VBA to convert year, month data to actual date
I have 2 columns (year and month). A sample data of year column A is 2015 at cell A2. A sample data of month column B is Jun at cell B2. I would like to convert these data to date format in column C ...
-3
votes
0answers
12 views
Populate a listbox and/or textbox with Excel worksheet data
I have tried To Display Duplicate Excel Data On ListBox1 if not duplicate data then it will show on Given Text Box.
Can Anyone Help Me Regards The Same
enter image description here
0
votes
0answers
8 views
Microsoft Excel VBA Calculator 2010 can it convert to 2013? [on hold]
I created a VBA calculator using excel.
I believe it was done on the 2010 version of excel and now when I use the most up to date version it will not allow me to display new data.
Is there a way for ...
0
votes
1answer
18 views
Evaluate sumproduct in vba
I can't evaluate the sumproduct at the end of the code. I think everything else is working but I keep getting the
Type Mismatch Error
I've tried all sorts of variations of syntax and I still ...
