Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I've been working a littlbit too long
So, I have been working for what seems like 2 and a half weeks on this project. I know that it is not hard, but I don't really know VBA programming stuff... I guess this is my question... Is tehre a way to run a few lines of 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 getting the error Code: -------------------- Compile error: Expected Function or variable -------------------- Any one know what I'm doing wrong? -- Adam.Effinger ------------------------------------------------------------------------ Adam.Effinger's Profile: http://www.thecodecage.com/forumz/member.php?userid=594 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126706 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I've been working a littlbit too long
Perhaps it is because the function is called createstuff and you are
calling Stuffier. Other than that, use Call not Run. -- __________________________________ HTH Bob "Adam.Effinger" wrote in message ... So, I have been working for what seems like 2 and a half weeks on this project. I know that it is not hard, but I don't really know VBA programming stuff... I guess this is my question... Is tehre a way to run a few lines of 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 getting the error Code: -------------------- Compile error: Expected Function or variable -------------------- Any one know what I'm doing wrong? -- Adam.Effinger ------------------------------------------------------------------------ Adam.Effinger's Profile: http://www.thecodecage.com/forumz/member.php?userid=594 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126706 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
I've been working a littlbit too long
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 commit that to memory... Bob Phillips;457829 Wrote: Perhaps it is because the function is called createstuff and you are calling Stuffier. Other than that, use Call not Run. -- __________________________________ HTH Bob "Adam.Effinger" wrote in message ... So, I have been working for what seems like 2 and a half weeks on this project. I know that it is not hard, but I don't really know VBA programming stuff... I guess this is my question... Is tehre a way to run a few lines of 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 getting the error Code: -------------------- Compile error: Expected Function or variable -------------------- Any one know what I'm doing wrong? -- Adam.Effinger ------------------------------------------------------------------------ Adam.Effinger's Profile: 'The Code Cage Forums - View Profile: Adam.Effinger' (http://www.thecodecage.com/forumz/member.php?userid=594) View this thread: 'I've been working a littlbit too long - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=126706) -- Adam.Effinger ------------------------------------------------------------------------ Adam.Effinger's Profile: http://www.thecodecage.com/forumz/member.php?userid=594 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126706 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
held the shift key down for too long so now keyboard not working | Excel Discussion (Misc queries) | |||
SumIf not working over a long range | Excel Discussion (Misc queries) | |||
working with a long list | Excel Discussion (Misc queries) | |||
Reading and working with a long CSV (more than 100K lines). | Excel Programming | |||
Transpose Function not Working with Long Array Elements | Excel Programming |