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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.