Recent questions tagged excel

0 votes

971 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)

0 votes

1.0k 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)

0 votes

1.2k 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)

0 votes

1.3k 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)

0 votes

1.0k 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)

0 votes

1.2k 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)

0 votes

1.6k 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)

0 votes

1.0k 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)

0 votes

1.1k 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)

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)

0 votes

1.4k 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)

0 votes

1.3k 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)

0 votes

1.1k 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)

0 votes

992 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)

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)

0 votes

897 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)

0 votes

1.2k 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)

0 votes

959 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)

0 votes

945 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)

0 votes

1.1k 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)

0 votes

926 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)

0 votes

1.3k 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)

0 votes

1.2k 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)

0 votes

1.3k 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)

0 votes

874 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)

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)

0 votes

963 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)

0 votes

996 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)

Categories

Just Browsing Browsing

Most popular tags