excel tag

82 questions


1 answers
63 views
0
The object does not support this property or method (error 438)

I would like to read the table values from BAPI BAPI_USER_GETLIST to determine if the user exists.Public Function CheckUser (iCurrentRow As Integer) As Boolean Variable for storing DimoBAPIUserCheckAs...

2 years ago

2 answers
105 views
0
What characters can I use for access and Excel passwords?

Please tell me all the characters that can be used as passwords in MS Office access and Excel.I remember seeing that you can use the code that you can specify in the Char function on some site, not to...

2 years ago

1 answers
57 views
0
How do I get values for specific columns and rows in Excel?

Regarding the subject, If you have a table, There are several rows of values in the table.What I want is not column A, but column B, second row and subsequent cell values.Loop with For Each and exit w...

2 years ago

1 answers
52 views
0
Understanding VBA (Excel) Processing Speed

If you read the log file (about 70,000 to 80,000 lines) and there is a blank space in column A, This is the process of deleting the column, but this process alone is It will take about 3-5 minutes.Exc...

2 years ago

3 answers
92 views
0
I want to round up and devalue the time.

I'd like to round up and devalue my attendance data.I'd like to round up every 30 minutes.The working hours are as follows, and the break time is 70 minutes, so the work hours are not separated by cle...


2 answers
86 views
0
Obtain the number of files in the folder directly below the drive and the last update date and time

Suppose you have a folder directly below the drive as shown below.C:\AC:\BC:\CI would like to aggregate the number of files and the last update date and time on EXCEL for folders A, B, and C just belo...

2 years ago

1 answers
55 views
0
Setting the Page Direction in PHPExcel

I am using PHPExcel, but I would like to set the page direction in Excel page title ->print title -> sheet, but is it possible to set it on the PHP side?I am using Excel 2010.

2 years ago

1 answers
64 views
0
Configuring pivotem.visible

pivotitem.visible appears as integer during debugging.true, falsecannot be configured.excel VBA 2010

2 years ago

2 answers
57 views
0
I want to convert html to xls format without Microsoft Office

I am using .NET Framework 3.5.The target program uses Microsoft.Interop.Excel.dll to convert the Html format file to an Xls format file, but the target customer environment still has Excel installed, ...

2 years ago

1 answers
109 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...

2 years ago
« - 5 - »

© 2024 OneMinuteCode. All rights reserved.