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
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.
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
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.
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).
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?