Results 1 to 3 of 3

excel can not find folders

Threaded View

cfinch100 excel can not find folders 02-07-2013, 04:38 PM
GregJG Re: excel can not find folders 02-07-2013, 05:24 PM
cfinch100 Re: excel can not find folders 02-07-2013, 05:35 PM
  1. #1
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    Post excel can not find folders

    hi
    not sure what is happening here trying to copy one workbook book1 from folder my documents to desktop folder new
    "c:\users\colin\documents\book1.xlsx" to "c:\users\colin\desktop\new
    " for some unknown reason will not recognise any folder any ideas
    have also tried other code
    like one below it always saves to my documents instead of new on desktop ,why? please


       Dim Directory As String
        Dim FileName As String, originalFileName As String
        Dim yourFileName As String, increName As String
        Dim xTrue As Integer, r As Integer
        Dim myPath As String
        myPath = "C:\Users\colin\Desktop\new\"
        DoEvents
        keybd_event VK_LMENU, 0, KEYEVENTF_EXTENDEDKEY, 0
        keybd_event VK_SNAPSHOT, 0, KEYEVENTF_EXTENDEDKEY, 0
        keybd_event VK_SNAPSHOT, 0, KEYEVENTF_EXTENDEDKEY + KEYEVENTF_KEYUP, 0
        keybd_event VK_LMENU, 0, KEYEVENTF_EXTENDEDKEY + KEYEVENTF_KEYUP, 0
        DoEvents
        Workbooks.Add
       
        
        Application.Wait Now + TimeValue("00:00:01")
        ActiveSheet.PasteSpecial Format:="Bitmap", Link:=False, DisplayAsIcon:=False
        ActiveSheet.Range("A3").Select
        ActiveSheet.PageSetup.Orientation = xlLandscape
        Application.DisplayAlerts = False
    ActiveWorkbook.SaveAs
    Application.DisplayAlerts = False
    '--------------------------------

    cheers colin
    Last edited by cfinch100; 02-07-2013 at 04:50 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1