Programatically changing the macro content.

  • Thread starter Thread starter archidamos
  • Start date Start date
A

archidamos

Hi everybody,
is possible to change Excel macro content by another macro?
I often use to copy and paste some code samples from PDF files and there is a problem with quotation marks and the apostrophe. These chars are different in PDF and pasting them into the module causes the problem running such sample.
So now I have to paste it to Word first, where I made simple Replace macro but would be much better to do it directly in Excel module.

Thanka in advance for help

Archidamos
 
Hi everybody,
is possible to change Excel macro content by another macro?
I often use to copy and paste some code samples from PDF files and
there is a problem with quotation marks and the apostrophe. These
chars are different in PDF and pasting them into the module causes
the problem running such sample. So now I have to paste it to Word
first, where I made simple Replace macro but would be much better to
do it directly in Excel module.

Thanka in advance for help

Archidamos
Click to expand...

The apostrophe denotes a comment, which is not executable. Quotes
denote the value between them is a string. Both of these a valid in
code so if you're having trouble with copy/paste from anywhere then
you're doing it wrong when it generates an error!

Post the problem code from the PDF that you say errors out so we can
see what you're talking about. Better yet, post a download link to the
PDF file so we see it in its entire context!!!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
Back
Top