mydir

This code works great to combine all workbooks from a folder in another master workbook. Problem though, to get it to run I have to remove the ActiveWorkbook.Close True part because that closes the workbook that I'm running the code from. The destination workbook. How can I say, if the file...

Hi, Very new to VBA and currently using to the below code to create a folder and pdf from one worksheet within excel. Sub APOrderForm() Dim myDir As String, myDirSub As String, mySht As String, c As Range myDir = "P:" & ActiveSheet.Range("C16").Value mySht = Range("C16").Value On Error...

Hi I have a tiny file that list all files from a SharePoint directory (https: ) When I run the macro it stop on : objNet.MapNetworkDrive "A:", myDir Error: "The operation being requested was not performed because the user has not been authenticated." But if I open another file (and do...

I have multiple .xml files in a folder and I need to place them in an Excel worksheet one on top of the other. So far with the code below, it works to extract the first file, but when trying to extract the next file, I get the error... Sub LoopThruFolder() Dim MyFile As String Dim...