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 vba
0
votes
960
views
1
answer
vba - How to Trap Outlook Events from Excel Application
I have a workbook that at least 15 people use and update periodically that contains client information with emails ... Any help is appreciated! See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
994
views
1
answer
vba - Com DLL In VB6?
I have a class in an Excel file and my boss wants me to create that class into a COM DLL. I don't want ... direction and help me out with this? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.1k
views
1
answer
vba - Worksheet change event for every sheet in the workbook
Is there a way to globally install a change event that triggers on every single sheet? I have a workbook ... module didn't Trigger anything. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
897
views
1
answer
vba - Reading data from text file and delimiting
I have an Excel 2010 spreadsheet, and I am reading in information from a .txt file (and another .xls file in ... me like a novice for this. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
955
views
1
answer
vba - Customizing the PowerPoint Ribbon at Run-Time
I am developing a PowerPoint add-in and would like to temporarily disable some of the Ribbon controls while ... applicable to Visual Studio? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.2k
views
1
answer
vba - Rule that runs macro when an email is opened
I have created a macro, that does certain things, to an opened mail. I would like to create a rule, that does ... rule on each mail I receive. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.2k
views
1
answer
vba - Select first visible cell directly beneath the header of a filtered column
I am trying to select the first visible cell directly beneath the header of a filtered column. The code I am ... 3)" Selection.FillDown End Sub See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
876
views
1
answer
vba - Event Handler for switching from other applications to Excel?
I want to activate a workbook when switching from other applications. I'm using Excel 2010. In the ThisWorkbook ... this workbook is not active. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.0k
views
1
answer
vba - How to access the label of a control in code
Often a label control is bound to a textbox or similar other control. I know that there is a way to access the ... the user where the error is. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.0k
views
1
answer
vba - How to format column to number format in Excel sheet?
Below is the VBA code. Sheet2 contains all of the values in general format. After running the code, values in column ... 1 End If Next End Sub See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.2k
views
1
answer
vba - Excel trailing comma bug in csv files
I have an XLS file creates a CSV file with a macro on Excel 2003, I have 40+ columns and the last 3 ... feasible to change the whole process. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.1k
views
1
answer
vba - Which way is faster? If elseif or select case
For the following code, If Sheets("sheet1").Range("A1").Value = "option_1" Then Sheets("sheet1").Range("A1" ... way to circle value from array? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.1k
views
1
answer
vba - Mod with Doubles
Am I doing something wrong or does the VBA Mod operator actually not work with floating point values like ... solves my particular issue. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.3k
views
1
answer
vba - Removing All Spaces in String
I created a macro for removing all whitespace in a string, specifically an email address. However it only removes ... , but are skipped over. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
909
views
1
answer
vba - Very large excel file - how to copy data between sheets?
I need to to import some csv files into excel 2010 and create a very simple, but very large database. The whole ... be the size of the file? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.2k
views
1
answer
vba - Saving webpage as PDF to certain directory
I have it where it will open Internet Explorer give the user the save as box and then exit. However, I would ... Quit Set IE = Nothing End Sub See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.7k
views
1
answer
vba - Downloading Images from URL and Renaming
I have an excel sheet with 2 columns, A and B. Column A has a name, and column B has the image ... appreciate and love any help regarding this! See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
990
views
1
answer
vba - Linked Table in MS Word
I would like to refresh Excel tables in a Word template report programmatically using VBA. The tables are written to ... is done as shown below: See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.2k
views
1
answer
vba - Clicking a hyperlink in Excel to set autofilter on a different sheet
I have an Excel workbook with two sheets, basically a one-to-many setup between the two sheets. The first sheet ... to solve this. Many thanks. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.3k
views
1
answer
vba - How to make Microsoft Web Browser object work in Excel 2016
When I try to insert it, I constantly get the "Cannot insert object" error. It seems to be a known issue ... this work? Here are screenshots: See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.1k
views
1
answer
vba - Create a query dynamically
Hi I need to create a query in MSAccess 2003 through code (a.k.a. VB) -- how can I accomplish this? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.3k
views
1
answer
vba - Selecting multiple sheets using a range
I have sheet names in cells C2 to C5, which are dynamic. I would like to select them at the same time using ... "Sheet3","Sheet4","Sheet5" etc. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.1k
views
1
answer
vba - Class_Terminate not firing on object from form
I have a very simple form, that uses a very simple class to handle some things. And that class has a ... hard-crashes without any error message! See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.4k
views
1
answer
vba - How to run a macro in Word before save?
How to make Microsoft Word to run a VBA macro every time before any document is saved? Could it be done ... macros into the document itself? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.2k
views
1
answer
vba - How to check if a Paragraph is in a Table or not in MS-Word macro?
The paragraph object in the Word has a property called Range. Within this Range object has a property called Cells. ... I test for this? thanks See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
965
views
1
answer
vba - How to get property values of classes that implement an interface in the Locals window?
This is really bothering me and hindering my development/debugging. Whenever I declare a variable type of the interface ... y.Name Stop End Sub See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.0k
views
1
answer
vba - Schedule Outlook 2003 Macro
I have an Outlook 2003 macro written in VBA. I would like to schedule it so that it automatically runs at a ... which suggests how to do this. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.3k
views
1
answer
vba - Compile error: End If without block If
I am currently running the below loop to pull out information from another spreadsheet, but keep getting the following ... If End If Next r See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
Page:
« prev
1
2
3
4
5
6
7
8
9
10
11
...
31
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] antv g6 的树图中 ,2个节点之间可以存在多条边吗?
[2] vue 中使用wangeditor 配置字号,无效果
[3] windows安装php的mongodb拓展提示,无法定位程序输入点 ASN1_TIME_compare于动态链接库
[4] ios - Make SwiftUI view grayscale if an alert/sheet is presented
[5] 请求的数据放在数组里面,在外面打印不到
[6] Not getting the aggregated results I'm looking from Wikidata sparql query
[7] Javascript: Iterate over an array of objects nested within an object as a value
[8] python - Button won't change value in tkinter
[9] 请问实现office在线预览的方式?
[10] tp5自定义类,构造函数不执行?
2.1m
questions
2.1m
answers
60
comments
56.8k
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
广告位招租
...