Category: Excel-Macro-VBA

0

FileSystemObject : GetFileVersion Method

Description: Returns the version number of a specified file. Format : objectOfFileSystemObject. GetFileVersion (filespec) objectOfFileSystemObject : As the name says, it’s a FileSystemObject. Arguments: filespec Mandatory Type:     String Specific file path

0

FileSystemObject : GetFile Method

Description: Returns a file object corresponding to the file in a specified path. Format : objectOfFileSystemObject.GetFile(filespec) objectOfFileSystemObject: As the name says, it’s a FileSystemObject. Arguments: filespec Mandatory Type:     String Specific file path

2

FileSystemObject : FileExists Method

Description: Returns True if a specified file exists; False if it does not. Format : objectOfFileSystemObject. FolderExists(fileName) objectOfFileSystemObject : As the names says, it’s a FileSystemObject. Arguments: fileName Mandatory Type:     String File , whose...

2

FileSystemObject : CopyFile Method

Description: This function copies one or more files from one location to another. Format : objectOfFileSystemObject. CopyFile (source, destination[, overwrite] ); Arguments: objectOfFileSystemObject As the names says, it’s a FileSystemObject. source Mandatory Type:     String...

0

FileSystemObject : DeleteFile Method

Description: This function Deletes a specific file. Format : objectOfFileSystemObject. DeleteFile (filename [, force]) objectOfFileSystemObject : As the names says, it’s a FileSystemObject. Arguments: fileName Mandatory Type:     String Name of the file to delete.

2

FileSystemObject : FolderExists Method

Description: Returns True if a specified folder exists; False if it does not. Format : objectOfFileSystemObject. FolderExists(foldername) Arguments: objectOfFileSystemObject As the names says, it’s a FileSystemObject. foldername Mandatory Type:     String Folder , whose existence...

0

FileSystemObject : MoveFolder Method

Description: This function moves a Folder from one location to another. Format : objectOfFileSystemObject. MoveFolder (source, destination ); Arguments: objectOfFileSystemObject As the names says, it’s a FileSystemObject. source Mandatory Type:     String Path of a...

0

FileSystemObject : DeleteFolder Method

Description: This function Deletes a Folder. Format : objectOfFileSystemObject. DeleteFolder ( folderspec[, force] ) Arguments: objectOfFileSystemObjectAs the names says, it’s a FileSystemObject. folderspec Mandatory Type:     String Folder name to be deleted. Force

0

FileSystemObject : CreateFolder Method

Description: This function creates a Folder. Format : objectOfFileSystemObject. CreateFolder(foldername) Arguments: objectOfFileSystemObjectAs the names says, it’s a FileSystemObject. foldername Mandatory Type:     String Folder will be created with the same name what you will pass...

0

FileSystemObject : GetAbsolutePathName Method

FileSystemObject : GetAbsolutePathName Method Description: Returns a complete Path from a provided path. Format : objectOfFileSystemObject. GetAbsolutePathName(providedPath) Arguments: objectOfFileSystemObject As the names says, it’s a FileSystemObject. providedPath Path provided to change to a complete...

0

FileSystemObject in Excel Macro

  The FileSystemobject act as an mediator for your code and computer’s system files. Once you create the object of FileSystemObject, using that object you can perform various operations on your computer like create...

Show Buttons
Hide Buttons
%d bloggers like this: