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
963
views
1
answer
vba - Save Outlook attachment to disk
I found numerous examples of VBA scripts to automatically move attachments to my hard drive. This one I've found ... objOL = Nothing 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 - Convert a string containing hours, minutes, seconds to decimal hours
I have an automatically generated Excel sheet that has a column containing string values representing time spans. The values ... can I do that? 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 - Run time error '1004' Unable to get the Match propertyof the WorksheetFunction class
In my macro, I have the following code : i = Application.WorksheetFunction.Match(str_accrual, Range(Selection, ... error doesn't appear. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
936
views
1
answer
vba - Deleting Worksheets Based on Multiple Worksheet Criteria
I am continuing to build on macros related to data retrieved from mainframe, similar to what is mentioned in my ... regard to this list issue. 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 - Get a WeekNumber's end date using excel macro
I have 3 columns: Year, Weeknum, WeekRange. i'd like the WeekRange column to display the Start and End Dates ... Appreciate any help i can get. 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 macro button to change change cell values
Any ideas on how to get a button to change cell values based on a table. Say cell A1 is the active cell and i ... Range("B1:B10").Value 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 - How to query combo box of only current record/row in Access data entry form?
I have created a data entry form in Access that uses combobox for entering farmer name. The combobox is used for ... .name" End If End Sub 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 - Sending an auto-filled Outlook email template from Excel with multiple cell text body and additional text formatting
I have an email template saved in Outlook. I send this email out many times a day. Each email I send is ... copy, I need to CC someone. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
963
views
1
answer
vba - Loop Pivot Table Filter based on values in column
very new to this but I'll try to make my question simple to understand. I have an Excel sheet with a pivot table ... I want to save the file as. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
870
views
1
answer
vba - Using code to delete code
I have googled this and found multiple solutions for this but none of them have worked for me. I am ... . ActiveWorkbook.Close False End Sub 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 - Refresh entire Excel workbook (all data connections and calculations) every 15 minutes?
I have the following macro to refresh my workbook. This is the same as clicking on the refresh all ... () ActiveWorkbook.RefreshAll End Sub See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
941
views
1
answer
vba - Open Hyperlinks in Access
I have a table of products where there is say a pdf for a specific products user manual. I'm storing ... Any help would be greatly appreciated! 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 - Refresh MS Access Form/Query Based On Combobox Value
Pretty simple explanation. I have a table with 10 entries, 5 entries with the year 2010 and 5 entries with 2011 ... form, all done within VBA? 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 - Add Module code of BeforeDoubleClick_event to dynamically created worksheets
I have this code: For a = 1 To 5 strFoglio = "SheetName" & a Sheets.Add ActiveSheet.Name = strFoglio ... ...Next loop and not manually. 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 - Click Event in Class Module Not Firing
I have a user form that displays line-by-line validation errors (in text box) that I want to supplement with user ... "!" & WhichRange) 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 handle wild characters in Macros?
I have wrote a piece of code to replace any characters, but it doesn't work fine with *. Can some ... :=False, _ ReplaceFormat:=False 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 - Run macro when email is sent
I am trying to write a macro that looks at the subject line of an email whenever the user hits the Send button. ... fire a macro on the click. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
vba
0
votes
878
views
1
answer
vba - How can I convert a selection of emails from RichText to HTML Format?
Background: My work location has a default email format of RichText. Many people are adding images to their ... myMailItem = 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 - Find and Replace in just the selection
I have the following macro. It changes numbers of the form x.x to x,x. It was recorded and I added the ... document and not just the selection. 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 - Suppress dialog warning that a program is trying to access my mails
I am following the code from this page: How to create a script for the Rules Wizard in Outlook This is what I ... and VB.net but none for VBA. 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 send email in Outlook on behalf of a Delegate?
I'm writing a VBA script that will fire off emails to our customers. I've made similar systems before, but the ... email, I can do that too) 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 - Sending email from excel automatically based on date
I have an excel sheet with dated scheduling information. I would like to send daily updates on how many calls ... sent. Is this possible? 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 uniquely identify an Outlook email as MailItem.EntryID changes when email is moved
My company uses a single email address for customers to send requests and orders to. we created an Access ... s primary key field value. 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 - Unable to get the vlookup to work
I run this set of codes and it returns an error: Run-time error '1004' Unable to get the Vlookup ... MsgBox policynum MsgBox policybox 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 - How can I call Workbook_Open on Workbook A from Workbook B?
My situation is that I am trying to open Workbook A from Workbook B and run the Workbook_Open subroutine. The ... ("Workbook A").Workbook_Open) 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 - Remove protected view from Excel sheet opened programmatically in Access
I have a spreadsheet I open programmatically using the VBA in Access: Set xl = CreateObject("Excel.Application") ... achieve what I'm after? 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 - Paste clipboard in outlook email in normal order
I have 5 userforms for an email. The workflow goes like this: create new email userform1.show user selects the ... VK_V, 0, KEYEVENTF_KEYUP, 0 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 find max and min date in a range of another sheet?
I am writing VBA code to find the minimum and maximum dates in a Range. When I execute it, I get an error: ... columns, Column 5 and 8 are dates 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
...
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] javascript - i'm having issues creating my React app using npx-create-reat-app
[2] 企业官网,向下滑动到指定位置,才播放动画,例如苹果iphone页面,vue用什么库好?
[3] js如何把拥有相同项的数组合并?
[4] Java抽象类中的泛型问题
[5] java - Why are our emails to sendgrid SMTP getting this "Invalid SMTPAPI Header" error?
[6] h5怎么去除全网页中的float?
[7] Nginx代理转发,域名
[8] pandas - can't merge on index. tried using join, merge,
[9] 代码使用了Function.prototype.call()知识点,我哪里理解错了?
[10] JS从数组M中取出N个元素的所有组合
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
广告位招租
...