Macro !!
Wed, 3 Sep 2008 06:01:33 -0700 (PDT)
Hi,
I have excel sheet having 6 coulmns
Col A - Names
col B - Address
col C - Date
Col D - Login
Col E - Any changes in login
col F - Date of change in login
If the user changes the login time in col E... automatically only that
person's
details will reflect in other sheet.
I need macro to run thi ...
|
Locking cells using VBA based on other cell values
Wed, 3 Sep 2008 05:58:00 -0700
Hi,
I'm trying to lock cells in a column on an excel spreadsheet depending on
the (date) value in another cell on the same row. For example, I'm thinking
of it like this:
If range("C9").value > today()
Then range("G9").lock = false
Else range("G9").lock = true
...
|
Do I need to destroy a collection I made when I am done with it?
Wed, 3 Sep 2008 05:34:01 -0700
I have some code that intializes a new collection, runs code using the
collection and then ends. Do I need to destroy the collection so it doesn't
take up memory or does this automatically happen when the procedure is over?
Is there a way to see what is in memory?
Option Explicit
Private Sub cboMounting_ ...
|
Macro to print to IP address
Wed, 3 Sep 2008 04:48:01 -0700
Can someone help me with a macro to print to an IP address. I have a stand
alone network printer that i want to print to and everyone has the printer
named differently on their computer. The only constant is the IP address.
Thanks in advance,
Larry ...
|
How to make First letter of the cell in capital letter
Wed, 3 Sep 2008 02:01:01 -0700
I have a sheet in which there are text matters.
I want to run a code, so that all the cells of the worksheet can be effected
to change the first letter of the cell into capital.
I was able to know with the web helps examples, by that I can do it manually
with the cell reference one by one. the formula is a ...
|
Emailing Spreadsheet as a body
Wed, 3 Sep 2008 01:47:01 -0700
Hello, I'm just wondering if its possible VBA wise to send a spreadsheet (a
particular sheet) in an email within the body, rather than a file.
Cheers for any advice. ...
|
Application Quit does not work at all
Wed, 3 Sep 2008 01:40:01 -0700
Hi I use MFC Visual C++ 4.2.
I am automating Excel from my application.
My problem is I cannot quit the Excel after the automation process finished!
I checked it still exists on the Process lists and the most DANGEROUS is
everytime the automation function run, it create other Excel and so on. So it
...
|
|
|
Hide Rows
Wed, 3 Sep 2008 01:20:06 -0700
Hi,
Here is my code:
Set myrange = Range("A18:A1220")
For Each c In myrange
If Value = Empty Then c.Row.Hidden = True
Next
What I am trying to do is check the value on cells A18 to A1220 and if they
are blank or empty then hide the entire row. However I get an error message
saying the object is ...
|
How to write a Clearcontents command in a macro
Wed, 3 Sep 2008 01:19:01 -0700
Hello,
I copied data from an excel worksheet; all this data contains IF formulas.
Then in another column I paste special, as value, and I select the area in
order to delete the blank cells (Go to Special, blank, delete)
Unfortunately the application always says: "no cells found" and I cannot
delete the emp ...
|
workbook specific custom toolbars
Wed, 3 Sep 2008 08:46:45 +0100
Excel 2003
I have 3 workbooks each having a specific custom toolbar associated with
it..
The toolbars are very different from each other.
The workbooks are all open and used together, the switching from one to
another -
when required - being achieved using "Window" in the menu bar.
When this is done, my cod ...
|
