myfilename

  1. J

    Create .csv file from a workbook sheet with new filename and timestamp

    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...
  2. B

    Subscript out of range (for some users)

    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...
  3. S

    Missing an if issue

    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...
  4. S

    Copying Ranges from One Worksheet to another

    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...
  5. V

    Create a folder structure with VBA

    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 =...
  6. H

    Insert Formula in a cell

    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 =...
  7. R

    VBA - Autofill a VLookup Formula (under a filter)

    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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top