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 bkrike 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: *

  • Users: Sparky1157
  • Content: Threads
  • Order by date
  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

    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...
  3. 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...
  4. 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...
  5. Sparky1157

    Resize an Application Window

    I've tried a couple of methods for resizing an application window, but neither of these options work - they result in a compile error. Method #1 --------- WshShell.moveTo 1030,110 ' Moves the window position ' horizontally, vertically and...
  6. Sparky1157

    Running Calculator Demo with Macro

    I copied the following code from a Microsoft website which demonstrates how the Calculator can be invoked from a macro: Dim ReturnValue, I ReturnValue = Shell("CALC.EXE", 1) ' Run Calculator. AppActivate ReturnValue ' Activate the Calculator. For I = 1 To 100 ' Set up counting...
  7. Sparky1157

    Accessing Another Window (Windows Folder) with a Macro

    I've been using the Macro Editor to create some automation in our Reflection sessions, but now I would also like to create a macro that will turn off the Navigation Pane for a particular folder that's opened on my desktop (the folder containing links to my macros). Here's the code I have so...
  8. Sparky1157

    removing crlf from clipboard or variable

    I've copied the contents of the clipboard into a variable, and then send that information to the screen in Reflection. However, if there's any crlf characters the screen information displays incorrectly. Since there is no REPLACE command, I've written my own function with the intent of removing...

Part and Inventory Search

Back
Top