myfilename

Hi all, Im not great at VBA by any means but since moving to mac I cant seem to do anything i used to do with ease. I am simply trying to create a macro that copies a sheet in my active workbook to a new .csv file with that sheet name as the title and todays date and time in the newly...

What is the most likely cause for this bit of code to work for one user but not another? It throws a subscript out of range error at the highlighted line when users other than me run it. This issue has vexed me for over 2 weeks now so any assistance is greatly appreciated, in advance. I will...

I messed up an if here and was hoping someone could check it for me Private Sub Save_As()'Creates the SaveAs "Current Voyage" on the Noon Sheet Dim Path1 As String Dim Path2 As String Dim Path3 As String Dim myfilename As String Dim fpathname As String Dim resp As...

I read on a website tutorial that a more efficient way of copying and pasting ranges was to use the following: ' This is faster Range("A1:A10").Value = Range("B1:B10").Value ' This is slower Range("B1:B1").Copy Destination:=Range("A1:A10") I was led to believe this way made the code run...

Hello all This piece of code checks to see if a folder with the value "MyContact" exists and if not creates a folder on my S Drive with the folder with the value of "MyContact" It then saves the active sheet in this folder with the value from "MyFileName and "Mydate" sDir =...

Dim wb As Workbook Dim ws As Worksheet Dim TotalTrans As Integer Dim FoundRow As Range Dim MyFolder, MyFile, MyFileName, MySheetName, ReportDate As String Dim FileType As String Dim MisFileName() As String, PaymentFileType() As String Dim MisTrans() As Integer Dim i, j, k, m As Integer i = 2 j =...

Hi all, I'm currently trying to make a macro which autofills a Vlookup from another workbook. I managed to get most of the macro working, except that it would't autofill to the rest of the empty spaces in row BA no matter what I tried. It was to only be the empty cells under the filters setup...