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

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top