vba tag

72 questions

1 answers
116 views
0

How do I get the last row of multiple sheets and put them together into a new row in an Excel VBA or Google Apps Script?

Please check the sheet below first.https://docs.google.com/spreadsheets/d/1AlwgQLEZoZz_vWz0ZqKld528ViLAl8x2nR4SZz0VoHA/edit#gid=0There is an Excel file that records the monthly inventory of each produ...

google-apps-script vba excel google-spreadsheet

2 years ago

1 answers
56 views
0

Differences in VBA Behavior Between Excel 2016 for Mac and Office 365 Proplus (windows)

The VBA that runs on Windows Office 365 Proplus and Excel 2013 will not run on Mac's Excel 2016 for Mac.Regarding the following code that was listed as a sample, please let me know if it is a Mac vers...

vba

2 years ago

1 answers
102 views
0

Compilation error.: Not valid outside the procedure.Which error should I correct?

With ActivePresentation.Slides(1).SlideShowTransition .Speed=ppTransitionSpeedFast .EntryEffect=ppEffectStripsDownLeft .SoundEffect.ImportFromFile c:\sndsys\bass.wav .AdvanceOnTime=True .AdvanceTime =...

vba powerpoint

2 years ago

1 answers
53 views
0

Resolving PermissionError When Running Python on a VBA

Title error occurs when running python program on VBA.The error content is PermissionError: Permission denied: 'Excel filename .xlsm'Thank you for your cooperation.Here's the code for the VBA.SubSampl...

python python3 vba

2 years ago

1 answers
91 views
0

I want to create a search form with ACCESS

I would like to create a search form with ACCESS VBA.(Query - I think we can do the same thing, but this time we want to implement it in VBA.)As shown in the attached image, there are about 20 tables ...

vba ms-access

2 years ago

1 answers
109 views
0

Please tell me about Access VBA.

I would like to enter a number (integer) in the text boxes X1 to Y1 to find the sum.x1□~y1□sum□button□Private SubtnWa_Click()　 DimSouwa As Long lSouwa = 0 ForlSouwa= txtX1 TotxtY1 lSouwa=txtX1+txtY1...

vba ms-access

2 years ago

1 answers
47 views
0

I would like to specify a conditional format for Excel in C#.

Open an Excel file already created with c#, specify a range, and I would like to display the blank cells as yellow using the conditional format, but Excel.Range=sheet.get_Range;range.FormatConditions....

c# vba

2 years ago

1 answers
49 views
0

I want to use Excel VBA's internetexplorer.application to get values in a specific class in html in order

For example, the following html is available:To get the values (d, e, f) in span in the div of class2 in orderWhat should I do?<div class=class1><span>a</span> <span>b</span...

vba

2 years ago

3 answers
51 views
0

Is there a good way to deploy formulas when embedding formulas in cells with VBA?

Instead of adding cells in the VBA, When I wanted to embed an expression, I came up with a way to press it with a string.I succeeded just in case.I thought this was too redundant.I asked a similar que...

vba

2 years ago

1 answers
98 views
0

Error connecting ODBC to Oracle server.

This is my first question.Error code 3076 アプリケーションApplication Definition or Object Definition Error 」 when connecting to Oracle server using EXCELVBA.I tried several ways to resolve the error, but it ...

excel vba oracle

2 years ago

- 4 -

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