drug interaction list

Updates from March, 2012 Toggle Comment Threads | Keyboard Shortcuts

  • Krishnan 21:43 on March 24, 2012 Permalink | Reply  

    How to create a .ics file? 

    Whether you use calendars in your Apple products or Microsoft Products or web based systems like Google or Yahoo, the connecting thread is the .ics file. You import/export calendar information using the .ics files.

    Traditionally you paid for the software that permitted you to create .ics files. Programs like MS Outlook or iOS. If you didn’t pay for the software, you had to pay for the connectivity to generate an .ics file from a web based calendar service.

    I discovered, just today, that Sunbird 1.0 beta1, a standalone free calendar program by Mozilla foundation now lets you work offline and create .ics files. I just want to put in the good word. Does Sunbird handle time zone differences and daylight savings well? Well, I don’t know for sure but I think we have program that fills a sweet spot.

  • Krishnan 12:41 on March 24, 2012 Permalink | Reply  

    How to : Program a MS Excel Form 

    If you are trying to make an excel form, chances are you lost at the many objects lying around on your form and are baffled as to how all the pieces fit together.

    They key thing in writing a form is understanding how many objects are used and what minimum code must support each object and action. If you are lost and dont know what piece of code to write next, here are some simple guidelines I follow myself in programming my forms for performing engineering calculations.

    1. Throw all objects you want on a form. Inputs and Outputs.

    2. For an engineering calculation, if any input parameter changes, all outputs must vanish. Otherwise your form risks the possibility of displaying the incorrect value from a previous calculation before the current calculation is performed.

    3. Initialize the form using built in “UserForm_Initialize()” function.

    4. Initialisation of the form can be performed by a separate macro which pouplates the initial values to be displayed.

    5. Use the most common three buttons as set in 6, 7 and 8

    6. “Close” button unloads the form

    7. “Clear” button can be used to invoke the initialization macro or clear the all input and output fields by making them blank.

    8. “Calculate” button begins the calculation sequences.

    9. When starting a calculation, first step is to check the inputs.

    10. Check the inputs one by one. If inputs are not correct dont perform the calculation. If inputs are correct, read and interpret the inputs alongside.

    11. Perform calculations. Use UDFs as necessary.

    12. Estimate results. Diplay results as Label Captions.

    Have Fun!

  • Krishnan 22:52 on March 13, 2011 Permalink | Reply  

    How to : Edit Background Graphics in Powerpoint? 

    You have an PPT file from an older version of MS Office that opens in Office 2007. There are images on the master slide that seem to be not  editable. But you can hide them by selecting on “Hide Background graphics”. How do you edit whatever graphics that are controlled by the Background Graphics button?

    Go to view, slide master then make sure you select the first slide in the list on the left. When you are on that first slide you can select and edit these types of background items.

    • SARA 01:10 on August 10, 2012 Permalink


    • Anne 19:56 on November 13, 2013 Permalink

      Excellent, Thank you very much for this tips ♥♥♥

    • Chris 03:27 on January 29, 2014 Permalink

      Thank you. This was tip I was looking for in office help, no chance.

    • Chantal 00:22 on February 2, 2014 Permalink

      Most straightforward instruction… thank you!!

    • mohd shawqi 00:24 on March 25, 2014 Permalink

      thank you very much , a huge secret just has reveled ..

    • Rajaramdev Sharma 15:26 on June 25, 2014 Permalink

      wow mind blowing research

    • Ralph 22:01 on September 14, 2014 Permalink

      Thanks so much. This is exactly what I was looking for

    • don 15:27 on February 16, 2015 Permalink

      I still cannot edit the actual logo graphics that are curretly embedded? They are not clickable.

  • Krishnan 22:17 on December 26, 2009 Permalink | Reply  

    How to : Multiple login in yahoo messenger 

    You can have multiple instances of yahoo messenger which can be used to login with different IDs – without any download or patch .
    To have multiple instances of yahoo messenger, follow these steps :
    1. Go to Start —-> Run . Type regedit, then enter .
    2.Navigate to HKEY_CURRENT_USER ——–> Software —>yahoo —–>pager—->Test
    3.On the right page, right-click and choose new Dword value .
    4.Rename it as Plural.
    5.Double click and assign a decimal value of 1.

  • Krishnan 12:12 on October 21, 2009 Permalink | Reply  

    VBA support in OpenOffice.Org Calc 

    For many years till yesterday, I knew about OpenOffice.Org Calc. Today, I’m excited about it.

    I tried OpenOffice many years ago. It could do few things back then, but I immediately dismissed as inadequate for my needs. I have always been a fan of what VBA could do for Excel.

    Last week, I completed the most complex piece of VBA application I’d ever written. I am a VBA newbie and it took me a week  to finish my code that could be printed on 28 A4 pages. My spreadsheet till date works flawlessly on XP/Office 2003 like it is supposed to, but I wrote most of my code in Vista/Office 2007.

    When I upgraded to Debian Squeeze, Openoffice.org 3.1.1 came with it. I checked out the new version and was impressed that one could write macros in Python, Javascript, BeanShell in addition to BASIC.

    I tried to open my most complex piece of VBA code in Openoffice.org and I was bombarded with hundreds of repetitive error messages that I had to kill the spreadsheet from the command line. I was convinced that VBA and OOoCalc are not compatible, till I discovered this site by accident when trying to learn to write Javascript Macros in OOo.

    OK. All I needed to add was “Option VBA Support 1″. That didn’t sound too difficult, so I tried opening my spreadsheet  again and had to again kill everything from command line.

    Some thing was not right and I wasn’t being able to run VBA despite the promised compatibility.

    So I decided to go slow. No matter how many times, I couldn’t run the macros when I opened the native excel file. So I decided to open the excel file with macros disabled. That let me open the spreadsheet, but nothing was working. I found that OOoCalc automatically had added “Option VBA Support 1″ to my modules.

    I saved the file as .ODS and proceeded to debug by enabling macros again. This time, errors didn’t come in a flood.They came one at a time and it was easier to debug.

    The first set of errors related to variables which did not have an explicit Dim statement. VBA in Excel seemed more forgiving in handling varaibles without proper Dim statements. But OOo Calc didn’t like it. So I ended up adding a few Dim statements for some variables.

    The next set of errors was with Excel UDF names. OOo Calc likes to see Functions being invoked with uppercase letters. So if you’d used lower case letters in Excel, they would show up as errors. This could be easily fixed by use of find and replace feature.

    With just these two things, fixed my new .ODS file worked perfectly. I then saved it as .xls and re-opened the .xls and everything was still working. Though OOo Calc  documentation still says that not all VBA features are supported, VBA runs well on OOoCalc for all practical engineering calculations. So now is the time for me to make the switch.

    Now if you have difficulties, in getting  your VBA code to work  in OOo Calc, dont give up soon.

    • Rakesh 20:45 on November 7, 2009 Permalink

      I have tried doing what u have mentioned, but still it doesn’t work.
      if SHEET1.CELLS(7, 4) = “” Or SHEET1.CELLS(9, 4) = “” Or SHEET1.CELLS(10, 4) = “”

      In this line i am getting property or method not found.

    • Krishnan 23:07 on November 9, 2009 Permalink

      The syntax is obviously incorrect as I can see.

      If, Then, Else are the keywords to be used. Not Or.

    • james 20:16 on February 7, 2010 Permalink

      ingnoring the “rems”
      how would you right this in OOo ?? i cant work out OOo – pls get me started ??
      Rem Sub Words()
      Rem ‘
      Rem ‘ Words Macro
      Rem ‘ Macro recorded 07/02/2010 by Owner
      Rem ‘
      Rem ‘ Keyboard Shortcut: Ctrl+w
      Rem ‘
      Rem Dim NumWords As Integer
      Rem Dim WordLength As Integer
      Rem Dim Count As Integer
      Rem Dim Count2 As Integer
      Rem Dim Lcase As Integer
      Rem Dim Word As String
      Rem Dim MixedWord As String
      Rem Dim Letter As String
      Rem ‘ Worksheets(“Words”).Activate
      Rem Set wordRange = Worksheets(“Words”).Range(“A1:A500″)
      Rem NumWords = Application.WorksheetFunction.CountA(wordRange)
      Rem For Count = 1 To NumWords
      Rem WordLength = Len(Cells(Count, 1))
      Rem ‘ Application.EnableSound = False
      Rem ‘ Application.EnableSound = True
      Rem Word = Cells(Count, 1)
      Rem ‘ Cells(Count, 1).Activate
      Rem ‘ ActiveCell.Characters(1, 3).PhoneticCharacters = Word
      Rem MixedWord = “”
      Rem For Count2 = 1 To WordLength
      Rem Letter = Mid(Cells(Count, 1), Count2, 1)
      Rem ‘ Application.Speech.Speak (Letter)
      Rem Lcase = Round(Rnd)
      Rem If Lcase = 1 And Asc(Letter) >= 97 Then Letter = Chr(Asc(Letter) – 32)
      Rem MixedWord = MixedWord + Letter
      Rem Next Count2
      Rem Cells(1, 5) = MixedWord
      Rem Dim Message, Title, Default, MyValue
      Rem Message = “Ready Monkey ?”
      Rem Title = “Honors spelling game.”
      Rem Default = “YES”
      Rem MyValue = InputBox(Message, Title, Default)
      Rem For Count2 = 1 To WordLength
      Rem Letter = Mid(Cells(Count, 1), Count2, 1)
      Rem Application.Speech.Speak (Letter)
      Rem Next Count2
      Rem Application.Speech.Speak (Word)
      Rem If MyValue “YES” Then
      Rem Application.Speech.Speak (“That’s wrong pooey – you entered”)
      Rem WordLength = Len(MyValue)
      Rem For Count2 = 1 To WordLength
      Rem Letter = Mid(MyValue, Count2, 1)
      Rem Application.Speech.Speak (Letter)
      Rem Next Count2
      Rem Application.Speech.Speak (MyValue)
      Rem End If
      Rem Next Count
      Rem End Sub

Compose new post
Next post/Next comment
Previous post/Previous comment
Show/Hide comments
Go to top
Go to login
Show/Hide help
shift + esc