[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

.irbrc on Windows

Jeffrey Flint

6/10/2009 1:56:00 AM


I have read all of the help on this topic and I still cannot get irb to
load the file.

I have added the environmental variables:

IRBRC
HOME

with no effect. Is there a snappy way to get this to work?

Jeff
--
Posted via http://www.ruby-....
5 Answers

Jeffrey Flint

6/10/2009 2:26:00 AM

0

Jeffrey Flint wrote:
>
> I have read all of the help on this topic and I still cannot get irb to
> load the file.
>
> I have added the environmental variables:
>
> IRBRC
> HOME
>
> with no effect. Is there a snappy way to get this to work?
>
> Jeff

I found my problem. Thanks.
--
Posted via http://www.ruby-....

Luis Lavena

6/10/2009 3:35:00 AM

0

On Jun 9, 10:55 pm, Jeffrey Flint <jeffrey.fl...@gmail.com> wrote:
> I have read all of the help on this topic and I still cannot get irb to
> load the file.
>
> I have added the environmental variables:
>
> IRBRC
> HOME
>
> with no effect.  Is there a snappy way to get this to work?
>

You should place a .irbrc (there is a dot preceding the filename)
inside your HOME. To figure where is HOME in your environment, please
do the following, inside IRB

File.expand_path("~")

That should tell you where in your OS installation is the proper place
in your profile to place that file.

HTH,
--
Luis Lavena

Bob Phillips

3/26/2010 4:27:00 PM

0

Take that sheet out of the code in the summary sheet.

Or maybe this is what you want

Application.ScreenUpdating = False

With Sheets("Statistics")

.Visible = Not .Visible
End With

With Sheets("Direct Cost Savings Breakdown")

.Visible = Not .Visible
End With

With Sheets("Pay Inflation - Biometrics")

If .Visible <> xlSheetVisible Then

.Visible = Not .Visible
End If
End With

With Sheets("OT Reduction")

.Visible = Not .Visible
End With

--

HTH

Bob

"Larry Fitch" <LarryFitch@discussions.microsoft.com> wrote in message
news:36429FFA-0D09-4E9C-B1E6-4DEC634D62B3@microsoft.com...
> Hi Bob -
>
> You are correct in regards to the toggle concept..
>
> What I am trying to figure out is how to prevent a sheet that has been
> opened individually from being closed when a button assigned to a summary
> of
> sheets that contain the same thing is selected..
> --
> Thanks
>
> Larry
>
>
> "Bob Phillips" wrote:
>
>> Your whole code is a toggle concept, hide it if visible and vice versa.
>> If
>> you change it to just making it visible if not visible, it will never get
>> hidden. So I am confused as to your overall objective.
>>
>> --
>>
>> HTH
>>
>> Bob
>>
>> "Larry Fitch" <LarryFitch@discussions.microsoft.com> wrote in message
>> news:30206AF7-1800-44D4-AFF4-57E78AC3FACF@microsoft.com...
>> >I have created macros assigned to buttons that open and close individual
>> > sheets. Here is an example -
>> >
>> > Sheets("Pay Inflation - Biometrics").Visible = Not Sheets("Pay
>> > Inflation -
>> > Biometrics").Visible
>> >
>> > I have also created macros that are assigned to buttons that open an
>> > close
>> > groups of sheets.
>> > Here is an example -
>> >
>> > Application.ScreenUpdating = False
>> > Sheets("Statistics").Visible = Not Sheets("Statistics").Visible
>> > Sheets("Direct Cost Savings Breakdown").Visible = Not Sheets("Direct
>> > Cost Savings Breakdown").Visible
>> > Sheets("Pay Inflation - Biometrics").Visible = Not Sheets("Pay
>> > Inflation
>> > - Biometrics").Visible
>> > Sheets("OT Reduction").Visible = Not Sheets("OT Reduction").Visible
>> >
>> > The problem I have is that if I have opened a single sheet using the
>> > button
>> > for that sheet (in the example at top it is the Pay Inflation -
>> > Biometrics
>> > sheet) and I then select the button to open the group of sheets, the
>> > Pay
>> > Inflation - Biometrics will close since it was opened by the previous
>> > macro..
>> >
>> > What error checking or other conditional logic can I add so that if a
>> > sheet
>> > is already visible it will not be hidden.. ??
>> > --
>> > Thanks
>> >
>> > Larry
>>
>>
>> .
>>


Larry Fitch

3/26/2010 6:18:00 PM

0

Thanks Bob-

This worked...

If I can go back to the well one more time - is there a "global" command
that I can have that will do that contol for all the sheets in the summary
groups ??
--
Thanks

Larry


"Bob Phillips" wrote:

> Take that sheet out of the code in the summary sheet.
>
> Or maybe this is what you want
>
> Application.ScreenUpdating = False
>
> With Sheets("Statistics")
>
> .Visible = Not .Visible
> End With
>
> With Sheets("Direct Cost Savings Breakdown")
>
> .Visible = Not .Visible
> End With
>
> With Sheets("Pay Inflation - Biometrics")
>
> If .Visible <> xlSheetVisible Then
>
> .Visible = Not .Visible
> End If
> End With
>
> With Sheets("OT Reduction")
>
> .Visible = Not .Visible
> End With
>
> --
>
> HTH
>
> Bob
>
> "Larry Fitch" <LarryFitch@discussions.microsoft.com> wrote in message
> news:36429FFA-0D09-4E9C-B1E6-4DEC634D62B3@microsoft.com...
> > Hi Bob -
> >
> > You are correct in regards to the toggle concept..
> >
> > What I am trying to figure out is how to prevent a sheet that has been
> > opened individually from being closed when a button assigned to a summary
> > of
> > sheets that contain the same thing is selected..
> > --
> > Thanks
> >
> > Larry
> >
> >
> > "Bob Phillips" wrote:
> >
> >> Your whole code is a toggle concept, hide it if visible and vice versa.
> >> If
> >> you change it to just making it visible if not visible, it will never get
> >> hidden. So I am confused as to your overall objective.
> >>
> >> --
> >>
> >> HTH
> >>
> >> Bob
> >>
> >> "Larry Fitch" <LarryFitch@discussions.microsoft.com> wrote in message
> >> news:30206AF7-1800-44D4-AFF4-57E78AC3FACF@microsoft.com...
> >> >I have created macros assigned to buttons that open and close individual
> >> > sheets. Here is an example -
> >> >
> >> > Sheets("Pay Inflation - Biometrics").Visible = Not Sheets("Pay
> >> > Inflation -
> >> > Biometrics").Visible
> >> >
> >> > I have also created macros that are assigned to buttons that open an
> >> > close
> >> > groups of sheets.
> >> > Here is an example -
> >> >
> >> > Application.ScreenUpdating = False
> >> > Sheets("Statistics").Visible = Not Sheets("Statistics").Visible
> >> > Sheets("Direct Cost Savings Breakdown").Visible = Not Sheets("Direct
> >> > Cost Savings Breakdown").Visible
> >> > Sheets("Pay Inflation - Biometrics").Visible = Not Sheets("Pay
> >> > Inflation
> >> > - Biometrics").Visible
> >> > Sheets("OT Reduction").Visible = Not Sheets("OT Reduction").Visible
> >> >
> >> > The problem I have is that if I have opened a single sheet using the
> >> > button
> >> > for that sheet (in the example at top it is the Pay Inflation -
> >> > Biometrics
> >> > sheet) and I then select the button to open the group of sheets, the
> >> > Pay
> >> > Inflation - Biometrics will close since it was opened by the previous
> >> > macro..
> >> >
> >> > What error checking or other conditional logic can I add so that if a
> >> > sheet
> >> > is already visible it will not be hidden.. ??
> >> > --
> >> > Thanks
> >> >
> >> > Larry
> >>
> >>
> >> .
> >>
>
>
> .
>

Bob Phillips

3/27/2010 12:06:00 PM

0

Not sure what you mean there Larry.

--

HTH

Bob

"Larry Fitch" <LarryFitch@discussions.microsoft.com> wrote in message
news:77508C75-4A3A-49D0-B5D6-0BD5DE5C250E@microsoft.com...
> Thanks Bob-
>
> This worked...
>
> If I can go back to the well one more time - is there a "global" command
> that I can have that will do that contol for all the sheets in the summary
> groups ??
> --
> Thanks
>
> Larry
>
>
> "Bob Phillips" wrote:
>
>> Take that sheet out of the code in the summary sheet.
>>
>> Or maybe this is what you want
>>
>> Application.ScreenUpdating = False
>>
>> With Sheets("Statistics")
>>
>> .Visible = Not .Visible
>> End With
>>
>> With Sheets("Direct Cost Savings Breakdown")
>>
>> .Visible = Not .Visible
>> End With
>>
>> With Sheets("Pay Inflation - Biometrics")
>>
>> If .Visible <> xlSheetVisible Then
>>
>> .Visible = Not .Visible
>> End If
>> End With
>>
>> With Sheets("OT Reduction")
>>
>> .Visible = Not .Visible
>> End With
>>
>> --
>>
>> HTH
>>
>> Bob
>>
>> "Larry Fitch" <LarryFitch@discussions.microsoft.com> wrote in message
>> news:36429FFA-0D09-4E9C-B1E6-4DEC634D62B3@microsoft.com...
>> > Hi Bob -
>> >
>> > You are correct in regards to the toggle concept..
>> >
>> > What I am trying to figure out is how to prevent a sheet that has been
>> > opened individually from being closed when a button assigned to a
>> > summary
>> > of
>> > sheets that contain the same thing is selected..
>> > --
>> > Thanks
>> >
>> > Larry
>> >
>> >
>> > "Bob Phillips" wrote:
>> >
>> >> Your whole code is a toggle concept, hide it if visible and vice
>> >> versa.
>> >> If
>> >> you change it to just making it visible if not visible, it will never
>> >> get
>> >> hidden. So I am confused as to your overall objective.
>> >>
>> >> --
>> >>
>> >> HTH
>> >>
>> >> Bob
>> >>
>> >> "Larry Fitch" <LarryFitch@discussions.microsoft.com> wrote in message
>> >> news:30206AF7-1800-44D4-AFF4-57E78AC3FACF@microsoft.com...
>> >> >I have created macros assigned to buttons that open and close
>> >> >individual
>> >> > sheets. Here is an example -
>> >> >
>> >> > Sheets("Pay Inflation - Biometrics").Visible = Not Sheets("Pay
>> >> > Inflation -
>> >> > Biometrics").Visible
>> >> >
>> >> > I have also created macros that are assigned to buttons that open an
>> >> > close
>> >> > groups of sheets.
>> >> > Here is an example -
>> >> >
>> >> > Application.ScreenUpdating = False
>> >> > Sheets("Statistics").Visible = Not Sheets("Statistics").Visible
>> >> > Sheets("Direct Cost Savings Breakdown").Visible = Not
>> >> > Sheets("Direct
>> >> > Cost Savings Breakdown").Visible
>> >> > Sheets("Pay Inflation - Biometrics").Visible = Not Sheets("Pay
>> >> > Inflation
>> >> > - Biometrics").Visible
>> >> > Sheets("OT Reduction").Visible = Not Sheets("OT
>> >> > Reduction").Visible
>> >> >
>> >> > The problem I have is that if I have opened a single sheet using the
>> >> > button
>> >> > for that sheet (in the example at top it is the Pay Inflation -
>> >> > Biometrics
>> >> > sheet) and I then select the button to open the group of sheets, the
>> >> > Pay
>> >> > Inflation - Biometrics will close since it was opened by the
>> >> > previous
>> >> > macro..
>> >> >
>> >> > What error checking or other conditional logic can I add so that if
>> >> > a
>> >> > sheet
>> >> > is already visible it will not be hidden.. ??
>> >> > --
>> >> > Thanks
>> >> >
>> >> > Larry
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>