-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
getobject
-
Reference and remotely manipulate UserForms loaded in seperate workbooks or in seperate Excel Instances via File Monikers.
Hi, this an continuation of some code I posted in the past see Here ... This new addition uses file monikers to register objects in the Running Object Table and hence makes it possible to access UserForms from remote processes via the standard GetObject vba function. The advantage of using...- Jaafar Tribak
- Thread
- createfilemoniker dispcallfunc excel instance getobject getrunningobjecttable gwlp_userdata iunknown_getwindow pathremoveextension ptr_len remote rot rotflags_registrationkeepsalive userform
- Replies: 2
- Forum: Excel Questions
-
B
How to acces ADO disconnected recordset object from another workbook
Is it possible to have a recordset object created in one workbook but access this recordset object from another workbook's vba code? I was thinking maybe getobject could be used to capture it from another workbook but I cannot find any resources on this.- bradyboyy88
- Thread
- getobject object recordset thinking workbook
- Replies: 3
- Forum: Excel Questions
-
VBA: GetObject / Copy and Past is bringing only 255 characters
Hi, Everyone! I'm simply tring to get a cell content from an unsaved workbook (Book1) through GetObject function, plus Copy and Paste. But as the content of the cell is a very long string, I only get a piece of it (until characters 255). The code I'm using is: Dim oApp As Application Dim oWb...- SantoOnofre
- Thread
- copy copy & past getobject paste vba & excel
- Replies: 1
- Forum: Excel Questions
-
T
Retrieve data from unsaved Excel workbook: GetObject("Book1")
The office has a case management system that will export the filtered data to Excel. By default, it will create a workbook called 'Book1' and place all data filtered to 'Sheet1". Up until recently, I have used the code below on a Windows 7 machine using Excel 2010. We are starting the upgrade...- themick
- Thread
- code excel getobject import unsaved data windows 10 64-bit
- Replies: 39
- Forum: Excel Questions
-
Why "Invalid procedure call or argument (Error 5)" ??
I execute this code (only part given here !): Dim FSted As String, FDato As String, DSted As String, DDato As String Dim xlApp As Excel.Application Set xlApp = GetObject(, "Excel.Application") AppActivate xlApp...- keldsor
- Thread
- dim excel.application getobject string xlapp
- Replies: 2
- Forum: Excel Questions
-
GetObject not getting Outlook.Application
I have a stock function I use to test to see if Outlook is running before I attempt to draft an email. I've never had problems with it before, but today I ran the program and it doesn't acknowledge that Outlook is running. If I close/reopen the file, it seems to work and if I step through, it'll...- richh
- Thread
- getobject outlook outlook 2010 outlook.application
- Replies: 13
- Forum: Excel Questions
-
Problematic Call to *GetObject* hanging the application
Hi all If you call GetObject on a workbook opened in another excel instance ( workbook opened on the same pc or on a remote one) you get a pointer to that workbook ... This works fine . However, if the second workbook happens to be in edit mode or has a modal dialogbox on display (such as the...- Jaafar Tribak
- Thread
- getobject
- Replies: 4
- Forum: Excel Questions
-
M
Difficulty putting 2 macros together using CreateObject & GetOject
I have created 2 macro's in excel that open a word .docm document and need to do 2 things: 1. do a mail merge (sub creëer contract) 2. delete bookmarks (call word macro's based on excel values) Seperately they work as should, but I have difficulty putting them together. I tried calling one...- MHO044
- Thread
- calling word vba createobject getobject
- Replies: 0
- Forum: Excel Questions
-
Check if excel is in Edit Mode or has a Dialog window on display
Hi all, Let's assume we want to get a pointer to a workbook opened in a second insatnce of excel and edit a cell .. we would normally use something like this : Sub Test() Dim wb As Workbook Set wb = GetObject("C:\MyBook.xls") wb.Worksheets(1).Range("a1").Value = 10 End Sub The...- Jaafar Tribak
- Thread
- edit mode getobject hanging responding
- Replies: 2
- Forum: Excel Questions
-
Sinking events of a remote workbook
Hi all, I am not experienced with network programming so I am asking here if the following prank would work (this is just an illustrative example) Ok- Let's say a remote workbook (located in a network shared Drive/Folder) is currently opened by some user on the network and I wanted to play a...- Jaafar Tribak
- Thread
- getobject remote sink withevents
- Replies: 4
- Forum: Excel Questions
-
R
VBA - Find Shapes (chart) in an powerpoint slide
Hello, I am trying to build a code that pulls data from an access database and fills charts in a powerpoint file with a template. This template has two charts initially built in 97-2003 format but i'm trying to update them to office 2013 charts. I am running a macro that finds all the shapes...- RuiFlora
- Thread
- access chart excel 2013 getobject shape
- Replies: 1
- Forum: Excel Questions
-
M
VBA LDAP Lookup in Userform
Hi guys! I am a student and employee at my university and I am also fairly new to VBA. This is my first post on this forum and I would like to thank everyone in advance for the help. I currently work for my IT department and we are launching a new phone system. I am working on an script that...- mjtomey
- Thread
- directory getobject ldap search vba
- Replies: 1
- Forum: Excel Questions
-
H
Need help in GetObject/CreateObject excelapp from Attachmate
Hi, I have a macro from attachmate that transfers data to an excel file. My problem is that i can't get these lines to work correctly (code that I use from Attachmate Extra!). Set obj = Getobject("H:\ultimate.xls") if obj is nothing then set obj = CreateObject("Excel.Application")...- hellebore08
- Thread
- attachmate createobject excel.application extra.system getobject
- Replies: 15
- Forum: Excel Questions
-
D
GetObject Trouble
I am interested in pulling values from Excel into Word to automate reports. I have in the past used the GetObject function successfully and really liked the functionality. Recently our company upgraded to Office 2007 and when this happened I have not been able to get the same macros to work...- dpepples
- Thread
- excel object excel values in word getobject word macro
- Replies: 3
- Forum: General Discussion & Other Applications
This Week's Hot Topics
-
separating multiple Proper names (uppercase letters) from a list
- Started by Keebler
- Replies: 35
I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into... -
'for' Loop
- Started by RAJESH1960
- Replies: 29
Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to... -
Open specific pdf in folder with vba
- Started by ipbr21054
- Replies: 38
Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it... -
What is wrong with this For Loop code?
- Started by thardin
- Replies: 20
I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a... -
Data to match
- Started by dinkss
- Replies: 20
Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I... -
Shifting Columns
- Started by Andresleo47
- Replies: 19
Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...
