I have been told to move my vba excel code to a DLL so it is more secure and
the code is external to the .xls file itself.  I have been searching for a
quite a while on how to do this.  Any suggestions?

I have a workbook with lots of different sheets. The main idea is that you
input data on the first sheet, the middle ones use that input for different
kind of calculations and the result comes to final sheet.
I would like to make the process iterative so that it would go through

Each row has in column J a hyperlink ( picture). Pictures are stored on my
computer on a folder on drive D.
If a put the workbook on another computer or change the folders location all
links are broken.

When running this code:  ActiveWorkbook.SaveAs Filename:=fname,
FileFormat:=6, CreateBackup:=False on office 2007 Im getting the 1004 error.
On office 2003 it rus perfectly.
Even if i change the FileFormat=xlCSV, still same reaction.

I have an Excel workbook which has 5 worksheets. I would like to add some VBA
code so that whenever the workbook is opened, we automatically go to Sheet 3,
Cell F6. And in which category should I write this code - Sheet1, 2, 3, 4, or
5 or This Workbook?

I would like to know how can I type constants to a particular argument in
methods similar to like how the constants below are tied to the last
argument of the InStr function:
vbBinaryCompare

Please can someone help. I have a user form with two list boxes on it. One on
the left and one on the right. The LH box has a list of choices and the RH
box is empty. I want a user to highlight a choice or choices in the left box
and by clicking a button with an arrow on it ...

Hi, I know little about VBA but know a macro can really speed up a
tedious weekly task, if only I can figure out how to write it.
What I need: I have a report imported into Excel.  This report
contains several headers that are repeated throughout and I want to

I have a problem with Range.CopyPicture method in Office 2007. I have used
same kind of code in Office 2000 and Office 2003 and it works fine. the code
copies ranges from Excel to slides in PowerPoint Presentation.
The problem occurrs when there is a graph on the range that is ...

I have sheet(1) which begins filled with data to row 65000... This data is
sorted / filtered, copied to Sheet(2)... at this point, sheet(2) contains 400
rows of data only...
Sheet(1) is cleared (usedrange fix also applied for good measure)...

I would like to be able to use MS Word functionality within MS Excel.  I am
working on sheets that import numerical data from other sources, and I have
to add free format text into a large (merged) cell.  And I need to be able to
edit that text.  I have managed to do so by making ...

XL2003 on WinXP. I have the weirdest thing going on, and can't figure it
out. I get an out of range error [9] when I get to the second sub.
In Module 1, I have:
Option Base 1

Given two dates like the following
Feb-14-07 18:20:11
Mar-03-07 20:32:19
how can I calculate, with an Excel formula or macro, the number of

Hey folks,
     I am looking for a way to create a two dimension array from a SQl
Statement.  this is what i have:
sql = "SELECT module.course_id, module.module_num, results.module_version,

I am having trouble getting Paint started:
Sub paint1()
Dim ReturnValue, i
ReturnValue = Shell("C:\WINDOWS\system32\mspaint.exe", 1)