Search results for query: *

yeah, quit a bit harder...might start reading here. http://support.microsoft.com/default.aspx?scid=kb;en-us;218965 you can use the file object attributes to get other info such as date created an so-on.

You would have to use a variant to do that... Dim testvar As Variant testvar = Sheet1.Range("A1", "A4") gives you the values in multi dimensional variant testvar( 1 to 4, 1 to 1) testvar = Sheet1.Range("A1", "C4") would give you... testvar( 1 to 4, 1 to 3)

If GetAttr("c:\yourfile.txt") And vbReadOnly Then MsgBox "File is Read-only" 'set to normal SetAttr "c:\yourfile.txt", vbNormal 'copy the file here 'set back to read-only SetAttr "c:\yourfile.txt", vbReadOnly Else MsgBox "File is not...

In VBA, you do it like so... Sheet1.Range("A2", "B5").Copy Dim myRet As Boolean myRet = Sheet1.Range("A7").PasteSpecial(, , , True)

The following code should let you play WAV, MIDI, or AVI files. ----------------------------------------------------------- Step 1. The following code is just a switch to determine the file type and the command to play it: 'full file path of file to play dim strFileName as string...

Big Thanks to MisterCfromIT for his 18 Feb 05 post. The method he described for registering the control allows it to be used in VB.NET.