VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
0
votes
0answers
5 views
Handling error in Pivot source update
I have create macro to change the source of Pivot in all worksheets. In my workbook there has sheets one with CityName, like 'Mumbai'(Which is pivot sheet) and source data sheet with Name ...
0
votes
0answers
18 views
VBA: Copy number from a string of text and insert into cells below
I want to create a makro in Excel which performs - after pressing a button - the below. I attached some dummy data that is formatted like the actual sheet.
There are several data blocks that are ...
0
votes
3answers
13 views
vba filter update in function
For some reason the filter doesn't apply as I cannot see any changes. The function seems to enter the correct values, but only if I manually click OK in the "custom filter" it updates the screen.
So ...
0
votes
1answer
8 views
How can I read binary data from mysql in excel vba?
I got some problems to read binary data when I wish to import data from MySQL by using excel-vba.
There is only one column in Table, and the data type is binary.
Following is my code
Private Sub ...
0
votes
0answers
15 views
Excel Formula in VBA with spaces in worksheet
Formula in VBA with spaces in worksheet
Postzegellikker Postzegellikker is offline Yesterday, 23:44 MS Office Version: Ms Office 2010 MS Office Skill Level: New to MS Office
Mark this thread as ...
0
votes
1answer
33 views
Converting Special Characters into alphabet
I have an excel file with Name column which is in different language.I need to convert this names into Standard English language.
Example:
HỒ ĐĂNG TẤN has to be converted to HO DANG TAN.
NGUYỄN ĐỨC ...
1
vote
2answers
24 views
How to avoid the editing of a macro in Excel?
I have written a macro in Excel. When I send it to some user, he should not be able to see the macro.
Say I have a Excel workbook sample.xls, and it has a macro button to save the workbook to the ...
-1
votes
0answers
17 views
Design choice for quotation/reporting system [closed]
I would like to create a system that can generate a report/quotation that contains a cover letter, table of contents, pricing summary, product specification etc. The cover letter should be chose from ...
1
vote
1answer
35 views
Importing data from access into an open excel spreadsheet? (Excel VBA)
I am trying to make an application that has the feature to import data from access into excel. I am starting with a table named ""1301 Array"" before I give user control over which table. The problem ...
2
votes
1answer
48 views
I need to find press a button on a webpage using Excel VBA Macro
I have written a macro that will open a webpage, find the spots I need to put the data into, and then I want the macro to hit a prefill button, then hit Ok.
The page source code for the button is:
...
0
votes
2answers
32 views
Excel – Programatically get the data used in a chart
I have a big set of charts that all use different collections of series in a single large Excel spreadsheet.
For each chart, I need to provide a data table containing only the data used in that ...
0
votes
2answers
55 views
Excel VBA- Average all numeric cells in a worksheet
I'm trying to create a macro that iterates over all used cells in a worksheet and return the average.
The eventual goal is to get the average value of the numbers in each worksheet, and produce a line ...
0
votes
1answer
20 views
I'm trying to get a value to enter in a specific first cell/row. My forumula is:
Sub CheckBox7_Click()
Dim cBox As CheckBox
Dim LRow As Integer
Dim LRange As String
LName = Application.Caller
Set cBox = ActiveSheet.CheckBoxes(LName)
'Find row that checkbox ...
0
votes
1answer
30 views
Why doesn't isError( ) work with a vlookup statment in excel VBA
I'm using excel 2007 and have created a UDF that includes three vlookup() statements. The function is supposed to return the sum of all three vlookup statments. In the majority of cases, only two ...
1
vote
1answer
26 views
Close/Release Word object in VBA?
I have the following code to open the manual for an Excel Workbook application I have developed:
Sub OpenManual()
'Word.Application.Documents.Open "\\filePath\FormFlow To ...
