I'm trying to the following scenario in Excel2007:
1) Reading binary data for an Excel workbook file and saving these binary
data in Database
2) Reading the binary data from the database and saving it to a file by

I have following the instructions on creating my pop-up calendars, but
I'm sharing the workbook and some users are having trouble with the
code.  When they open the document and try to click on any cell, the
code window opens and gives them a debug error.  This is only

Is it possible / practical to manipulate an existing VBA application with
Visual Studio, or would it require a rewrite to begin using Visual Studio?
I am considering developing an Excell and Access application in VBA, however
in the future I may want to turn the application into a ...

I have a range of cells lets say A1:B10.  In Column B, there is an "x" every
so often.  I need a macro that will look down Column B1:B10 and for every
time there is an "x" copy what is in the adjacent cell in Column A to Sheet1
cell A1 then A2 then A3 etc.

This is a formula I am using
=sumif(D13:D328,1,F13:F328)
so I am checing if any cells from d13 to d328 have a 1 in them and if so to
total the sum of F13 to F328 ie d14,20 and 23 have a one in so sum f14,20 and

I have a workbook with a sheet name "Data" (among others) if the "Data" sheet
is selected and the user tries to print then I am running the following Macro:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
MsgBox ("The Print Preview will be viewed first." & Chr(10) & "Click the

When I email someone a file, the formatting (colors) change...  How do I
ensure the file they open looks just like the one I sent?
Thanks!

I've a number of Excel VBA applications which require user input/
response, and I've got 2 commonly occurring issues, relating to what
maybe the same thing
(1) Dropdown comboxbox on a userform -

Here's what I'd like to do:
I'm planning on using the same file on several different tables, that all
have the same data but may have the different columns labelled differently:
Find Column that has the Rate

i want to make a library in excel from VBA i need to put 3 things
1) INSERT
2)DELETE
3)UPDATE

I have a user that is using a Macro in Exel 2002, that is opening and
saving a number of files .xls files.
He has about 50 of these subs, opening and saving a different file
every time. Is there a better way of achieving the same thing without

I am trying to create an efficient way to update links that I have from a
number of different workbooks. All these worksbooks are protected by unique
passwords. How does one get the password into the Update_Link command?

Hi, I have a simple question that I cannot find an answer to:
I have two Range variables, which are columns. I'd like to copy them and
paste them on to a new worksheet...

I am using the following connection string to run a number of SQL stored
procedures in Excel VBA
"ODBC;Driver={SQL
Server};Server=nae-is-sql1;Database=Database;Trusted_Connection=no;UID=UserID;pword=Password"

Example:
Sheet1
Part no.           Location             Destination
1                      A1                       CE