Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Login
Remember
Register
Ask
Q&A
All Activity
Hot!
Unanswered
Tags
Users
Ask a Question
Ask a Question
Categories
All categories
Topic[话题] (13)
Life[生活] (4)
Technique[技术] (2.1m)
Idea[创意] (3)
Jobs[工作] (2)
Others[杂七杂八] (18)
Code Example[编程示例] (0)
Recent questions tagged Excel
0
votes
734
views
1
answer
excel - Start VBA macro when editing a cell
I simply try to write a search macro in an excel sheet. How can I start a macro dynamically DURING editing ... cell was selected). Thanks. See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
712
views
1
answer
excel - VBA Worksheet Change Event
I am trying to use the Worksheet Change Event in Excel VBA, but it doesn't seem to work. From what I gather, ... don't know much about it yet. See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
750
views
1
answer
excel vba: make part of string bold
I have excel cells which contain entries like this: name/A/date name/B/date name/C/date Cell content is ... entry. Anyone got an idea? See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.2k
views
1
answer
excel - how to solve Exception:Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED)) in C#?
I have written a C# code in console application to open two excels and copy and paste data from one excel to ... ) How to solve this one? See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
779
views
1
answer
excel - Remove double quotation from write statement in vba
This code will write log file to LogFilePath, and generate output as below. StarRange and EndRange is a variable ... A1 End position = B100 See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
619
views
1
answer
excel - Performance difference between looping range vs looping array
Will there be any difference in performance (speed) when looping through a range Vs assigning the same range to an Array and looping an Array? See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
647
views
1
answer
excel - Change font color for specific char in a cell range
I would like to change the font color for a specific character within a range of cells. I figured out how to do ... 221) End If Next i End Sub See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
514
views
1
answer
excel - Read .txt from .zip files
I need to open a few .zip files, view a specific .txt and write what's inside of this .txt file to an ... take what's inside of the md5.txt See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
592
views
1
answer
excel - VBA for filtering columns
I have a big database-like sheet, first row contains headers. I would like a subset of rows of this table based on ... ("A1") End With End Sub See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
600
views
1
answer
excel - How can I evaluate a string into an object in VBA?
In my previous question, How do I assign a value to a property where the property name is supplied at ... SomeFunction from the example above? See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
574
views
1
answer
excel - How to distinguish if sumproduct needs to be inserted with CSE or not?
I sometimes use the inherent array functionality of sumproduct to avoid havingt to enter formulas with Control + Shift ... the second does not. See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
639
views
1
answer
excel - Multiply Entire Range By Value?
So The best way I could think of to accomplish this over a large range (about 450k rows) was to use ... better ways of accomplishing this task? See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
639
views
1
answer
excel - Office 2016 -> 2013 "compile error, can't find project or library"
I just upgraded to Office 2016, which most of my users haven't done, and I'm getting a new error when users try ... code Set app = Range("A2") See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
499
views
1
answer
excel - How can I open this VBA workbook faster?
I am currently trying to make a macro that will go to a directory, open a workbook (there are 38 currently with ... + 1 Next Next End Function See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
652
views
1
answer
excel - Changing array values in a VBA dictionary
I have a piece of code that does not seem to do what it is expected to do. VBA Arrays are mutable by all means ... 2, which is not fine End Sub See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
824
views
1
answer
excel - reading entire text file using vba
I'm trying to read a text file using vba. I tried the below code Open "C:ester.txt" For Input As #1 ... more stuff Thanks in advance for help. See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
519
views
1
answer
excel - Get data from multiple sheets in a selected workbook
I'm new to macros in Excel and I need to make a macro that get data from multiple sheets in a ... readable. SummarySheet.Columns.AutoFit End Sub See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
981
views
1
answer
excel vba how to copy the value of multiple non-contiguous ranges into an array
I am trying to copy the value of multiple non-contiguous ranges into an array. I wrote code like this: ... range("A14:D15")).Value See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
569
views
1
answer
excel - Access files with long paths (over 260)
I'm using Microsoft Scripting Runtime (FSO) to parse folders and produce a list of all of its contents, the ... , size created, and modified. See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
771
views
1
answer
excel - Read and write from/to registry in VBA
I saw this line in C# and I am trying to adapt it to VBA: Microsoft.Win32.Registry.SetValue(@" ... myWS.RegWrite i_RegKey, i_Value, i_Type See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
590
views
1
answer
excel - How can I loop through a subset of worksheets?
I know how to loop through all the worksheets in a workbook, and how to exit once I reach an 'end-flag' ... ' code here Next LoopIndex End Sub See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
634
views
1
answer
excel - Split text in cells at line breaks
I am working on an Excel spreadsheet that has data in 39 columns. One of these columns, column AJ, is a ... maybe I have adapted it incorrectly. See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
573
views
1
answer
excel - Record cannot be read; no read permission on 'MSysObjects'
I'm trying to get a list of all tables from an Access 2007 ACCDB format database using Excel VBA. I have ... sure. Does anybody have any idea? See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
582
views
1
answer
excel - How to roundup a number to the closest ten?
Probably the title is not very suggestive. Let me explain you with an example. I have: 12345.6 2345.1 ... rather use formulas instead of VBA. See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
719
views
1
answer
excel - VBA - Range to jpg picture
I'm trying to get a jpg file from a specific range in excel I'm currently getting the 1004 Runtime error on Range ... :="JPG" End With End Sub See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
583
views
1
answer
excel - AutoFilter - Use of SpecialCells
Background: For many times I have applied AutoFilter and never really asked myself why it works the way it does ... = Var .AutoFilter End With See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
880
views
1
answer
excel - Application.WorksheetFunction.Match method
I have seen a lot of Topics to the "unable to get the match property of the Worksheetfunction class" problem. But ... was my error in the code) See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
474
views
1
answer
excel - PyInstaller and python-docx module do not work together
I am trying to make an executable of my program to give to my FTC team. Everything works but when I try to ... .pack() Quit.pack() mainloop() See Question&Answers more detail:os...
asked
Oct 17, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
Page:
« prev
1
...
17
18
19
20
21
22
23
24
25
26
27
...
61
next »
Ask a question:
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question
Just Browsing Browsing
[1] vue+flask的前后端分离项目,通过nginx处理跨域时对post请求无效
[2] linker - I am missing something fundamental with CMake in a complex library dependency structure
[3] R compare date from one column with dates in many columns
[4] C语言关于指针的疑惑
[5] 设置理想视口后,如果内部元素设置的宽度大于视口宽度,为什么body不会撑开,元素会超出body?
[6] 请问nodejs中writeFileSync生成的文本是乱码, 我应该从哪几个方便检查?
[7] angular - cd.markForCheck and cd.detechChanges not updating children
[8] javascript - Match exact string
[9] TypeScript泛型默认值没效果
[10] ES6 async函数里包含另一个async函数是为什么?
2.1m
questions
2.1m
answers
60
comments
56.9k
users
Most popular tags
javascript
python
c#
java
How
android
c++
php
ios
html
sql
r
c
node.js
.net
iphone
asp.net
css
reactjs
jquery
ruby
What
Android
objective
mysql
linux
Is
git
Python
windows
Why
regex
angular
swift
amazon
excel
algorithm
macos
Java
visual
how
bash
Can
multithreading
PHP
Using
scala
angularjs
typescript
apache
spring
performance
postgresql
database
flutter
json
rust
arrays
C#
dart
vba
django
wpf
xml
vue.js
In
go
Get
google
jQuery
xcode
jsf
http
Google
mongodb
string
shell
oop
powershell
SQL
C++
security
assembly
docker
Javascript
Android:
Does
haskell
Convert
azure
debugging
delphi
vb.net
Spring
datetime
pandas
oracle
math
Django
联盟问答网站-Union QA website
Xstack问答社区
生活宝问答社区
OverStack问答社区
Ostack问答社区
在这了问答社区
在哪了问答社区
Xstack问答社区
无极谷问答社区
TouSu问答社区
SQlite问答社区
Qi-U问答社区
MLink问答社区
Jonic问答社区
Jike问答社区
16892问答社区
Vigges问答社区
55276问答社区
OGeek问答社区
深圳家问答社区
深圳家问答社区
深圳家问答社区
Vigges问答社区
Vigges问答社区
在这了问答社区
DevDocs API Documentations
Xstack问答社区
生活宝问答社区
OverStack问答社区
Ostack问答社区
在这了问答社区
在哪了问答社区
Xstack问答社区
无极谷问答社区
TouSu问答社区
SQlite问答社区
Qi-U问答社区
MLink问答社区
Jonic问答社区
Jike问答社区
16892问答社区
Vigges问答社区
55276问答社区
OGeek问答社区
深圳家问答社区
深圳家问答社区
深圳家问答社区
Vigges问答社区
Vigges问答社区
在这了问答社区
在这了问答社区
DevDocs API Documentations
Xstack问答社区
生活宝问答社区
OverStack问答社区
Ostack问答社区
在这了问答社区
在哪了问答社区
Xstack问答社区
无极谷问答社区
TouSu问答社区
SQlite问答社区
Qi-U问答社区
MLink问答社区
Jonic问答社区
Jike问答社区
16892问答社区
Vigges问答社区
55276问答社区
OGeek问答社区
深圳家问答社区
深圳家问答社区
深圳家问答社区
Vigges问答社区
Vigges问答社区
在这了问答社区
DevDocs API Documentations
广告位招租
...