Search:

Type: Posts; User: Jetx227; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.00 seconds.

  1. Replies
    0
    Views
    125

    Do Until Workbook Opens

    Hi guys,
    So I found this thread from a while ago (2008) https://www.mrexcel.com/forum/excel-questions/361577-wait-till-workbook-opens-calculates.html and the idea behind it is exactly what I want,...
  2. Replies
    15
    Views
    558

    Re: Dir Do Until Loop not working

    Hi Fluff,
    I just realized that when I tested your code, I forgot to change one line of my commands to call objFile and not what I had previously been using, which is what caused the issue of only...
  3. Replies
    15
    Views
    558

    Re: Dir Do Until Loop not working

    I think its still because of adding that file and removing it, Im not sure why but I think it just messes with the file order or something
  4. Replies
    15
    Views
    558

    Re: Dir Do Until Loop not working

    This almost worked. It just pulled the first file as many times as there are files in the folder. (So if I have a folder with 3 files, it'll pull the first file 3 times).
  5. Replies
    15
    Views
    558

    Re: Dir Do Until Loop not working

    Yeah, I was just trying to read into it more and I think that your explanation of what it does makes sense. I got it now so that I just use the loop that jma gave me to save the file names in a...
  6. Replies
    15
    Views
    558

    Re: Dir Do Until Loop not working

    So I'm fairly certain that because I'm adding a new file and changing the dynamic of the folder (even though I delete the new file before the loop looks at the file location again), the dir function...
  7. Replies
    15
    Views
    558

    Re: Dir Do Until Loop not working

    Hi Gallen,
    This had the same issue, still only pulled the first file (see my reply to jma's post, could it be my commands that affect it?)
  8. Replies
    15
    Views
    558

    Re: Dir Do Until Loop not working

    Hi jmacleary,
    So I just adjusted your code slightly and it worked perfectly, it pulled all the names of the files. Although when I tried to use my commands it is still on pulling the first file for...
  9. Replies
    15
    Views
    558

    Re: Dir Do Until Loop not working

    Hi there!
    I tried this and updated the code to:


    For Each objFolder In objFolders
    FileName = Dir(FilePath & "" & objFolder.Name & "\*.*")
    Do Until FileName = ""
    'Some Commands...
  10. Replies
    15
    Views
    558

    Dir Do Until Loop not working

    Hi guys! I have this for loop iterating through each folder in a file path, then it goes into the folder and gets the names of the files. Only problem is that while it should be getting the name of...
  11. Replies
    3
    Views
    129

    Re: Error Expected =

    Worked, Thanks!
  12. Replies
    3
    Views
    129

    Error Expected =

    I'm getting an error 'Expected =' and I'm not sure why.

    This is the line it didn't like.


    Sheets(1).copy(after:=Workbooks("Report").Worksheets(Workbooks("Report").Worksheets.Count))

    I'm...
  13. Thread: PDF To Excel

    by Jetx227
    Replies
    1
    Views
    236

    PDF To Excel

    Hi guys!
    I'm not sure if the excelforum website is also part of this forum or not, but I posted a question there and I'm gonna post it here as well because I'm a little short on time. Thanks for any...
  14. Thread: VBA timestamps

    by Jetx227
    Replies
    5
    Views
    181

    Re: VBA timestamps

    This works great! And yeah, I'm just gonna adjust column widths from now on (haha). Thank you!
  15. Thread: VBA timestamps

    by Jetx227
    Replies
    5
    Views
    181

    Re: VBA timestamps

    Ok, just ran it, and yeah, I have a number value in J7 that the I change (so I wanted to keep the time and date of the last time I updated it) and Col U is currently empty but as I update it I wanted...
  16. Thread: VBA timestamps

    by Jetx227
    Replies
    5
    Views
    181

    VBA timestamps

    Hey guys,
    So recently I used a thread I saw on here to create a code that will input a time and date whenever a cell value changes. I used it for one range (the first part of my code that I will...
  17. Replies
    0
    Views
    111

    Macro to print Page view

    Hey guys, I'm not great at macros but I can imagine there is one that can help me, I'm just not sure how to make it. This will be a bit hard to explain because I'm not sure how to share a workbook on...
  18. Thread: Hide Column

    by Jetx227
    Replies
    1
    Views
    167

    Re: Hide Column

    I think a userform would work the best for what you are looking for.
    Check out this link, it explains very well how to create one:
    https://www.excel-easy.com/vba/userform.html

    When you create...
  19. Replies
    1
    Views
    163

    Re: Searchable Drop Down List Input

    So I decided to try a VBA code instead because I thought it would be a lot simpler (although I am pretty new to VBA code so bear with me). I tried to make a vba code where you click a button and an...
  20. Replies
    1
    Views
    163

    Searchable Drop Down List Input

    Hey guys,
    So I have a sheet that has a list of items (A5 through A20,000, approx). Column B is for unit prices but they are not filled in. I want to populate this column for only specific items (as...
  21. Replies
    5
    Views
    204

    Re: Custom Number Format

    Great, thanks!
  22. Replies
    5
    Views
    204

    Re: Custom Number Format

    Will this let me add 2 together (seperate cells)? I'm looking to be able to add 2 of them.
    Example: 2+00 + 0+25 = 2+25
    In numbers: 200 + 25 = 225
  23. Replies
    5
    Views
    204

    Custom Number Format

    I looked through quite a bit of posts to see if I could find one that was similar to my question but couldn't find it (if there is, sorry, please link it and that will be greatly appreciated)....
  24. Re: Inputting Items and Descriptions into database

    I figured it out, all I did was input



    Range("A" & lR + 1).Value = "'" & Range("A" & lR + 1).Value


    into the With statement.

    Thanks for your help!
  25. Replies
    3
    Views
    257

    Re: Sort columns A:C but leave others

    Try something like this



    Sub Sort_Col()

    Worksheets("Sheet1").Columns("A:C").Sort key1:=Range("A2"), order1:=xlAscending


    End Sub
Results 1 to 25 of 51
Page 1 of 3 1 2 3