Date - time - number - problem

Hi Wim

Try the DateSerial function or DateValue. eg;

Dim dDate As Date
dDate = "12/22/2001"
dDate = DateSerial(Year(dDate), Month(dDate), Day(dDate))
MsgBox dDate

OR

Dim dDate As Date
dDate = Format(DateValue("12/22/2001"), "dd/mm/yy")
MsgBox dDate

Dave

OzGrid Business Applications

Dave Hawley

I was unable to access the 'post message page', so had to do it this way.

How can I remove an unwanted office toolbar that keeps appearing on the right side of my screen no matter what program I am running. This began after I installed a printer!

appreciate any help.

jonathan

Re: Dave Hawley

You will need to find out the name of the Toolbar or better yet, which application it is from ?

When you get the name of it try substituting it in one of the codes below:

Private Sub Workbook_Open()
Application.CommandBars("Standard").Visible = False
End Sub

Private Sub Workbook_Open()
Application.CommandBars("Standard").Enabled = False
End Sub

But before you do that try the below. Close out of Excel and go to Start>Run and type in:

Excel /s

There is a space after Excel.

This forces Excel to bypass all files in the <Windows
Dir>\Application Data\Microsoft\Xlstart folder or ttalternate startup file location. It also forces Excelto bypass the toolbar file (Excel.xlb or <username>.xlb). You will see "Safe Mode" in the
Excel title bar. Use this switch when you want to
start Excel in safe mode.

Failing this I would suggest running scan disks then go to the site of your printer and make sure the Printer Driver is up to date. If not you will be able to download one for free.

Dave
OzGrid Business Applications

Re: Dave Hawley

Thank you Dave. I was unable to delete the toolbar, so I did the next best thing: removed it from the startup menu.

For all intents and purposes that seems to do the trick.