Recent questions tagged Excel

0 votes

767 views

1 answer

excel - Is there a way for DIR(path) in VBA to handle strings longer than 260?

Given the following snippet: Dim s As String: s = "S:vicla[..insert more here..]data.xml" Debug.Print Len( ... I am running this in Excel 2007 See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

716 views

1 answer

excel - How to run a string as a command in VBA

I have this simple VBA code below, and I don't know why is not working. Sub Run() test = "MsgBox" & """ ... Job Done!" and print just: Job Done! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

921 views

1 answer

excel - VBA copy rows that meet criteria to another sheet

I am new to VBA...I want to copy a row from Sheet2 to Sheet1 if the first cell in this row says X and ... :=Hoja1 End If Next i End Sub See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

765 views

1 answer

excel - Looping through Merged cells in VBA

Is it possible to loop through merged cells in vba. I have 6 merged cells in the range B4:B40 I need the ... these 6 cells 6 iterations only. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

914 views

1 answer

excel - How to save semi-colon delimited csv file using VBA?

I copy data into a spreadsheet, use VBA to format it, then save that sheet into a CSV file. I use the ... 2003 and my OS is Windows XP. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

989 views

1 answer

excel - VBA, Combine PDFs into one PDF file

I am trying to combine PDF's into one single pdf with the use of vba. I would like to not use a plug in ... app = Nothing MsgBox "DONE" End Sub See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

692 views

1 answer

excel - Read multiple xlsx files with multiple sheets into one R data frame

I have been reading up on how to read and combine multiple xlsx files into one R data frame and have come ... far I tried readxl and XLConnect. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

619 views

1 answer

excel - Missing VBA compiler message for wrong method name

Consider the following code: Public Sub VBACompilerIsMad() Dim Ap As Application Dim Wb As Workbook Dim Ws As ... as if they were Object? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

624 views

1 answer

excel - How do I read data from a spreadsheet using the OpenXML Format SDK?

I need to read data from a single worksheet in an Excel 2007 workbook using the Open XML SDK 2.0. I have spent ... in each row, using this SDK? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

688 views

1 answer

excel - How do I call an xll addin function from vba?

I have a 3rd party XLL addin I'd like to wrap in my own custom vba function. How would I call the 3rd party function from my code? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

706 views

1 answer

excel - How to call function from another specific workbook in VBA?

I would like to know if there is a way to call a VBA function or method from another specified workbook's ... cleaner to run directly the method See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

880 views

1 answer

excel - Export multiple sheets to PDF simultaneously without using ActiveSheet or Select

It has been drilled into my head, to avoid bugs and provide a good user experience, it is best to avoid ... 't support this property or method See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

766 views

1 answer

excel - sep=";" statement breaks utf8 BOM in CSV file which is generated by XSL

I'm currently developing CSV export with XSLT. And CSV file will be used %99 percent with Excel in my case, so I ... .. </table> </xsl:template> See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

600 views

1 answer

excel - VBA inheritance, analog of super

For example I have class A which implements class B ---class A---- implements B public sub B_do() end sub ... property (same way as functions). See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

663 views

1 answer

excel - How to split spreadsheet into multiple spreadsheets with set number of rows?

I have an Excel (2007) spreadsheet with 433 rows (plus the header row at the top). I need to split this up ... well. How can I accomplish this? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

894 views

1 answer

excel - Changing YYYYMMDD to MM/DD/YYYY

So I have a date that is 20170529 but whenever I try to format it to a date, the cell just becomes #########. ... do I convert these to dates. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

723 views

1 answer

excel - VBA Deleting rows with the Like operator

Simple thing is not simple. I am trying to delete rows based on a specific column having data that begins with " ... to do the trick. Thoughts? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

754 views

1 answer

excel - How do I Use a Function as a Parameter?

I would like a function that will unprotect and reprotect my Worksheet. The function I have currently is as follows: ... my tables in using VBA. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

excel - Getting an error `xlValues` is not defined when Cells format to the others

I am trying to copy the format of an Cell say here "A1" to the all cells of the first row using VBScript,but ... Can you help me here? Thanks, See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

726 views

1 answer

excel - Trying to open the workbook in separate instance

Not sure whether I am doing it right. Please advise me. I am trying to open one workbook in new instance. ... Set xlApp = Nothing End Sub See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

excel - Import semicolon separated CSV file using VBA

I have a problem with opening .csv files with Excel by VBA code. I have data organised like: Number;Name; ... from this thread. Any ideas? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

excel - Error 1004 when setting Range.Locked

I get the catch-all runtime error 1004, "unable to set the Locked property of the Range class" when, well ... could possibly be going wrong? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

799 views

1 answer

excel - IF statements in VBA

I am using an if statement which is giving the the error message End if without block if Ive tried placing the ... End If Any ideas? Thanks. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

907 views

1 answer

excel - simple vba code gives me run time error 91 object variable or with block not set

So I have a simple little macro/sub defined when a command button is clicked. The problem is it gives me: Run ... Cell "A12" in Sheet8. Thanks! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

833 views

1 answer

excel - trying to store text file rows in VBA

Greetings, I'm hoping for help in figuring out how to store each row of a text file read into a VBA program ... for any help you can provide! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

963 views

1 answer

excel - Conditional formatting using 3 conditions in Macro/VBA

I would like to program a macro in Excel that would highlight the entire row green if the following conditions are ... any help on this. Thanks. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

excel - How to download a file from SharePoint with VBA?

I am trying to download a file from SharePoint with VBA. The file is a picture but the picture isn't view- ... ) oStream.Close End If End Sub See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

960 views

1 answer

excel - How to Split a single cell into multiple rows and add another row

I have a table that has two Columns. Date and Test Name. What I would like to happen is that the string of ... time and not the entire data set. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags