Posts by Quickhelpplz

    Ill have to get some approval on that since these are work documents and contain sensitive material.

    If you can still help without it at this point, that would be great.

    Ill try to explain whats going on in more detail and maybe thatll give you an idea of where im going without the documents.

    I have my Summary Document that all the code is in. It displays a button on the page that allows the user to open a file (wbSource) to be summarized located in the same place as the Summary Document. After which it opens a userform that will allow me to select a begin column and end column on wbSource for the test being summarized.

    The issue im currently working on now is 1. the file that i opened (wbSource) thru the summary document, i want to call it out in the code to specify between the 2 files when summarizing. So the just opened file i want to set = wbsource but i dont know how to do that yet. Ive got

    Set wbTarget = ActiveWorkbook 'to call out the summary document

    That got me a little further but didnt do it. I found a webpage on opening files and it really helped.

    This is the code i ended up using.

    I made a Macro for summarizing tests at work a while ago and it works good. Im now tyring to make another one 3 years later for a different test slightly differently. Im trying to make a macro that will open a directory folder using the current workbooks path and from there i can select an excel document to open. The file is not opening when i select a file but directory opens in the correct spot.

    Here is the code im using.

    to take it a step further, after that document opens, i want another user form (i feel ill get stuck on this part) to open so i can set the parameters for the test being summarized. For example, the start column, how many columns in that test and a few others and then macro will auto populate.

    Thanks in advance

    I've got a Macro that opens a Stability file and reformats that file and then gets the save-as name based off of certain parameters in the stability file. Sometimes we have more than 1 Stability file with the same parameters and it wants to save over the original file.
    Instead, I want a box to pop up so the user can name the file what he wants. Ive got this all to work so far.
    What I need, is to specify the file format so that when the user saves the file, its .xlsm. Right now it defaults to .txt. How do I go about getting the save-as box to pop up already in .xlsm file format?

    I got it so the Anchor would take. This is what I have now.

    Dim sXLFile              As String
        Dim Anchor               As Object 'I don't think I need this
        Dim TextToDisplay   As Object 'I don't think I need this either but put them in there just in case
        Dim cell                     As Range
            Sheets("Duct TC Map").Activate
            sXLFile = "U:\ENG\Lab\Lab 3\EH Test Notes & TC Maps.xlsx"
            ActiveSheet.Hyperlinks.Add Anchor:=Cells(cell.Row, 1), Address:=sXLFile, TextToDisplay:="Add Duct TC Map"

    Im getting the following error on the very last line.

    Run-time error '91':
    Object variable or With block variable not set

    Im trying to create a hyperlink on a sheet using vba but I cant get it to execute. The Anchor part doesn't seem to take it my code since the 'a' is not capitalized. What do I need to correct or is there a different way to do it?

    Dim sXLFile     As String
    sXLFile = "U:\ENG\Lab\Lab 3\EH Test Notes & TC Maps.xlsx"
    ActiveSheet.Hyperlinks.Add anchor:=Cells(1, A), Address:=sXLFile, TextToDisplay:="Add Duct TC Map"

    Thanks in advance for any help provided.

    I don't know why this is so difficult to find, but im not sure how to edit my title. Ill keep looking and change it if I find the edit button.

    The code that you provide SO worked so thank you for your assistance with that.

    do you want me to change my title?

    The Application.Getopenfilename opens the folder that is the same location to which my main document with the Macro is in, however I want to open a specific file path that is on the shared drive so that I can select whatever file I want in there, and then it will copy all the sheets into my main document with the Macro in it.

    I'm using Shell, because that was the only thing online I found that worked. To be honest, I have no idea what shell does. is there a way to use the application.getopenfilename to opena specific path?

    I hope this helps clarify my problem.

    Ive got a Macro File that is to open a folder, the user selects the file in that folder, and it copies all sheets into the Macro File. This is what I have,

    This part works. What I want to do is change the 'filename = Application.GetOpenFilename' to 'filename = Shell("explorer.exe U:\ENG\Lab\Master Lab Files & Logs\Lab Electronic Test Requests", vbNormalFocus)' so that it looks like the following where it then stops on the line 'set'

    What am I doing wrong here?

    Okay, Ive got it down to open the file location I want. Im not sure what Shell does, but it works.
    Now I select the file I want, and I need it to copy all tabs on that file and insert them into my original document.

    [VBA]Private Sub CommandButton1_Click()
    Call selectfile3
    End Sub
    Sub selectfile3()
    Dim TestRequest As Long
    TestRequest = Shell("explorer.exe U:\ENG\Lab\Master Lab Files & Logs\Lab Electronic Test Requests\", vbNormalFocus)

    End Sub[/VBA]

    Im trying to write a Macro in a summary document so that I can open a specific browsing path, the user would select the file they want to use from the path, and then once they select the file, it would copy all the tabs in that document and move/copy them into the summary document.

    So what I have so far is the below code
    [VBA]Sub selectfile1()
    Dim fNameAndPath As Variant

    fNameAndPath = Application.GetOpenFilename(FileFilter:="Excel Files (*.XLS), *.XLS", Title:="Select File To Be Opened")

    If fNameAndPath = False Then Exit Sub
    Workbooks.Open Filename:=fNameAndPath
    End Sub[/VBA]

    But it doesn't open the specific path I want which is U:\ENG\Lab\Master Lab Files & Logs\Lab Electronic Test Requests\

    How do I go about this?
    I know how to opne up a specific file in a specific path and copy it into my workbook, but the specific file can vary and I want that option to be there.


    Okay I got it. I used the following
    Application.DisplayAlerts = False
    Sheets("Room Inital Component Sheet").Select
    Sheets("Room Final Component Sheet").Select
    Application.DisplayAlerts = True[/VBA]

    I've got a Macro that I'm working on where depending on what project we are doing, it will format the pages a certain way. After I format it, I use the macro to copy and paste the info across other sheets in the same workbook. Those cells already have data in them.
    The box that pops up says "there is data already here. do you want to replace" options are "yes" or "no". If I want it to select yes automatically, is there a way to do that in the code?

    First let me start off by saying, thank you for the response and your willingness to help. The code that you put does not make complete sense to me and seems more complicated.
    This is the above code I ended up using.

    [VBA] If Lab2meterlog = True Then
    Workbooks.Open Filename:= _
    "U:\ENG\Lab\Master Lab Files & Logs\Logs\METER LOG.xls"
    Sheets("Lab #2 Meter Sheet").Select
    Windows("Documentation Template1.xlsm").Activate
    Windows("METER LOG.xls").Activate
    Application.DisplayAlerts = False
    End If[/VBA]