I've been working a littlbit too long

A

Adam.Effinger

So, I have been working for what seems like 2 and a half weeks on thi
project. I know that it is not hard, but I don't really know VB
programming stuff...

I guess this is my question... Is tehre a way to run a few lines o
code from another module(I.E.


'under the workbook that I am using this is on Sheet1

sub ActiveX_BTN_Click()

->Run Stuffier(a,b)
End Sub

'and this is under moduleX
Sub createstuff(Path,FileName)
dim xlapp as excel.application
dim wdapp as word.application
xlapp = me.application
wdapp = getobject("Word.application")

wdapp.select
wdapp.selection.copy
xlapp.paste
End Sub

I know that it's not perfect (or even working well) but I keep gettin
the error

Code
 
B

Bob Phillips

Perhaps it is because the function is called createstuff and you are
calling Stuffier.

Other than that, use Call not Run.
 
A

Adam.Effinger

No, did the Stuffier because it didn't matter what I was doing really.
I just wanted to write the syntax stuff...

I'll try call. I think earlier I had realized that, but didn't commi
that to memory...
 
A

Adam.Effinger

So, I'm looking to clean a string from all unprintable characters. If
anyone could help me with this it would be great. I've tried clean()
but it gives me an error. Anyone help?
 
Top