strdir

  1. B

    excel vba save worksheet as pdf.

    I'm having issues with this code not saving my file. I get an error 1004. it worked before. does any one see any issues with this code? Option Explicit Sub SaveAsPDF() Dim strDir As String strDir = CreateObject("WScript.Shell").specialfolders("Desktop") & "\Daily Reports\" If...
  2. B

    check if folder exist with wildcards

    I would like to use a wildcard to check if a folder exist. i have tried the following: "C:\Users\*\Desktop\New folder" "C:\Users" & "*" & "\Desktop\New folder" "C:\Users\ + "*" + "\Desktop\New folder" i get, "bad file name or number." is there a way to do this? Sub TestForDir()Dim strDir As...
  3. M

    Is there a way to trigger a sub from inside another sub?

    I have a commandbutton_click sub that I would like to code so that a folder is created. Is there a way to call on a function/sub and to have it run its code and then go back to the commandbutton_click sub to finish? The function is below... Function MkDir(strDir As String, strPath As String)...
  4. D

    change specific file extension

    How change specific file extension ? Sub changeExt() strDir = ThisWorkbook.Path & "\" Set fso = CreateObject("Scripting.FileSystemObject") Set f = fso.GetFolder(strDir) With CreateObject("wscript.shell") For Each file In f.Files If...

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