VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
0
votes
0answers
12 views
Excel VBA StrCmp sub or function not defined
I am trying to use the StrCmp function in excel vba (using excel 2007) and am getting the following error:
Compile Error:
Sub or Function Not Defined.
Here is my code:
...
1
vote
1answer
22 views
How to get object method (object.“something”), where method name comes from a list of strings (“something” is a string)?
I have a user form that contains lables. (I have to manually create each lable, since I can only place it in the correct spot by looking at the underlying image.) Each lable must go through the same ...
0
votes
0answers
38 views
Checking if a access table exists in Excel vba( dlookup or using sql)?
how to check if table exist and if it doesnt exist create table in sql server 2008
The link above I think shows what I am trying to do using sql in excel vba. I should say I don't really know sql, ...
0
votes
1answer
12 views
Import an excel table in a access file USING OFFICE 2010
i'm a newbye I have a problem with the vba code to import data from a table in excel file access. Using Office 2010, but the launch of the code gives me an error:
(translate from Italian)
run-time ...
0
votes
1answer
19 views
Make Connection to AS400 in Excel to update 2 worksheets with data from 2 Tables?
I have an Excel workbook with several worksheets. I need to connect to AS400 and make it to where when users click refresh, 2 worksheets ([Feedname] & [Feedprod]) are updated with data from 2 ...
2
votes
0answers
22 views
PrintOut prints groups of sheets instead of 1 group
We have this problem on many workbooks where we select a few sheets with VBA and print them using the following line and Excel will actually print multiple groups of pages instead of 1 group of ...
0
votes
0answers
15 views
Extract data from closed workbooks and enter into another workbook [closed]
I have looked for some VBA code to help me.
I want to be able to search an unlimited number of closed workbooks, saved under job numbers, for the result of worksheet ('Details' D12). This is an ...
0
votes
0answers
13 views
VBA Code to filter rows by date and then copy to master sheet
I have a workbook with multiple sheets and a master sheet. I would like to search through all of the sheets and select rows with dates in column A that are 120 days old or older and then copy those ...
1
vote
1answer
21 views
selecting max value excel using Cells(x,y) as input
How do you call the Max function in VBA using a range of Cells (x,y) as input?
E.g., I have two variables, m & n, where n > m
I try to find the Max value within a range of cells using the ...
0
votes
2answers
38 views
Need assistance with Macro - Excel
I have a =SUMIF formula that needs to be adjusted each time the macro is run. The 3rd part of the formula, the sum range, needs to shift over 1 column each time. I will be running this once a month ...
0
votes
2answers
27 views
Simple Open Workbook, Copy Sheet, Paste In New Workbook
I need a macro that will be able to do the following. I keep trying to come up with something but it keeps having bugs. I feel like it'd be easier to ask an expert to simply come up with one than ...
0
votes
1answer
19 views
“Object required” error VBA
I've got a Worksheet titled "Survey". I'm trying to attach checkboxes to all of the cells in column A that are next to answers, and for some reason I'm getting an "object required" error. The 4 lines ...
0
votes
1answer
19 views
excel vba sorting currency column descending
I have a sheet with 2 columns A has shopnames and B has currency values
I want to sort in descending order column B
Here's what I have done:
With Sheets("helpsheet")
.Sort Key1:=Range("A"), ...
1
vote
1answer
24 views
VBA: How to delete filtered rows in Excel?
I have an Excel table that contains some data. By using next vba code I'm trying to filter only blank cells in some fields and delete these rows
ActiveSheet.Range("$A$1:$I$" & lines).AutoFilter ...
1
vote
3answers
27 views
Excel VLOOKUP N/A error
I have a table setup like this:
I am trying to do a lookup, where Column D value matched one of the Column A values and returns Column C value.
The numbers in column A and D are stored as text.
...
