vba tag

72 questions

2 answers
121 views
0

Cannot access array elements in COM created with C#

I am making a COM for Excel with C#.Parameter.cs ClassInterface (ClassInterfaceType.None)ComDefaultInterface (type of (IParameter))]ComVisible (true)public class parameter{ public Member [ ] Members {...

c# vba com

2 years ago

2 answers
49 views
0

I want to overcome the situation where the screen hardens until the Excel VBA procedure is finished.

Procedure Description: There are more than 100 lines of data on the sheet.The content of the ABC column is keyed to go to SQLServer to retrieve data one line at a time and store the results in the col...

vba

2 years ago

1 answers
54 views
0

Understanding VBA Cell Range("") Expression Deployment

Is it possible to expand the range expression in vba?It seems that you can string, but is it possible to range it?What I want to do is the code below.Color only certain cells=>cells() 'This code su...

vba

2 years ago

1 answers
120 views
0

I want to do RPA in VBA, so please give me a hint.

Using SendInput, SendMessage, FindWindow, etc. from Windows API user32, I am thinking of copying from Excel to several text boxes in other application software in VBA.However, ①Paste occurs even if th...

windows excel vba winapi

2 years ago

1 answers
137 views
0

Access VBA fails when EXPORTing to AZURE SQL

When the Access VBA attempts to EXPORT to AZURE SQL using the following instructions, an error occurs if the table exists on the server:DoCmd.TransferDatabase acExport, ODBC Database, ODBC; DSN=test; ...

azure ms-access vba sql-azure

2 years ago

1 answers
114 views
0

How does VBA connect to MySQL installed in Bitnami Redmine?

I installed Redmine from Bitnami.I want to use Redmine data in Excel, so I want to use VBA to connect to MySQL to get data, but I don't know how to connect.I am thinking of connecting with MySQL ODBC ...

mysql vba bitnami

2 years ago

1 answers
109 views
0

Understanding How to Find Characters That Have Been Painted

I have a question about Word's VBA fill properties.Search for grayed-out areas in the number list VBA and get a selection)I want to unpaint the painted part and put <> before and after that part

vba ms-word

2 years ago

3 answers
81 views
0

I'm looking for a tetrahedral (triangle pyramid) inscribed sphere sympy. I tried it on the vba solver.

四 I'm looking for the sympy of the tetrahedral (triangle pyramid) inscribed sphere.In other languages.②I tried running it on the vba solver. Please tell me how to shorten the vba code.Only one example...

vba sympy

2 years ago

1 answers
107 views
0

And the program of summing up from the other side doesn't work.

I would like to create a program that asks for the sum of X to Y.You also have to create a program that you want from the other side.Exit Sub is not available.It does not respond when looking for a la...

vba ms-access

2 years ago

1 answers
44 views
0

Macro VBA reports "BASIC Runtime Error".What's the problem?

I'm a macro beginner.I'm currently studying macros, but when I tried to execute the following code, BASIC Runtime Error Sub or Function Procedure UndefinedThe error appears and cannot be processed.Wha...

vba

2 years ago

- 6 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656