Search results for query: *

Sorry that is for foxpro. Here's another solution in VB, hope this one can help. I had thought that the answer would be shrouded in obscurity and mystery, and require the use of either the registry or the initialization file functions in the Win32 API, along with some spying tools to see from...

i think the problem is the default date of your system setting is in mm dd yy format. You can check your regional options in control panel. If you want to code it... you can look for some API that will trigger upon loading of your Excel file. You can refer to this link...

This will help you.. Sub HideSheet() Worksheets("Sheet2").Visible = False Worksheets("Sheet3").Visible = False End Sub Sub ShowSheet() Worksheets("Sheet2").Visible = True Worksheets("Sheet3").Visible = True End Sub For those who don't know how to place...

Syntax: expression.Unprotect(Password)

i think you accidentally locked the work book to unprotect .. try this This example removes protection from the active workbook. ActiveWorkbook.Unprotect

try this ' Hide Worksheet For Each sh In Sheets sh.Visible = False Next sh 'Gray

I Guess ... I'm not the only one who encountered this problem.. Here's my solution. this will remove all those weird boxes.. Private Function ClearString(strWord As String) As String Dim xstr As String xstr = Replace(Trim(strWord), Chr(7), "", , , 0) ClearString =...

Hi Guys... I need to find out how to retrieve the tables contents text in plain text format. If I use ActiveDocument.Tables(1).Cell(1,2).Range.Text it gives me wierd little boxes ..like this "Test Data" Please help Thanks GrayFox

Hi Guys I'm surfing the net and found this site very interesting, and I want to give it a try,I'm planning to create a Wizard using Visual Basic that will export large dbf files to Microsoft Access .mdb, the .DBF files were created using DBU.exe. my problem now is how on earth can i get a...