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
1.5k
views
1
answer
vba - With a Word ContentControl DatePicker how do i get the value?
I have a ContentControl that is a DatePicker in a word document. I'm trying to use it to populate ... date from the DatePicker ContentControl? 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 - Instead of typing up a bunch of "Or" statements, how can I implement a function in this code?
Sub test() Dim DataRange As Range Dim LastRow As Integer Dim i As Integer Dim SplitVal() As String Dim ... function? Thanks so much everyone! 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 list all files of a given folder (recursively through sub-folder)?
I'm writing a microsoft word macro and having difficulty with vb.net. Please help. 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 - Dictionary is populated with an empty item after checking dictionary item in watch window
Recently I've encountered a rather odd dictionary behaviour. Sub DictTest() Dim iDict As Object Dim i As ... empty item in the dictionary? 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 - Looping through report filters to change visibility doesn't work
I'm trying to select one report filter, in this case Canada. That means the rest must be made invisible. This ... that and got the same error.) 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 - Email Macro Pauses every 40 - 50 emails
I have a semi-working macro that Loops through a list of Managers Generates a email body for each manager ... TempWB = Nothing End Function 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 - Merging excel spreadsheets into one spreadsheet
Okay, I tried to look for similar questions but I didn't understand much of what was being discussed since it's the ... . Let me know if I did! 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 - How To Programmatically Wait For Shell Command To Finish Running?
I am sending emails in a program like so: Call Shell(smtpPath, emailInput...) This works great, except if I call ... , sleep it, then try again? 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 - How to import a zipped csv hosted online into Excel
I have a simple link www.example.com/file.zip Inside there is a csv file There are no login forms required to ... ? (All via one button VBA) 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 - Finding the Last Row and using it in a formula
I am dealing with a sheet of data that has multiple rows ans columns. Each time the macro runs, the number of ... TIME SERIES'!D2-1" End Sub 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 - How to copy tables from multiple Word files to separate worksheets in Excel, naming the worksheet the name of the Word doc?
I have used the VBA macro below to put multiple tables from multiple Word documents into one worksheet in Excel. ... WordApp = Nothing End Sub 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 - Reference a folder by name
I need to get a folder by name, not by folder number counts. I tried getting with various methods. ... Session.GetDefaultFolder("Vijay Baswal") See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
906
views
1
answer
vba - Find a string in a document and delete everything after it
I want to find a string in a word document and delete everything after it. What is the best way to do this without using the Selection object? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
928
views
1
answer
vba - Does Excel have a built in method for parsing formulas? (ie: to obtain a list of included RANGE references)
For a given Excel formula in a cell, I'd like to be able to parse the formula in order to get ... .com/develops/2004/12/excel_formula_p.html 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 delete entire row when case sensitive duplicates are found in Excel (for 100k records or more)?
This is a follow up question from How to remove duplicates that are case SENSITIVE in Excel (for 100k records ... cASE1 Are all unique records. 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 - excel Copy shapes from one worksheet to another
I am trying to use a macro to copy all the shapes (images) from a worksheet to another. I used the record ... don't know the name of shapes. 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 - Drag file into Access, how to check the file details?
I like to drag a file from Windows Explorer or an attachment from an Outlook mail into MS-Access. I discovered ... want to do. Any ideas? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
1.5k
views
1
answer
vba - Set Email Flag Status in Outlook 2007
Is there a way in Outlook 2007 to set a follow-up flag on an email object? It looks like it was supported in ... I can't find it in 2007. 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 - Pulling data from SAP using Excel Macros
So I am trying to pull data from SAP using excel macros. I am new to VBA so please bear with me. I found a ... an act of God to get it fixed. 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 - Loop through each word in a word document
I know how to get every paragraph in a word document. But I am looking for a way to loop through each ... .Print lineText Next apara End Sub 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 - Not understanding why WinHTTP does NOT authenticate certain HTTPS resource
I'd be extremely grateful for any kind of help that may help me resolving the problem. From Excel VBA code ... in advance for your suggestions! 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 - Excel macro "Run-time error '1004"
I am new to scripting and I am trying to improve a existing Macro. I recorded a macro to remove dupliate and ... :=xlNo End Sub Thanks, Kiran 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 - Copying strings over floats in 'Do While' loop
I'm attempting to create a macro that copies a string over a float/integer in the next few cells ... .com/photos/hillsindustries/12198631954/ See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
929
views
1
answer
vba - combo box to select value w/ multiple duplicates & populating textbox in form w/ value from each duplicate record, line by line?
I'm currently trying to do as said in the title, but cannot find a reliable and working vba code to use. The ... I could think of. Thank you! See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
941
views
1
answer
vba - Transpose a set of values in rows to columns in Access 2010
I have an Access database that looks something like this: ID | TestDate | Test1 | Test2 | Test 3 | 1 | ... code is much appreciated. Thank you. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
996
views
1
answer
vba - Skip one worksheet and process the remaining worksheets
I was working with a vba code which remove all the rows which dont have word "Statement No" in it from all ... True End Sub Thank you All! 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 - Excel macro to copy rows to new sheet(s) based on column value
My query is below: Each month my telecom provider gives me an excel list of all subscribers in the following ... for your very kind help. 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 - Check a range is not the entire sheet?
I have this function which is trying to detect when a particular cell value changes. The problem is, if the ... clear the whole worksheet etc)? 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
...
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] 自定义React Hooks如何封装成npm包
[2] swift - Escaping closure captures 'inout' parameter 'albums'
[3] vscode 调试node代码进不去node核心库的源码
[4] drop down menu - I have list LOV of id numbers which returns names and I want to copy displayed selected name in hidden record
[5] github - git submodule not pushed to private repo
[6] docker - Keycloak admin-cli via kubernetes service URL always 401 - certificate with invalid signature
[7] How do I apply Map[] to a function using two arguments in Mathematica?
[8] 修改el-timeline-item的左侧第一个节点颜色,修改后无效
[9] visual studio - How to compile Full .NET along with NETStandard project
[10] javascript - Google Places Autocomplete and Geocoding address and address validation
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
广告位招租
...