wname

Hi and thanks in advance! Imagine I have a Path and a String: wPath = "C:\Users\MrExcel\Desktop\Works" wName= "France" I would like to prompt the user to select any Excel file within the Path = wPath containing the Name = wName I know How to prompt the user to select within the Folder wPath...

Hi all, I would like to transfer some moduls from a opened workbook to another one Here is the code to create a new workbook ‘’workbook2’’ from an active worksheet of an other workbook ‘’workbook 1’’ Does someone know how to transfer the ‘’modul1’’ and the ‘’modul2’’ from the workbook1 to...

Dear All, I am trying to open a new workbook and then copy date from main sheet to newly open workbook but getting error at "Workbooks(wname).Activate" as "subscript out of range" how to solve this.... I used workbook (2) instead of wname and its work but following macro not working...

Hello all! I'm trying to write certain cells to a text file. What I have it doing is allowing me to type in the name to which a folder and file will be created. The file naming works and folder is created but I can't seem to get the bolded part to work. Any suggestions? Thanks...