creating a loop for a macro
Tue, 19 Aug 2008 02:56:01 -0700
Hi,
This is my first macro i have created! I need to loop the below untill there
is no longer anything in the cells. Anyone got any ideas?
Range("C2:C14").Select
Selection.Copy
Range("G2").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Tra ...
|
my macro is remembering specific range instead of from 1st to last
Mon, 18 Aug 2008 03:35:02 -0700
I need my macro to include shift+end+down arrow, to select from 1st to last
in a column, it does it once as the spreadsheet grows it only selects the
first range. Can someone pls help ...
|
Need help with Macro's format shading
Sun, 17 Aug 2008 01:10:01 -0700
I'm trying to set up some shading macro's or rules for an excel page (excel
2003) and running into a little difficulty. I set up a macro to put in a
light shading to make everything easy on the eyes every even number row:
Range( _
"A8:S8,A10:S10,A12:S12,[through],A94:S94" _
).Select
With ...
|
Functions worked in Access 2003 but not in Access 2007
Fri, 15 Aug 2008 12:40:26 -0700
My functions worked in Access 2000 and 2003, but dont work in Access 2007.
Any tricks to this? ...
|
Form Timer Event
Fri, 15 Aug 2008 08:16:00 -0700
I want to use a form timer event to see if new emails have arrived and it has
an attachement. If it does, then I want to extract the attachment data (a
.X12 file) into a DB. Can anyone help me with how to do this?
...
|
order counter
Fri, 15 Aug 2008 08:09:01 -0700
Is it possible to create a macro that constantly checks for a new record in a
given table, and if it finds a new record, it plays a sound or a beep? For
example, each time the Orders table gets updated with a new record (a new
order), a beep or sound would play? Or a little pop up notification window
would ...
|
Check a queue
Fri, 15 Aug 2008 07:10:00 -0700
Does Access/VB Code have the ability to regularly check a queue to see if
there is an item in it that needs to be processed, get the item and then
process it?
...
|
|
|
Scheduling Macro to run automatically
Thu, 14 Aug 2008 14:53:02 -0700
Hi.
I'd like to email a report from Access on a weekly basis aithout having to
go into the database and run the macro. Is there a way to get the macro to
automatically run once a week?
Thanks in advance! ...
|
The expression you entered has a function name that Microsoft Offi
Thu, 14 Aug 2008 14:42:00 -0700
Using Access 2003. Macro suddenly stopped working and displays the following
message:
"The expression you entered has a function name that Microsoft Office Access
can't find" appears when the DIR() function is used but does not if it is
removed from the condition statement on the macro.
The macro perfo ...
|
Delete Macro on Menu bar
Thu, 14 Aug 2008 13:35:00 -0700
I accidentally dragged a macro to the menubar (right next to the Help menu)
and I cannot figure out how to get rid of it. It sits there every time I
open Access. If I left click on it, it tries to run the macro, and if I right
click I get the typical selection that I get when I click on an empty spot on
the ...
|
