Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Sparky1157

    ANSWER: Automate pasting an image into a Microsoft email message without raising a security alert

    My environment is a corporate workplace which has all of our applications on extreme lockdown. This leaves me with only Microsoft Outlook and VBA to work with, as is, out of the box. I was trying to generate an email message and insert an image file into it prior to sending. However, this...
  2. Sparky1157

    Automate clicking a button in a popup window

    Thank you, strongm, for your timely response! I truly appreciate all the information you shared. While I understand the need for Microsoft Outlook to protect against someone sending emails out to everyone in an address book, that scenario is very far from what I was attempting to accomplish...
  3. Sparky1157

    Automate clicking a button in a popup window

    I created a macro to automate sending out an email using Microsoft Outlook. In the email I wish to include an image which I’ve placed in Sheet2 in the range A1:F25. However, when I want to paste this image into the body of the email, I receive the following popup message: In an attempt to...
  4. Sparky1157

    Excel 2013 macro working erratically in AppSphere (VDI) platform running Server 2008

    Thank you, Skip - I will check that out! And, Andy - yes, I meant to type "paste" - my apologies for any confusion! HAPPY HOLIDAYS, ALL!
  5. Sparky1157

    Excel 2013 macro working erratically in AppSphere (VDI) platform running Server 2008

    I'm going to my inbox, then going to my drafts folder where I open a stored email, copy it's contents, open a new email window, copy the contents there, and then exit the macro. The point is to automate opening a new email with pre-stored information that I can then modify and subsequently send...
  6. Sparky1157

    Excel 2013 macro working erratically in AppSphere (VDI) platform running Server 2008

    My apologies - I thought I had made that clear in my original post as to what system I was working on. It was recently upgraded from a Gen-Y VDI system running Windows 7 to an AppSphere VDI system running Server 2008. If you're interesting in what application I'm sending the commands to, as...
  7. Sparky1157

    Excel 2013 macro working erratically in AppSphere (VDI) platform running Server 2008

    Thanks, Skip! Constructive criticism is always welcome. I must admit that I'm not an expert at VBA programming, so my attempt was apparently clumsy at best. However, the purpose of my posting was to obtain a solution to the problem - could you please point me in the right direction on what...
  8. Sparky1157

    Excel 2013 macro working erratically in AppSphere (VDI) platform running Server 2008

    I was running an Excel 2010 macro on a Gen-Y VDI system running Windows 7 and everything worked just fine. Now, however, we upgraded to Excel 2013 with an AppSphere VDI system running Server 2008. The macro now behaves very erratic - sometimes it does nothing, and sometimes it will get part...
  9. Sparky1157

    Resize an Application Window

    Yes, thanks, Skip! As usual, more than one way to skin a cat, so to speak!
  10. Sparky1157

    Resize an Application Window

    Absolutely, Skip! Also, if you would like to set up an icon on the desktop in order to run the macro and disable the splash screen, then exit Excel automatically, this can be accomplished as well. You just need to know where the EXCEL.EXE file is located. The /e flag prevents the splash...
  11. Sparky1157

    Resize an Application Window

    Thanks to Skip's advice I went to the VB Script forum and received some additional support from them. However, it appears that the Attachmate VB Editor contains an older version of VB, or at the very least a subset of what's available in the Excel VB Editor. I needed to use the Excel VB Editor...
  12. Sparky1157

    Accessing Another Window (Windows Folder) with a Macro

    Within the Attachmate Macro Editor I was able to compile and run the following macro, which opens a Windows Explorer window and turns off the navigation pane. -------------------------------------------------- ' Internal Functions ' ' Set up sleep subroutine derived from the...
  13. Sparky1157

    Trying to Resize Application Window

    I've managed to get this combined version of the macro working: -------------------------------------------------------------- Sub Explorer() Dim FolderPath As String FolderPath = "G:\Desktop Folder" Dim WshShell As Object Set WshShell = CreateObject("WScript.Shell")...
  14. Sparky1157

    Trying to Resize Application Window

    OK ... don't give up on me yet, strongm! I found another version of the macro editor which supports a wider array of VB instructions - your example does NOT produce a compile error, and runs just fine! However, what I had wanted to do in my original macro, which also runs just fine under this...
  15. Sparky1157

    Trying to Resize Application Window

    I also tried incorporating it into my own macro, without success. It doesn't give me a compile error, but gives me a run-time error. Sub Main() '-------------------------------------------------------------------------------- Dim FolderPath As String FolderPath = "G:\Desktop Folder"...
  16. Sparky1157

    Trying to Resize Application Window

    Thanks for your feedback! I did try the operation as both strongm and guitarzan indicated: Sub Main() Dim myShell Dim myExplorerWindow Set myShell = CreateObject("Shell.Application") For Each myExplorerWindow In myShell.Windows On Error Resume Next If...
  17. Sparky1157

    Trying to Resize Application Window

    okay - well, thank you for your attention to this matter!
  18. Sparky1157

    Trying to Resize Application Window

    I'm using Attachmate Extra! Macro Editor, and normally do only Attachmate-type macros. However, in this situation I'm opening a Windows Explorer window in order to display the macro files for selection. I would like to resize the window, and at first posted my question on the Attachmate forum...
  19. Sparky1157

    Trying to Resize Application Window

    I'm trying to resize a Windows Explorer window.
  20. Sparky1157

    Trying to Resize Application Window

    I've tried 2 methods of resizing an application window, but each one gives me a compile error. Method #1 WshShell.moveTo 1030,110 ' Moves the window position ' horizontally, vertically and WshShell.resizeTo 225,175 ' changes the width and...

Part and Inventory Search

Back
Top