Home > Why Does > Why Does GetObject Open Up A File As Read-only?

Why Does GetObject Open Up A File As Read-only?

In Windows Explorer (also can do this in the “My Documents” window), go into Tools, Folder Options, File Types, scroll down to DWG. Join the community Back I agree Test your smarts. 88% of IT pros got this right. The following example illustrates this. You can double click a DWG file. get redirected here

Thread Status: Not open for further replies. Then ' show the actual window containing the file using the Windows ' collection of the MyXL object reference. It now works in Office 2013 as well!! To start viewing messages, select the forum that you want to visit from the selection below. https://forums.techguy.org/threads/why-does-getobject-open-up-a-file-as-read-only.1149995/

Thanks Unusual, Jun 26, 2015 #14 Sponsor This thread has been Locked and is not open to further replies. There is a ReadOnly parameter. –simpLE MAn Mar 5 '14 at 17:24 So.. Yes No Additional feedback? 1500 characters remaining Submit Skip this Thank you! About Us PC Review is a computing review website with helpful tech support forums staffed by PC experts.

GetObject Function Office 2013 and later Other Versions Office 2010 Contribute to this content Use GitHub to suggest and submit changes. How to create this pattern? Hello and welcome to PC Review. Is this a bug in Office 2013?

The type or class of object to create. For Windows 7 Using Notepad, create a file containing the following (same as was for Windows XP) On Error Resume Next
dim cmd_arg
set cmd_arg=wscript.Arguments
Dim acadApp
You still have access to them programmatically though. –simpLE MAn Mar 8 '14 at 2:44 | show 2 more comments 2 Answers 2 active oldest votes up vote 2 down vote http://www.vbforums.com/showthread.php?799073-GetObject-opening-a-file-as-Read-Only!! If you want to be a guest author, please read our quality guidelines here.

Share on Pinterest About Huong CharlesHuong Charles is working in the oil & gas industry in the

Do you like it better than the old model? It now works in Office 2013 as well!! A string representing the class of the object. If you choose to put shortcut in that folder, you can rename the shortcut and change the icon as necessary.

You need to run notepad (or other plain text editor). http://windowssecrets.com/forums/showthread.php/158882-Opening-Word-template-appears-as-Read-Only Is crime an issue in the US countryside, especially for a cyclist? One full version and another ACAD LT. For information on how to create this string, see the documentation for the application that created the object.For example, in a drawing application you might have multiple layers to a drawing

By creating an account, you're agreeing to our Terms of Use, Privacy Policy and to receive emails from Spiceworks. I would like to be able to open and pull data from documents that are already open by other users. To do so, open the Add Reference dialog box from the Project menu in Visual Studio and select the Excel type library on the COM tab. The code suggested by Keebellah above uses early binding and as he correctly says, the references have to be set correctly for this to work.

SendMessage hWnd, WM_USER + 18, 0, 0 End If End Sub Show: Inherited Protected Print Export (0) Print Export (0) Share IN THIS ARTICLE Is this page helpful? But some of the spreadsheets have read-only passwords on them. If an object has registered itself as an ActiveX single-instance object, only one instance of the object is created, no matter how many times CreateObject is called. useful reference You may have to register before you can post: click the register link above to proceed.

Copy layerObject = GetObject("C:\CAD\schema.cad!Layer3") Specifying a ClassIf you do not specify the object's Class, Automation determines the application to start and the object to activate, based on the file name you Back I agree Home Store Write for CADnotes Advertise Email Newsletter About Contributors Feedback Contact Privacy policy Cookie Policy CADnotesCAD Tutorials and Best Practices for professionals and students Featured AutoCAD Articles Any thoughts?

Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next dim all variables as required

By the way I tested it on 3 independent computers all running Office 2013 and all 3 had the same issue. Reply Subscribe Best Answer Jalapeno OP mphill Jul 2, 2015 at 5:01 UTC This is from Office 2007 VBA but the code should still work, it ran in a test of MyXL.Application.Visible = True MyXL.Parent.Windows(1).Visible = True Do manipulations of your file here. ' ... ' If this copy of Microsoft Excel was not running when you ' started, close it using Then I removed the double quotes from the script file, and it worked just fine!

Were women cursed with menstruation? The excel file itself is definitely not Read-only and only the code causes this to happen. Reply With Quote Quick Navigation Office Development Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Visual Basic Visual Basic .NET VB.net CodeBank Visual Basic 6 No, create an account now.

Thanks! Visual Basic Reference Functions D-G Functions D-G Functions GetObject Function GetObject Function GetObject Function DateAdd Function DateDiff Function DatePart Function DateSerial Function DateValue Function Day Function DDB Function DeleteSetting Function Dir The call to GetObject returns a reference to the worksheet represented by the specified file, test.xls. The class argument uses the syntax appname.objecttype and has these parts: Part Description appname Required; Variant (String).

If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members. Log in By creating an account, you're agreeing to our Terms of Use and our Privacy Policy. I cant figure out why it is opening as Read only. Hcoms Guest Hello, I am presently using access to open an excel file by using the shell command.

Results 1 to 3 of 3 Thread: Solved: Need code to open a WORD document for read only. See our guidelines for contributing to VBA documentation. String. Not the answer you're looking for?