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
991
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
979
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.2k
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] js 判断一个数组是否存在空的元素
[2] js数组多层嵌套,如何快速检索?
[3] automation - APPIUM: Unable to connect Appium server to android studio emulator
[4] 小程序怎么显示大段落文字,并且保留样式
[5] python - Why does the same way of opening and writing a file gives me error the second time? ValueError: I/O operation on closed file
[6] Local variable inside mysql statement
[7] Angular JiT 和 AoT 编译问题
[8] typescript - Check for a Valid Instance of in NestJS
[9] javascript - Pass data through promise .then notation using axios
[10] c++ - How to set tab based cookies in WebView2?
2.1m
questions
2.1m
answers
60
comments
57.0k
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
广告位招租
...