Search results

  1. W

    problem with run macro using comman button

    i have created a comman button to run a macro which the macro simply run several queries and at the end export a table to a spreadsheet. the problem is that it seems that it got no problem to run those queries but only at the end when it's done, it just hangs there and i've to shut down the...
  2. W

    Open a specific excel file using runapp function

    Re: Open a specific excel file suing runapp function thanks ! it's working now...:D
  3. W

    Open a specific excel file using runapp function

    Re: Open a specific excel file suing runapp function sorry, i pasted wrongly, it should be Dim stAppName As String stAppName = "excel.exe D:\ABC folder\NEW Project\POLICYTABLE.xls" Call Shell(stAppName, 1) really? you can work even there is space between words in the path ?
  4. W

    Open a specific excel file using runapp function

    hi i have a problem whtn i trying to use runapp function to open a specific excel file, the problem is the path name of the folder e.g. when i tried Dim stAppName As String stAppName = "excel.exe D:\POLICYTABLE.xls" Call Shell(stAppName, 1) it got no problem and open the file...
Back
Top Bottom