Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

CreateObject("Visio.Application","MyServer") failure - permission denied

Posted on 2001-07-25
2
1,056 Views
Last Modified: 2008-03-03
I'm running a visual basic program that calls createobject("Visio.Application").  Its purpose is to start a visio application so I can create a dynamic drawing.  I need to create the application (visio) on the server named in the 2nd parameter of createobject.  As I read it, you can basically run the visio application on the server itself.  This would prevent my client application from needing visio itself and would allow me to create the drawing on the server.  Any suggestions?
0
Comment
Question by:AntCorp
2 Comments
 
LVL 4

Accepted Solution

by:
VincentLawlor earned 100 total points
ID: 6320141
That's what the documentation says.

You can create an object on a remote networked computer by passing the name of the computer to the servername argument of CreateObject. That name is the same as the Machine Name portion of a share name: for a share named "\\\\MyServer\\Public," servername is "MyServer."

The following code returns the version number of an instance of Excel running on a remote computer named MyServer:

Dim xlApp As Object
Set xlApp = CreateObject("Excel.Application", "MyServer")
Debug.Print xlApp.Version

If the remote server doesn?t exist or is unavailable, a run-time error occurs.

You can check this out fairly easily do your create object on a machine without Visio. See does it stat an instance of Visio on that machine.

The bummer is you won't get a user interface for this as it's running on the other machine.

Vin.
0
 

Author Comment

by:AntCorp
ID: 7159412
Sorry, haven't logged on in a long time.

AntCorp
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
String manipulation in Visual Basic 7 73
message box in access 4 51
Add a task in Outlook from access 11 42
Excel Automation VBA 19 90
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question