SENDKEYS and brackets
Thu, 13 Nov 2008 07:27:02 -0800
I'm using sendkeys (yes, I know not always reliable...) to send data to a
program which admits brackets of any description in headings and names and
when typed or copied from elsewhere and pasted into a data field will be
readily accepted.
However, when exactly the same data is sent via sendkeys all is expo ...
|
PasteSpecial error message
Thu, 13 Nov 2008 07:27:01 -0800
Hi Guys
I'm totally puzzled. Every second time I run this code I get the following
message:
"PasteSpecial method of Range class failed"
However, if I remove ActiveSheet.Protect Password:="dorPseO"
I don't get any error messages
Obviously I'm doing something wrong - Any suggestions?
Public Sub OesOorProdSt ...
|
Find Workbook in multiple instances of Excel
Thu, 13 Nov 2008 07:01:00 -0800
OK, here's another convoluted question. :)
There are times when I have multiple instances of Excel open. I want to be
able to find a workbook (of a specific name) in those multiple instances and
define it as myWB. Does anyone know how to do that?
Thanks,
Barb Reinhardt
...
|
help Vba
Thu, 13 Nov 2008 06:56:01 -0800
I've be trying protect and unprotect my VBA code and NOW I'm not even been
able to open the file
the message I get is
" 'FILE.xls' cannot be accessed . the file may be read-only , or you may be
tryinto access a rea-only location . Or the server the document is stored on
may be not rsponding " ...
|
Blocking column insertion
Thu, 13 Nov 2008 06:32:07 -0800
How do I prevent users from inserting columns without locking the worksheet?
The user has to insert data in columns A:U however, I need to prevent them
from inserting columns anywhere between column A and column U
Thanks
----------------
This post is a suggestion for Microsoft, and Microsoft responds to ...
|
Automating mail merge from excel
Thu, 13 Nov 2008 05:34:00 -0800
Hi all,
I'm mostly an access guy, so I'm not unfamiliar with vba (access vba,
anyway)...
I think I need to automate a word mail merge from Excel. What I need to do
is check (or filter) a list in version 2003 for no entries in a date column.
For those records that have no entries in the date column, I n ...
|
Macro for deleting rows and serialising the remaing rows
Thu, 13 Nov 2008 18:45:30 +0530
I have a spread sheet
It's a ToDo List
The structure is like this
Column A Sl No
Column B Task
Column C Person
Column D Completed
To start with I keep entering the tasks in one stretch and take a print out.
The first Column (A) will be a serialized.
I wil be using this print out for few days.
After tw ...
|
|
|
Load Values from Worksheet to Userform Controls with Loop
Thu, 13 Nov 2008 05:04:01 -0800
Does anyone know of a faster way to do this code below? Maybe use a Loop
with an array or collection? I have to do code like this with about 15 other
products. So having a nice loop surely would be more pleasing. This is how
I load all the values into the Userform requested by the user.
Se ...
|
Macro
Thu, 13 Nov 2008 04:14:01 -0800
Hi,
I'm trying to copy cells from sheet1 to sheet 2.
All the cells are in the same row in sheet1.
The number of cells in the row in sheet1 is unknown (varies).
All the cells has data in them.
When copied to sheet2 I want the cells to be copied several times below
eachother:
If sheet1 looks like this:
1 2 3
...
|
Question about checkboxes
Thu, 13 Nov 2008 03:51:01 -0800
I have 11 checkboxes (checkbox23-33). Currently, I have a macro per checkbox
that evaluates if box is True/False and then places a value in adjacent cell.
Is there a way to write one macro that will look at each checkbox and do the
same thing?
Thanks,
Les ...
|
