Writing Macros without using VBA

  • Thread starter Thread starter Mark Smith
  • Start date Start date
M

Mark Smith

Recently installed Office XP. I've been hit with an
emergency project that requires some macros. When I try
to record the macro, I'm dumped immediately into the
VBA. Problem, I'm VBA dumb and just want to record the
macro in the worksheet by doing the steps.

Is there a method for turning off the VBA so I can record
directly in the worksheet?
 
vba is the macro language that would be used when recording. This is not
lotus.
Try it. It will do what you want...
 
Time to edit your signature lines Harlan, Attachments are
disabled.
Click to expand...
...

A test.


begin 0644 test.bmp
M0DUV`0```````#8````H````"@````H````!`!@``````$`!``#$#@``Q`X`
M``````````````#_``#_``#_``#_``#_``#_``#_``#_``#_``#_`````/\`
M`/\``/\``/\``/\``/\``/\``/\``/\``/\`````_P``_P``_P``_P``_P``
M_P``_P``_P``_P``_P````#_``#_``#_``#_``#_``#_``#_``#_``#_``#_
M`````/\``/\``/\``/\``/\``/\``/\``/\``/\``/\`````_P``_P``_P``
M_P``_P``_P``_P``_P``_P``_P````#_``#_``#_``#_``#_``#_``#_``#_
M``#_``#_`````/\``/\``/\``/\``/\``/\``/\``/\``/\``/\`````_P``
M_P``_P``_P``_P``_P``_P``_P``_P``_P````#_``#_``#_``#_``#_``#_
``#_``#_``#_``#_````
`
end
 
...
..

A test.


begin 0644 test.bmp
M0DUV`0```````#8````H````"@````H````!`!@``````$`!``#$#@``Q`X`
M``````````````#_``#_``#_``#_``#_``#_``#_``#_``#_``#_`````/\`
M`/\``/\``/\``/\``/\``/\``/\``/\``/\`````_P``_P``_P``_P``_P``
M_P``_P``_P``_P``_P````#_``#_``#_``#_``#_``#_``#_``#_``#_``#_
M`````/\``/\``/\``/\``/\``/\``/\``/\``/\``/\`````_P``_P``_P``
M_P``_P``_P``_P``_P``_P``_P````#_``#_``#_``#_``#_``#_``#_``#_
M``#_``#_`````/\``/\``/\``/\``/\``/\``/\``/\``/\``/\`````_P``
M_P``_P``_P``_P``_P``_P``_P``_P``_P````#_``#_``#_``#_``#_``#_
.``#_``#_``#_``#_````
`
end
Click to expand...

Thought so. Welcome to the wonderful world of uuencoding. I'll keep my
signatiure line as-is.
 
I just checked via CDO. The small attachment didn't pass through in the posting
to which it was originally attached, but it did pass in as quoted text in my
reply to myself. So if the whole world used msnews.microsoft.com there MIGHT be
no problem (other than worse response time), but the real world doesn't work
that way. Certainly other nntp servers that provide binary newsgroups would
accept and propogate articles with attachments. Some may be screen out of other
servers, but there's no guarantee they'd be screened out if they were quoted in
a response. And since snipping is as frequent as bottom or interspersed posting
in the microsoft.public.excel.* newsgroups, there's a nonnegligible chance
there'll still be some that slip in if they're posted in the first place.
 
Harlan Grove said:
I just checked via CDO. The small attachment didn't pass through in the
posting to which it was originally attached, . . .
Click to expand...

But now that I've synched my proper newsreader with msnews.microsoft.com,
the attachment is back. So CDO is safe from attachments, but not the news
server when accessed via nntp. Inconsistent! How nice.
 
Hi Harlan,
Thought so. Welcome to the wonderful world of uuencoding. I'll keep my
signatiure line as-is.
Click to expand...

I totally agree!

Did everyone read Harlan's signature?? DO SO NOW!

<bg>

Jan Karel Pieterse
Excel MVP
 
Back
Top