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...
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...
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'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...
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...
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...
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...
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...
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...
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...
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")...
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...
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"...
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...
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...
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...
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.