fso object

to all I am using fso object to obtain a file choice from the user. The file will always be an excel workbook I need to copy -paste date form the selected xls file to another one (easy stuff) but the question is: How can I SET this file to a workbook? Thanks John

Hi Folks, Basic goal: To move a folder and its contents into another folder that already exists. Detail: I wish to use VBA to move a single folder called 13) Customer Template (and all its contents including folders) from its current folder-path S:\Projects (5)\13) Customer Template\ to a...

I have the current VBA code for a function within Excel: Sub test() Const strFullName As String = "C:\My Documents\nosuchbook.xls" If FileExists(strFullName) Then MsgBox FileLastModified(strFullName) Else MsgBox "Cannot find the file : " & vbNewLine &...

I am not an expert nor do I have much experience with excel. Here is what I am trying to do: I have some master template files in a directory. I want to Rename the files in the Directory but keep the old files. I have a spreadsheet that lists the files in column A and Column B has the new name...

Hi, makro2 is my folders name. i want to replace the folders' name every time when i write a folder name (only folder name / the folders will be inside the same path) in a textbox on the sheet. For example: If i write Nov-12 to textbox the red lighted part will be Nov-12, if I write Oct-12 to...

Hi, I have filenames populated in Column A and what they should be renamed to in Column B. Something like this: <table width="266" border="0" cellpadding="0" cellspacing="0"><col style="width: 100pt;" width="133" span="2"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl63"...