write text from email into table
Thu, 21 Aug 2008 06:55:01 -0700
I've written a macro to pull comma-separated text from emails, which I want
to put into a table
Dim folder As Outlook.MAPIFolder
Dim MailItem As Outlook.MailItem
Dim arr() As String
Dim aaa As String
Set folder = GetNamespace("MAPI").Folders.Item("AAA").Folders.Item("BBB")
For Each MailItem In folder.Item ...
|
Open form and go to record
Thu, 21 Aug 2008 03:57:01 -0700
I have a form (Void details) on which I have placed a command button. On
clicking the command button I want to open another form (SOR details) but at
the same time go to the same void details. Link is job number.
I did have this form as a tab on the void details form, but it slowed things
down too much, henc ...
|
Macro to transfertext giving error msg
Wed, 20 Aug 2008 21:32:01 -0700
Dear AllKnowingOnes,
I have created a spec and imported a text file into Access 2003 using the
Wiz, and would now like to have a macro perform the task.
Using the same filenames and locations as TransferText arguments in the
macro , I get the following error msg:
"You cannot import a text file unless it h ...
|
I need a bottom border every 20 rows
Wed, 20 Aug 2008 10:52:12 -0700
Hello,
I need a macro to make a bottom border every 20 rows. I have tried to
record this, but obviously I messed up somewhere. This is something that I
use often enough to want a macro. Thanks ...
|
Macros
Wed, 20 Aug 2008 10:23:00 -0700
I have a sheet that I would like for a macro or somthing to copy it and then
rename the sheet to go in order.
ex.
I hit my shortcut for the macro, it adds 'Sheet 1' and then changes it to
'Page 1' .... I press my shortcut again and it adds 'Sheet 2' and then
renames it to 'Page 2'.
I have no idea ho ...
|
Running Macro
Wed, 20 Aug 2008 06:14:10 -0700
Estoy practicando., y estoy creando Macro., y en uno de los pasos
dice que que debo Save, simple test and run Macro...
I typed the Action, type Comments etc.
but there is a row where say MOVESIZE., ABOVE AND BELOW
the thing is when I run the test...and should show the form above and
the datasheet below...it doe ...
|
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? ...
|
