vba tag

72 questions

1 answers
42 views
0

Full release of standard modules and forms

I would like to open multiple standard modules and forms with multiple Excel files.I have looked into various things, but I hope that the logic itself will not disappear because it is necessary to re-...

vba

2 years ago

1 answers
53 views
0

Will the UDF of xlwings always be treated as a volatile function in Excel?

We are running the python function via xlwings on excel-macro as shown below.However, it is treated as a volatile function (recalculated as Open, Any-cell changes).What we've checked so far is 1) The ...

python vba

2 years ago

1 answers
91 views
0

Want to know how to insert Excel data into SQLite in VBA

Currently, SQLite is used to create systems to compare Config and Excel parameter sheets.I would like to create a VBA that writes Excel data to SQLite.Currently, we have completed creating the table.C...

vba excel sqlite

2 years ago

1 answers
86 views
0

I want Excel to display only certain tags in XML files using VBA

[!][Enter a description of the image here][1][1]I would like to extract only the <ImageData src=image> tag part of the XML in this image into Excel.The code is as follows.Thank you for your coop...

vba xml

2 years ago

1 answers
56 views
0

Outlook Mail Delivery Fails in Excel VBA in Office 365 OPP (64bit) Environment.

Please help me with the title.The following code, which worked properly in a 32-bit environment, will fail in a new environment:Reference settings have been checked for Microsoft Office 16.0 Object Li...

excel vba

2 years ago

1 answers
52 views
0

Error in 』で on VBA SPLIT

Thank you for your help.In Excel or Access VBA, if 』が is included in the string, the error There is insufficient string space.Problem, I think it's already been collected for a long time, but the roo...

vba

2 years ago

1 answers
43 views
0

Setting and Retrieving Property Values Without Equal Signs

Example of Excel bar graph: If you set the bar to a shaded display and record the macro, it appears to be an exceptional description without an equal sign (mixed expression of the .Fill attribute).Wit...

vba

2 years ago

1 answers
45 views
0

Wildcard a file in a folder and get the update date and time

Thank you for your help.In the EXCEL VBA, file in a folder (C:\TEST\test1234.txt) in an if statement.If wildcarding (test*.*) equals, update the date and time of the file I would like to implement the...

vba excel

2 years ago

1 answers
107 views
0

How to prevent the form from being opened when opening another access from AccessVBA main access

Thank you for your help.In Access 2010, when you open other access in the VBA, you try to open it in the OpenCurrentDatabase However, if the caller has access to the specified form, the form will be I...

vba ms-access form

2 years ago

1 answers
44 views
0

If you do not press Cancel in the dialog that appears when the macro is executed, the process will not proceed.

This is a question about Excel VBA.When you run the macro you created, the Downloading and Saving dialogs appear, and you must press the Cancel button to proceed.(See attached image) I would like to k...

excel vba

2 years ago

- 7 -

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