I have made some code that makes powerpoint and excel work together. And I want excel to be invisible and not show up when the code runs. So I've set it like this: Set EXL = New Excel.Application EXL.Visible = False But my code creates a new xmlMap in excel and the whole procedure halts when a dialog box shows up. This is the dialog b...
Hi, I've seen plenty of examples around the internet on how to add a button or group etc. to the Ribbon, but no reference to an XML Schema document that will explain exactly what all my options are for writing the XML for my own custom ribbon tabs and groups. Does anyone have a link for this? Cheers, Dave --Trindaz on Fedang #office-20...
Hi, Can't seem to find any simple VBA tutorials for adding a custom group to the Home tab in the Outlook 2010 ribbon. Shouldn't it be a couple of simple steps involving something like traversing objects in the Home tab and programmatically add the group with controls etc, or redefine the XML that describes the Home tab. Is there any s...
I have a request from a User Group to implement the following: Introduce a set of templates that have some Hidden Text on the page as instructions Display the Hidden Text the first time a document is created using the templates Introduce a custom button to toggle the Hidden Text display 1) The templates are now created. Manual t...
I have installed PythonWin installed.. I can read and write to Excel from Python, not a problem. Not the usage I need. All examples I have found are more complex than I need. Since, I'm moving away from Excel, I need a half steps for testing. Whats the simplest way to fire off python scripts from Excel. I dont need gui. Usage: On ope...
Hi, I have been trying to copy text from excel in to word, and retain the bold formatting on the text, but not the cell. When I try manually copy and paste over a cell the text is copied but not the cell itself. When I try repeat this using vb (as shown below) the cell is also copied over With wrdDoc .Content.Font.Name = "Times Ne...
In VB6/VBA, you can declare module-level variables outside of a specific Sub or Function method. I've used Private and Public before inside modules and understand them like so: Public - visible to all code inside the module and all code outside the module, essentially making it global. Private - visible only to code inside the module....
What is simplest/best way to achieve functionality in vba in Excel: - button "add person" which will add 4 rows in which user specifies name..., also " - button "delete person" appearing in new added entry - to delete it What is a workflow for doing that? Should I record that first? Should I write VBA only? How to keep the part that c...
I'm using VBA excel 2003,SQL 2005 to make a sql query call and inside my sql statement I'm using '+' operator to concatenate two strings. dim query as string query = "Select distinct ', '+emailaddress1 " query = query & "from contact " would this work inside vba? My query returns too many records in excel but not in SQL? Please just...
hi, I want to make an excel file read using a VBA code in a simulation software. Please let me know how can I do this? ...
My Excel application sends email updates using Lotus Notes and I am having trouble finding a quick and reliable way of ensuring that that the user is logged in to Notes. If the user is not logged into Notes before they perform an operation that calls Notes then the code stalls on Set NotesDocument = NotesMailFile.CreateDocument as Excel...
Is there anyway to disable spell checking on a per document basis via VBA for MS Word? ...
I have used .NET 3.5 with C# to create functions to gather data from a product's web service. Now we have a need to be able to get at that data in a Microsoft Access 2007 application. I am not particularly familiar with VSTO et al, and I don't want to have to fuss with anything on the MS Access side--I'll leave that to our VBA expert. B...
I created a dropdown by dragging the combo box onto my sheet from the UserForm toolbar. I assigned some values to it from some cells in the book. Now I want some vba code to access the selected dropdown item's value in form of a string. My dropdown contains only text. Also how do I find the name of this newly created dropdown...it's n...
Here is a question for my Father. He has been using VBA in Excel for more than two decades going from Excel 5 to this day where he is using Excel 2002. As he has used VBA in Excel for so long, making extensive use of the ability to record macros, he has continued to invest in Excel as it has been rather stable (in terms of its VBA func...
Hi ! I'm currently writing a code in VBA to retrieve prices for some financial models. The problem I have is in the excel spreadsheet where I have special Ascii characters like ⅞ ¼ etc... I would need using VBA to transform this in 7/8 1/4 etc... How could I do that ? Thanks for your help ...
I'm currently working on a VBA macro importing product-requirements into Microsoft Project. I use the following code for adding/updating a task: Function AddTask(strText As String, lngDuration As Long, taskParent As Task) Dim oldTask As Task Set oldTask = taskParent.OutlineChildren(strText) If oldTask Is Nothing Then ...
In Access 2003, there are ways of running code when a form or database is opened, but what about when the database is closed? My motivation is the unavoidable use of a somewhat buggy third-party COM library. Releasing the COM reference (by setting the variable to Nothing) causes it (correctly) to disconnect from its server. The trouble ...
What is the right way to leave an MS Project file opened with GetObject() open and visible to the user after the end of a macro in a different app? The information I found online suggests that setting the Application.UserControl property to True before the objects go out of scope should allow the user to continue using the opened file. ...
Are there ways in Access VBA (2003) to cast a COM reference to an integer, and to call AddRef/Release? (which give the error "Function or interface marked as restricted, or the function uses an Automation type not supported in Visual Basic") I'm using a third-party COM object which doesn't handle being instantiated twice in a single pro...