[mso] Re: Excel Open File

This is pretty OT now, but just one reply ...

> With all due respect Dave ...

I hate it when people say that, because it normally means exactly the 
opposite.  :-(  However, I'll take it you meant it exactly as written.

Although I now understand that you might not have understood the answer at 
all, that doesn't seem to have been the point of your first message. 
Certainly, my indicating which versions of Excel this answer applied to 
would hardly have helped if you didn't know what modules are in the first 
place.

You must remember that I was giving a specific answer to a specific 
question.  Moreover, Herbert - who asked the question - had obviously 
understood the answer, and indicated that it worked perfectly.

So ... job done.

It almost sounds as though you are asking me to spoon-feed an answer 
assuming a lowest common denominator of knowledge among anyone who may 
chance to read the message.  I'm sure that isn't really what you're asking 
for, but it would be difficult to know where to draw the line.

> It took me a good 10 minutes to search Excel help and
> try and locate exactly what it was you were talking about.

I can understand that, and Excel help is probably the wrong place to look 
for something you don't know about.  It took me 30 seconds to do a search on 
Google and get basic information on what the "ThisWorkbook" module is.  My 
Google search was "In the ThisWorkbook module put", copied straight out of 
my message.

> I appreciate that there are times when solutions seem obvious to those of 
> us
> who offer suggestions to those of us who ask for help, but equally there 
> are
> times when some of us need a bit more info please!

Yes indeed, and if Herbert had asked for more information, I would have 
given it to him.  But that's not the same as what you seem to be asking for, 
which is an included level of basic explanation that WASN'T asked for by the 
person who asked the question in the first place.

If YOU had come back and asked "how do I put it 'in the ThisWorkbook 
module'?", I would certainly have responded - hopefully politely - with 
specific instructions on how to open the ThisWorkbook module and/or a 
suggestion that you Google for VBA tutorials.  However, that wasn't what you 
did.

Regards, Dave S

----- Original Message ----- 
From: "Anne Robson" <anne.robson@xxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Sunday, March 22, 2009 12:51 AM
Subject: [mso] Re: Excel Open File


> With all due respect Dave I have no idea what a module is, I don't use VBA
> so what you suggested seemed complete fog to me. It took me a good 10
> minutes to search Excel help and try and locate exactly what it was you 
> were
> talking about.
> I appreciate that there are times when solutions seem obvious to those of 
> us
> who offer suggestions to those of us who ask for help, but equally there 
> are
> times when some of us need a bit more info please!
>
> Hope you understand.
> 2009/3/20 David Smart <smartware@xxxxxxxxxxxxxxx>
>
>> Well ... no.  Not unless it's important to the particular question.
>>
>> In fact, most solutions are not version specific anyway.
>>
>> Regards, Dave S
>>
>> ----- Original Message -----
>> From: "Anne Robson" <anne.robson@xxxxxxxxx>
>> To: <mso@xxxxxxxxxxxxx>
>>  Sent: Friday, March 20, 2009 11:41 PM
>> Subject: [mso] Re: Excel Open File
>>
>>
>> > On behalf of me, if nobody else (!) could everybody please make clear
>> > which
>> > version/s you are referring to when posting as I have no idea whether
>> this
>> > may be 2007 only in which case it's of no interest to me on 2003.
>> > thanks!
>> >
>> > 2009/3/20 Herbert Chitate <herbertc@xxxxxxxxx>
>> >
>> >> Many thanks David, this works perfectly.
>> >>
>> >>
>> >> Cheers
>> >>
>> >> Herbert
>> >>
>> >> -----Original Message-----
>> >> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
>> >> Behalf Of David Smart
>> >> Sent: 19 March 2009 12:05
>> >> To: mso@xxxxxxxxxxxxx
>> >> Subject: [mso] Re: Excel Open File
>> >>
>> >> In the ThisWorkbook module put
>> >>
>> >> Option Explicit
>> >>
>> >> Private Sub Workbook_Open()
>> >>  Worksheets("Sheet1").Activate
>> >>  Range("A1").Activate
>> >> End Sub
>> >>
>> >> This assumes that you want to activate the sheet whose name is 
>> >> "Sheet1".
>> >> If
>> >> you want to go to the first sheet, regardless of name, then
>> >>
>> >> Option Explicit
>> >>
>> >> Private Sub Workbook_Open()
>> >>  Worksheets(1).Activate
>> >>  Range("A1").Activate
>> >> End Sub
>> >>
>> >>
>> >> Regards, Dave S
>> >>
>> >> ----- Original Message -----
>> >> From: "Herbert Chitate" <herbertc@xxxxxxxxx>
>> >> To: <mso@xxxxxxxxxxxxx>
>> >> Sent: Thursday, March 19, 2009 10:45 PM
>> >> Subject: [mso] Excel Open File
>> >>
>> >>
>> >> > Hi All,
>> >> >
>> >> > I was just wondering if anyone might know of a function that makes
>> >> Excel
>> >> > open a spreadsheet at the same point regardless of which tab the 
>> >> > save
>> >> > button may have been clicked.
>> >> >
>> >> > An example might be setting excel to open on sheet 1 cell A1?
>> >> >
>> >> > Maybe a small code?
>> >> >
>> >> > Many thanks
>> >> >
>> >> > Herbert
>> >> > *************************************************************
>> >> > You are receiving this mail because you subscribed to
>> >> mso@xxxxxxxxxxxxx or
>> >> > MicrosoftOffice@xxxxxxxxxxxxxxxx
>> >> >
>> >> > To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>> >> >
>> >> > To Unsubscribe from this group, visit the group's homepage and use 
>> >> > the
>> >>
>> >> > dropdown menu at the top.  This will allow you to unsubscribe your
>> >> email
>> >> > address or change your email settings to digest or vacation (no 
>> >> > mail).
>> >> > http://www.freelists.org/webpage/mso
>> >> >
>> >> > To be able to share files with the group, you must join our Yahoo
>> >> sister
>> >> > group.  This group will not allow for posting of emails, but will
>> >> allow
>> >> > you to join and share problem files, templates, etc.:
>> >> > http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is
>> for
>> >>
>> >> > FILE SHARING ONLY.
>> >> >
>> >> > If you are using Outlook and you see a lot of unnecessary code in 
>> >> > your
>> >>
>> >> > email messages, read these instructions that explain why and how to
>> >> fix
>> >> > it:
>> >> > http://personal-computer-tutor.com/abc3/v28/greg28.htm
>> >> > *************************************************************
>> >>
>> >> *************************************************************
>> >> You are receiving this mail because you subscribed to 
>> >> mso@xxxxxxxxxxxxx
>> >> or MicrosoftOffice@xxxxxxxxxxxxxxxx
>> >>
>> >> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>> >>
>> >> To Unsubscribe from this group, visit the group's homepage and use the
>> >> dropdown menu at the top.  This will allow you to unsubscribe your 
>> >> email
>> >> address or change your email settings to digest or vacation (no mail).
>> >> http://www.freelists.org/webpage/mso
>> >>
>> >> To be able to share files with the group, you must join our Yahoo 
>> >> sister
>> >> group.  This group will not allow for posting of emails, but will 
>> >> allow
>> >> you to join and share problem files, templates, etc.:
>> >> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
>> >> FILE SHARING ONLY.
>> >>
>> >> If you are using Outlook and you see a lot of unnecessary code in your
>> >> email messages, read these instructions that explain why and how to 
>> >> fix
>> >> it:
>> >> http://personal-computer-tutor.com/abc3/v28/greg28.htm
>> >> *************************************************************
>> >> *************************************************************
>> >> You are receiving this mail because you subscribed to 
>> >> mso@xxxxxxxxxxxxx
>> >> or
>> >> MicrosoftOffice@xxxxxxxxxxxxxxxx
>> >>
>> >> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>> >>
>> >> To Unsubscribe from this group, visit the group's homepage and use the
>> >> dropdown menu at the top.  This will allow you to unsubscribe your 
>> >> email
>> >> address or change your email settings to digest or vacation (no mail).
>> >> http://www.freelists.org/webpage/mso
>> >>
>> >> To be able to share files with the group, you must join our Yahoo 
>> >> sister
>> >> group.  This group will not allow for posting of emails, but will 
>> >> allow
>> >> you
>> >> to join and share problem files, templates, etc.:
>> >> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
>> >> FILE SHARING ONLY.
>> >>
>> >> If you are using Outlook and you see a lot of unnecessary code in your
>> >> email messages, read these instructions that explain why and how to 
>> >> fix
>> >> it:
>> >> http://personal-computer-tutor.com/abc3/v28/greg28.htm
>> >> *************************************************************
>> >>
>> >
>> >
>> > *************************************************************
>> > You are receiving this mail because you subscribed to 
>> > mso@xxxxxxxxxxxxxxx
>> > MicrosoftOffice@xxxxxxxxxxxxxxxx
>> >
>> > To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>> >
>> > To Unsubscribe from this group, visit the group's homepage and use the
>> > dropdown menu at the top.  This will allow you to unsubscribe your 
>> > email
>> > address or change your email settings to digest or vacation (no mail).
>> > http://www.freelists.org/webpage/mso
>> >
>> > To be able to share files with the group, you must join our Yahoo 
>> > sister
>> > group.  This group will not allow for posting of emails, but will allow
>> > you to join and share problem files, templates, etc.:
>> > http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
>> > FILE SHARING ONLY.
>> >
>> > If you are using Outlook and you see a lot of unnecessary code in your
>> > email messages, read these instructions that explain why and how to fix
>> > it:
>> > http://personal-computer-tutor.com/abc3/v28/greg28.htm
>> > *************************************************************
>> >
>>
>> *************************************************************
>> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx 
>> or
>> MicrosoftOffice@xxxxxxxxxxxxxxxx
>>
>> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>>
>> To Unsubscribe from this group, visit the group's homepage and use the
>> dropdown menu at the top.  This will allow you to unsubscribe your email
>> address or change your email settings to digest or vacation (no mail).
>> http://www.freelists.org/webpage/mso
>>
>> To be able to share files with the group, you must join our Yahoo sister
>> group.  This group will not allow for posting of emails, but will allow 
>> you
>> to join and share problem files, templates, etc.:
>> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
>> FILE SHARING ONLY.
>>
>> If you are using Outlook and you see a lot of unnecessary code in your
>> email messages, read these instructions that explain why and how to fix 
>> it:
>> http://personal-computer-tutor.com/abc3/v28/greg28.htm
>> *************************************************************
>>
>
>
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the 
> dropdown menu at the top.  This will allow you to unsubscribe your email 
> address or change your email settings to digest or vacation (no mail).
> http://www.freelists.org/webpage/mso
>
> To be able to share files with the group, you must join our Yahoo sister 
> group.  This group will not allow for posting of emails, but will allow 
> you to join and share problem files, templates, etc.: 
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for 
> FILE SHARING ONLY.
>
> If you are using Outlook and you see a lot of unnecessary code in your 
> email messages, read these instructions that explain why and how to fix 
> it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> ************************************************************* 

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: