wb.name

Hi, I have an excel macro template. I wrote a VBscript to call upon that excel and run those macros. Each time I run the VBscript - after it ended it would leave a TMP file in the destination folder and create a cluster in the folder. What should I do so that after I run the script, it won't...

In the following code, I am getting error when saving the file...... Please help Sub Del_Column() Dim wb As Workbook Dim wbName As String wbName = "Book" For Each wb In Application.Workbooks If wb.Name Like wbName & "*" Then Debug.Print wb.Name...

Hi Guys, I have a code that opens up and stores a workbook.name (wb.name) and then a array that loops through sheet names (.arrSht(I)) how do I include the word "Breakdown" at the end of arrSht(I) in the below formula. "=VLOOKUP(RC[-2],'[" & wb.Name & "]" & arrSht(I) & "'!C1:C2,2,0)" many...

Hello all, I am driving myself crazy trying to figure this out, I have an Excel program that goes into SAP, runs some functions then exports the data into a default folder. The issue I am running into is how to close the export file after export? Once the VBA program completes the file remains...