Hi

I have a workbook which has been sent out to all our branches however I
would like to send them an updated version. The orginal workbook sent
ouot contained a worksheet which stored all their data. What I want to
do is copy this worksheet into my new version etc. however my problem
is the orignal workbook uses a user friendly userform which has the the
"X" close button disabled and has a button to "save and close" the
program. the userform is automatically loaded as soon as the workbook
is open.

1) I dont know where they would have stored it so I was thinking of
telling them to open it up first and then open my update program which
will exact that sheet.

2) not sure if they renamed the file.

Any ideas how a could close that userform that pops up with out run the
save & close button?


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=394128

HI

I would first ask them to open your book, then start your macro.
Application.Enableevents=false 'will prevent the userform to popup on
opening the old wb
strFile = Application.GetOpenFilename( "see in help")'user has to locate
himself the old wb
If strFile = "False" Then Exit Sub
workbook.open strfile
'do your stuff
'close and save
Application.Enableevents=True

Regards
Jean-Yves

"funkymonkUK"
wrote in message
...

Hi

I have a workbook which has been sent out to all our branches however I
would like to send them an updated version. The orginal workbook sent
ouot contained a worksheet which stored all their data. What I want to
do is copy this worksheet into my new version etc. however my problem
is the orignal workbook uses a user friendly userform which has the the
"X" close button disabled and has a button to "save and close" the
program. the userform is automatically loaded as soon as the workbook
is open.

1) I dont know where they would have stored it so I was thinking of
telling them to open it up first and then open my update program which
will exact that sheet.

2) not sure if they renamed the file.

Any ideas how a could close that userform that pops up with out run the
save & close button?


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=394128