Top "Excel" questions

Check if the file exists using VBA

Sub test() thesentence = InputBox("Type the filename with full extension", "Raw Data File") Range("A1").Value = thesentence If Dir("thesentence") &…

excel vba

Get values from other sheet using VBA

I want to get values from other sheets. I have some values in Excel (sheet2) for example: A B C …

excel vba worksheet-function

Setting mime type for excel document

MS Excel has the following observed MIME types: application/vnd.ms-excel (official) application/msexcel application/x-msexcel application/x-ms-excel application/x-excel …

excel content-type mime

How can I use a for each loop on an array?

I have an array of Strings: Dim sArray(4) as String I am going through each String in the array: for …

excel vba

Generate sql insert script from excel worksheet

I have a large excel worksheet that I want to add to my database. Can I generate an SQL insert …

sql excel

IndexError: too many indices for array

I know there is a ton of these threads but all of them are for very simple cases like 3x3 …

python excel csv error-handling indexing

How to save MySQL query output to excel or .txt file?

How do you save output of a MySQL query to a MS Excel sheet? Even if it's only possible to …

mysql excel

"Can't find Project or Library" for standard VBA functions

So I'm having to run someone else's excel app on my PC, and I'm getting "Can't find Project or Library" …

excel vba reference namespaces

How to do a "Save As" in vba code, saving my current Excel workbook with datestamp?

I have an Excel Workbook that on form button click I want to save a copy of the workbook with …

excel excel-2007 archive save vba

How to import an excel file in to a MySQL database

Can any one explain how to import a Microsoft Excel file in to a MySQL database? For example, my Excel …

mysql excel