Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programatically changing the macro content.
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programatically changing the macro content.
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Content in one coulumn using given content in another | Excel Worksheet Functions | |||
How to clear clipboard content programatically | Excel Programming | |||
Programatically Changing Hover Labels | Excel Programming | |||
Programatically changing the chart datapoints | Excel Programming | |||
Programatically changing picture in UserForm - VBA - Mac OSX | Excel Programming |