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...
i think you accidentally locked the work book
to unprotect .. try this
This example removes protection from the active workbook.
ActiveWorkbook.Unprotect
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.