Tagged Questions
2
votes
1answer
33 views
SQL Searching a String for Numbers between different criteria
I have been attempting this issue for a while and have yet to find a solution.
I am looking for a method using SQL commands to Search a String for an alphanumeric number between 2 points.
For ...
1
vote
1answer
18 views
Excel VBA - Intercept AddIn Ribbon Click
i would like to know if it is possible to intercept the event generated by the Ribbon Button of an Excel Addin. I'm able to access to the .xlam source but seems there is no code in it that intercept ...
0
votes
1answer
24 views
How can I pull data from multiple files in Excel using Visual Basic?
I have an Excel problem that should hopefully be quite easy (logic-wise), but my knowledge of Visual Basic is very limited. I have a few folders with about 30 .xlsm files in them each (each file ...
0
votes
1answer
22 views
Excel VBA Function Recalculation
I wrote a small Excel VBA Function "MyTableResults"
Public Function MyTableResults(Code As String) As Variant
Which returns a decimal value from the Database using query filter based on the ...
-2
votes
1answer
24 views
Comparing values in 2 ranges and inputting not matching ones in VBA Excel
I need to write a macro in excel that would compare each value in a selected range with other range in other sheet. If in that range the value is not present then it gets added to the end of the ...
6
votes
0answers
193 views
Returned Recordset is closed (mysql DB accessed via ODBC in VBA)
Long time viewer first time poster. I'm working on a database application with a front-end in Excel. Hence I am using VBA to access a MySQL database. The driver I'm using is the ODBC driver (Windows) ...
4
votes
0answers
34 views
SAP: SAPGUI Parse GuiUserArea
Problem!
Currently at the place that I work We are trying to perform some kind of repetitive task via automatically with the usage of SAPGui, Excel & VBA. Usually, the most of the reports that ...
4
votes
0answers
410 views
Office 2013 Excel .PutInClipboard is Different?
I've used a routine for years to put a plain text string into the clipboard that I can paste into another program such as:
targetData.SetText "This is a plain text string"
targetData.PutInClipboard
...
2
votes
0answers
31 views
I am using a macros to do a mail merge, how can I keep the Chinese numbers in the word output?
I used a solution from stackoverflow to do the mail merge through a macros, it works fine but there are some chinese character numbers which becomes arabic numbers after the mail merge. Normally if i ...
2
votes
0answers
77 views
read pixel colors of an image using vba in excel
I am trying to read each pixel's color of a loaded image (or unloaded) in excel file using vba,
IS there any way?
I have seen the similar codes for vb (using getpixel) but I want the code for vba,
...
2
votes
0answers
70 views
Excel for Mac 2011 - Run-time error '-2147483640 (80000008)'
I'm new here so appreciate all the help you can give me and apologies if my question doesn't conform to an adequate standard.
I have been experiencing some unusual behavior while using MS Excel for ...
2
votes
0answers
86 views
Extracting a Specific Variable from a Class Module in VBA to a Standard Module
All,
The following code is from Bloomberg. It is designed to extract bulk data from their servers. The code works, but I am trying to extract a specific variable generated in the class module and ...
2
votes
0answers
128 views
Paste many excel charts to Word as links
I'm trying to write C# code to Copy-Paste charts from Excel and use Paste Link in MS Word, because with Excel, when you use Paste Link for the tables, text, charts, etc. I can click update all fields ...
0
votes
0answers
11 views
Excel VBA - Finding workbooks by name and copying and pasting worksheet to another workbook*
i'm new to this so this should be fairly easy. I need to find an open workbook by the rightmost characters in the workbooks name, then copy a worksheet and place that worksheet in another open ...
0
votes
0answers
18 views
How to turn a string value into a usable data from a serialized .xlsx file in excel using VBA
I have very limited experience with VBA and excel.
So I have a server which generates reports in .xlsx format for users to download. I'm trying to have an excel macro grab the data from the generated ...
