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
1.1k
views
1
answer
excel - How can I determine the sheet name in a workbook that my function is sitting?
Imagine I have a xls workbook containing 3 tabs, SheetA, SheetB, and SheetC. I want to write a simple VBA ... workbook, it will return SheetA. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.1k
views
1
answer
excel - Search for sheets' name if matched condition then copy paste value with format?
Update: I was able to solve this problem. I just remembered VBA use * and ? to present the string 'If Sheet. ... , any sheet that has "CopyA"? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.3k
views
1
answer
excel - Is there a place to store VBA code that's accessible to all Microsoft Office products..?
Is there a way of storing VBA source code that's common and accessible to all Microsoft Office products..? I have a ... way...as far as I know. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.5k
views
1
answer
excel 2010 - EPPlus, handling big ExcelWorksheet
I'm using EPPlus to create xls report on daily and weekly basis. But sometimes the timeline is greater than ... an idea about an implementation? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.1k
views
1
answer
excel - How to run a macro automatically when the selections of pivot tables are changed
I got a pivot table with shows the data for Quarters in it, and a macro that performs some calculations ... including the multiple selections.. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.3k
views
1
answer
excel - VBA ontime cancel scheduling
I have written a macro that runs at 15:30pm every workday when a workbook is first opened. When the workbook ... ", schedule:=False End Sub See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.8k
views
1
answer
excel - Run-time Error '1004' - Method 'Open' of object 'Workbooks' failed
OK, so far I've uninstalled & re installed Office-2010 3 to 4 times, done hours of research for 3 days with no ... is at the only line of code. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.1k
views
1
answer
excel - Class for Custom Button Event Handling
1) I have a Form with some buttons (its in Access, but I guess it applies for Excel as well). 2) I have ... if anyone's got any advice, thanks! See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.2k
views
1
answer
excel - VBA - Loop Through Multiple Worksheets and Apply Filter
I need to apply the same filter to all the worksheets in the same workbook. All the sheets have headers in the ... the filter to only ONE sheet. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.1k
views
1
answer
excel - Is it possible to write a UDF in VBA that contains a period in the name?
Excel 2010 ships with some functions that contain a period in their name. For example STDEV.S and PERCENTILE ... NAMEdotSUFFIX = 42 End Function See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.5k
views
1
answer
excel - VBA "Invalid Qualifier Error"
Getting an Invalid Qualifier Error on this code, have no idea why. Dim WTotal As Integer WTotal = InputBox(" ... = " & totalamount.Value See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.4k
views
1
answer
excel - Save as PDF in Landscape
How can I pdf multiple sheets in my Workbook into one pdf in landscape format? Here is what I have. ... IgnorePrintAreas:=False End Sub Thanks! See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.2k
views
1
answer
excel - Next Without For Error VBA
I have the following code and VBA is giving me a "Next Without For" Error when I definitely have both. I know that VBA ... (sd) & ".") End Sub See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.1k
views
1
answer
excel - Want to delete all #N/A from the multiple sheet in one go
Need help here. I am using the below coding where i want to delete entire row contains #N/A, though i am bale to ... If Next i Next sh End Sub See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.1k
views
1
answer
excel - VBA in find function runtime error 91
My question is concerning the runtime error 91 in VBA for excel. I've done some searching to no avail. My code is ... is " & found.Row) End Sub See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
985
views
1
answer
excel - VBA Run Macro and Screen Tip (or Tool Tip) From Shape. I cannot get the code I found to work
I am using custom buttons (shapes) as buttons and I would like to use this code that I found but I ... Call CleanUp Call SetUpShapes End Sub See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.3k
views
1
answer
excel - How do I connect to Azure SQL DB from VBA with Authentication = ActiveDirectoryInteractive?
Set cnSQL = New ADODB.Connection 'cnSQL.Open "ODBC;DRIVER=SQL Server; Authentication = ActiveDirectoryInteractive; ... .database.windows.net" See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.0k
views
1
answer
excel - Application.OnTime running when it shouldn't
I've written a script which generates a Lotus Notes email to publish data at certain time intervals. This script ... EmbedObj = Nothing End Sub See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.0k
views
1
answer
excel - Inno Setup - Register components as an administrator
Based on the excellent Excel add-in installer (Daniel's XL Toolbox), I have built a setup file that among ... proceed to install the addin. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.2k
views
1
answer
excel - VBA Workbook.Open(File) returns Nothing
EDIT: After lots of help and not having a clue what's going on, it worked using a different method of ... path, file name, and extension. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.0k
views
1
answer
excel - eBay Product scraper
I am very limited on VBA, The Code is in a Module, the code has a sub process as well, so sorry if I ... Set link = Nothing End Sub code here See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.4k
views
1
answer
excel - How to read .xlsx and .xls files using C# and OleDbConnection?
Previously I was using ExcelPackage to read data out of a .xlsx file. That was working fine but then I ... update operation hidden in there? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.3k
views
1
answer
excel - Copying data from multiple pdf files
I have pdf files from which I would like to copy all the data to a column in a spreadsheet. Here is the code ... TimeValue("00:00:2") Next fname See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.5k
views
1
answer
excel - Implementing a change event to check for changes to textbox values and enabling the "apply" button
I need your help, Is it possible in Excel VBA to apply some sort of a global change event handler for a ... my VBA level of knowledge here. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
966
views
1
answer
excel - What is the difference between the time complexity of these two ways of using loops in VBA?
I got a theoretical question, will appreciate if you advise me here. Say, we have these two pieces of code. First ... ? Thanks a lot in advance. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.1k
views
1
answer
excel - "Unable to set the NumberFormat property of the Range class"
This code has been working for ages. I thought maybe I accidently pressed a key but I cannot seem to see it. I ... , x + j).Value = TempValue See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.1k
views
1
answer
excel - How to suppress cookie request
I am using vba inside of Excel 2013 to scrape data off of Yahoo Option Contract and while I do get the ... .Bracket(http.statusText) End Select See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.1k
views
1
answer
excel - May I return a 0-base array from ws.usedrange.value?
I like how efficient this function is. Unfortunately I wish the function returned a zero-based array! Any ... pWs.UsedRange.Value End Function See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
Page:
« prev
1
2
3
4
5
6
7
...
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] django - Query ManyToMany models to return number of instance of A that are linked to B and reverse?
[2] reactjs - React asynchronously set data from api in context provider
[3] 内网数据库1和外网数据库2如何做某些表的数据同步?
[4] 二次弹窗显示问题
[5] python - Sklearn metrics for regression differ depending on the evaluation method. How to get similar scores
[6] 怎么让DolphinDB开机自动运行
[7] vue 循环列表随机背景颜色如何固定住??
[8] 如何使用mongodb去实现一个递归累加的效果
[9] 问一个grafana的问题
[10] c - Infinite loop in program written as an exercise about finding the value of Pi
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
广告位招租
...