Button help

[DARRELLTOMANDL]

Here is what I have. I have a work book with one sheet in it called IQS_2.xls that I fill in information, and save as a different file name each time.I have made a button with a macro that opens another sheet that grabs the information and enters it into the designated cells, I call this one EMQS.xls. My problem is when I save the IQS_2 files as a name, the EMQS file does not stay linked to the newly renamed file. So I want to push the button in the renamed IQS_2 file and open the EMQS file and automaticly enter the information. Can this be done? I am new to excel and have very limited knowledge, so the more detail you can give would be great.

Thanks,
Darrell

 

[Colo]

Darrell, What kind of a button did you insert?
From Forms or from Control Toolbox?

If do you have the code, please let us have.

 

[DARRELLTOMANDL]

I used the button from the form toolbar.


Sub Open_EMQS()
'
' Open_EMQS Macro
' Macro recorded 2/3/2004 by Darrell Tomandl
'

'
Workbooks.Open Filename:= _
"\\Lltoolxp\c\WINDOWS\Personal\1GM Email Quote Sheets\EMQS.xls"
End Sub


Thanks,
Darrell