shellexecute

  1. Jaafar Tribak

    Extract Thumbnail preview from file

    Hi all, workbook example Extracting a thumbnail from a file (thumbnail as shown in windows file explorer) normally requires the use of a typelib but with the assistance of the handy DispCallFunc API function, one can execute a requested interface Method w/o the need of an external typelib...
  2. btorrean

    Excel VBA Can't Open URL on Windows and a 64-bit Mac

    Please note: This post is a cross-post. I posted this question on Feb. 23rd on Stack Overflow and have not gotten any responses. I am posting here in hopes that someone may have not seen that post and may be able to help me here. Here's the link to the cross-post on Stack Overflow: link. I...
  3. svendiamond

    Disable Hyperlink Warning!

    I have a macro button that automatically runs three reports (excel spreadsheets) from my company's intraweb database application. The only issue with this is the hyperlink warning message that automatically pops up. It basically warns that some files from the internet may be harmful and make...
  4. R

    VBA code to open files in an application using Shell

    I'm relatively new at VBA, and I am developing this excel based tool that creates two .xls files, whose paths are saved in two variables. The next step is the user has to select these two files, right click and select an application called Compare. I was wondering if this process could be...
  5. J

    ShellExecute Excel 2010 64-bit doesn't start fresh copy of Excel

    I have a process that runs all day, gathering data from the web, storing that data on an xlsx file, closing that file, and starting another xlsm book that further process the data while the original process goes back for more collection ( collection of other "parts" of the whole range of data...
  6. I

    Truncation problem with data to email

    I'm using ShellExecute to launch my default email application and a macro to collect data and store it to a string to be used as the "body" of my email. The problem is that there my be 30 rows of data to list but once it goes to the email only about 18 rows of data survive the transfer from...
  7. I

    Line break Using ShellExecute for email Possible??

    I've tried various methods vbCrLf, vbLf, Chr(10) & CHR(13), vbnewline They work great in the immediate window but my email is one continuous line. I'm really hoping someone has a solution because the only other alternative that I can think of is to try to write to a text file and then do a copy...
  8. L

    Generate an ODBC Connection (with a .bat)

    Hello all, I am trying to use my program to set up an ODBC connection on the user's computer. I am trying to make it more user friendly for the other people that may want to use my file in the future, and it entirely depends on this database query. Below is some code that I tried for...
  9. Jaafar Tribak

    ShellExecute API not working as expected .

    Here is the problem. When I try opening the file "C:\MyBook.xls" in a second excel instance via the above API function not only does it not open the file it also blocks the keyboard on the current application ! - I get no error message . Has anybody experienced this before ? I have tried many...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top