Top "Excel" questions

I'm trying to get my MySQL data to Excel file, but I'm having problems with Excel cells. All my text …

I have used the following without success. The active workbook closes, indeed, but the excel window remains open. Application.ActiveWindow.…

I have a query that returns a very large data set. I cannot copy and paste it into Excel which …

I have an interesting challenge - I need to run a check on the following data in Excel: | A - …

How can I find the last row that contains data in a specific column and on a specific sheet?

I would like to call a sub from another sub inside in the same module. The first sub would be …

I have an array like this: Dim aFirstArray() As Variant How do I clear the entire array? What about a …

I need to generate a file for Excel, some of the values in this file contain multiple lines. there's also …

Is there something that I need to reference? How do I use this: Dim fso As New FileSystemObject Dim fld …

In VBA, I opened an MS Excel file named "myWork.XL" programmatically. Now I would like a code that can …