Excel Duty List?

I am trying to create a duty roster for my class. Background: We currently have weekday and weekend duties. People...

Where does VBA Debug.Print log to??

Where does Debug.Print output messages? ...

XML parse VBA excel (function trip, & MSXML2.DOMDocument)?

I need to parse hundreds of XML files having all the same structure as follows: <?xml version="1.0" encoding="UT...

Is VB really case insensitive??

I'm not trying to start an argument here, but for whatever reason, it's typically stated that Visual Basic is case i...

Difference between Thisworkbook.name and Activeworkbook.name in VBA?

Is there any difference between Thisworkbook and ActiveWorkbook. Example code : Sub workbook_name() MsgBox ...

Cast and Sum functions?

I am writing a macro which pulls data from Oracle and displays in Excel. In Oracle DB we have a custom table with a ...

Excel 2007 Conditional formatting with 2 conditions, one based off another column?

I'm using a table in Excel 2007. I'm trying to highlight cells in one column based off of its value and its status ...

Using SUM() in VBA?

If I have a set of cells in a worksheet that I want to add up, I can use the formula: =SUM(Sheet1!A1:A10) To do t...

Setting Excel cell value based on another cell value using VBA?

I have the following spreadsheet. When ever there is an x in cell B I need to populate the d and e cells in the sam...

Recommended way to read and write .ini files?

Are any methods available in VBA to read and write INI files? I know I could use; Open "C:\test.ini" For Input As #...

Excel VBA find maximum value in range on specific sheet?

I found that the following code is getting max value in range: Cells(Count, 4)=Application.WorksheetFunction.Max(Ra...

How to save an Access OLE Object (BLOB) image to disk using VBA?

So I seem to be able to save BLOB files from Access okay using the code below (which I found while searching how to ...

How to change Named Range Scope?

When I create a named range through the Name Manager, I'm given the option of specifying Workbook or [worksheet name...

Getting computer name using VBA?

Is there a way to get the name of the computer in VBA? ...