-
- Dynamically add controls with events at runtime
by LSF
- 6 Replies
- Last post
by Anonymous3461
- Hello,
I want to add new buttons to an existing userform at runtime and link event handler to them so that the buttons do something.
I've tried several ways that I've found online and managed to create the button and to programmatically add the code for the click event but when i click the button nothing happens. The button and click event sub code is created fine.
I have adde
-
- run an exe file in excel using VB
by mambo5
- 5 Replies
- Last post
by mambo5
- Hi,
I want to run an exe file in excel using VB, any simple coding for that
Thanks.
-
- autofill vba code
by nsheff
- 1 Replies
- Last post
by Bruno Yu - MSFT
- I need to copy a function down a column to length of the adjoining column to the left. I recorded a macro which did what I wanted. Unfortunately, the column changes sizes depending on my data. Unfortunately, every time I run the macro it uses the length that was recorded the first time. How can I set up a dim or something to have the autofill work with the variable length lists
Thank you v
-
- Need to link two word documents together.
by Lunar Beam
- 3 Replies
- Last post
by Shasur
- Hi,
I have two documents which have roughly similar tables that need to be filled in Microsoft Word.
I would like to have a macro that updates a cell in a 5-by-5 table in B.doc when a cell in a 5-by-5 table in A.doc is updated.
1) A.doc is updated.
2) B.doc is opened, then updated.
3) Both documents save themselves.
It would be best if steps 1-3 are completed with
-
- VBA - Accessing files in a folder
by raja.rkannan
- 3 Replies
- Last post
by raja.rkannan
- Evening Ppl,
I am working on a Excel VBA assignment which involves accessing a directory which has around 2500 files and displaying the filename, date created & date modified based on a search criteria.
To be more clear, i have well formed file names in that folder and the last 4 characters in the file name are DDMM (date and month)
TEST0806.csv
TEST0803.csv
TEST
-
- iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :(
by sapphireoceans
- 14 Replies
- Last post
by Jillytodd
- Hi, I am absolutely clueless as to why this keeps happening, but it is driving me insane!! The exact error message reads: 'The exception unknown software exception (0x0eedfade) occurred in the application at location 0x7c81eb33.' Could anyone shed some light on maybe what the cause is and/or how I can fix it Thank you in advance to anyone who reads and/or offers any information. Laura x
-
- Parse AIM Buddy List Export file and Import to LCS 2005 Client
by Bryan Tidd
- 1 Replies
- Last post
by sgood
- I'm working on a migration project from the wide use of AOL AIM to Office Communicator 2005 and Live Communication Server 2005. I can create a text file export like the following:
Config {
version 1
}
User {
screenName thereScreenName
}
Buddy {
list {
"GroupA" {
"buddy1"
"buddy2"
}
"GroupB" {
"bu
-
- VBA Powerpoint - identifying textboxes by type
by Peter Caisse
- 3 Replies
- Last post
by Peter Caisse
- Hi everyone, I'm writing an add-in for Powerpoint 2003. I'd like to know how I can identify textboxes by type if such a thing exists. For example, when reading a TextFrame, how do I know if I'm reading the title textbox, the subtitle, or a the big textbox with bulleted points depending on the slide model I've found the Shapes.Title property, but that only gives me the title if it exists, not the v
-
- Issue with Selection.TypeText and Chinese Characters.
by McLovin
- 1 Replies
- Last post
by McLovin
- Hello Everyone,
I'm having trouble getting chinese characters to work with TypeText. When I use English, everything works great.
For example, the following statement shows up as " " in my word document.
exec sp_OAMethod @objword, 'Selection.TypeText("ÃÀ‡ø¿‚½y")'
While I'm using T-SQL and not VBA, I figured that the people here would probably know th
-
- Automatically send attachment in email with a submit command button in word
by Desperately need help
- 3 Replies
- Last post
by ADG
- I have a huge problem if anyone out there is able to help; I have tried to create a submit command button to email off a document as soon as the user hits submit; however i am new to this and my macro does not seem to be working. Does anyone know where i have gone wrong and if possible can you please help rectify the problem. Thank you Sub CommandButton1_Click() Dim Email As Object Dim Attachment
-
- Wording of Response web pages is different to specified text
by Marcus Ogden
- 1 Replies
- Last post
by Jason Hardester - MSFT
- Hello,
I'm working on a prototype application using Windows Error Reporting, and right now I'm trialling Responses. I'm trying to understand why the wording on the web page I see (after submitting an error report for an event that I've registered a Response for) is completely different from the wording I've specified on the Winqual website's Response Management page.
Two examples:
-
- Why is it so ?
by DHON
- 3 Replies
- Last post
by Jason Hardester - MSFT
- Hi,
I uploaded a product map file recently, and one of the exe was having version 7.31.0.0
But, when I go to the Product Rollup page, I can see an event for that exe having
version 7.20.0.0 .
As I understand, mapping process considers the version of that file also.
Can anybody explain why 7.20.0.0 is listed instead of 7.31.0.0. In other
words how come version 7.20.0.0 event
-
- Is Microsoft the company broken?
by Rob Ainscough
- 0 Replies
- Last post
by Rob Ainscough
- I've been developing on Microsoft platforms for many many many years (early 80's). I've been forced to start developing on OSX and other flavors of *nix primarily due to:
1. Increasing demand by my clients to produce higher level service agreement
2. VS 2005 even with SP1 can't deliver the goods on large scale 24/7 mission critical apps
3. The need to still use Java in ASP.NET based web s
-
- Debugging
by une
- 2 Replies
- Last post
by une
- I can watch the execution flow of code in VBA under MS Word 2002 using the F8 key. How do I take a step backwards I want to watch a small section of execution flow again without starting from the beginning.
-
- Format text in MsgBox
by une
- 5 Replies
- Last post
by une
- How do I format text that is presented in message boxes. I have looked for what I know as escape characters, but like a lot of things maybe MS calls these something else. I want to for example add newlines and tabs. Changing font would be handy also, as would the ability to add images. If you can help on the fonts and images fine, but at the moment I really need to be able to add newlines and tabs
-
- Inconsistent results with c++ dll
by ForRes
- 0 Replies
- Last post
by ForRes
- I have been given a C++.net dll that I must call from within excel vba. The call is made to a function of type integer (i.e., long in vba). VBA calls the function ~100 times every time the code is run. I start excel and run the code and the function returns the correct answer (I have a test data set that yields a known result). I can rerun the code as many times as I want in quick succession and t
-
- MS Office document and image writer print driver
by GTH
- 14 Replies
- Last post
by Mary3480
- Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to
-
- Application.File Search.
by trimuke
- 1 Replies
- Last post
by Jon Peltier
- Hi,
If any one has a work around for Application.File Search in Excel 2007 please let me know.
This is currently not working in Office 2007.
Regards,
Digambar.
-
- Vertical text centering in label
by une
- 1 Replies
- Last post
by Andy Pope
- How do I make sure that text in a label's caption is centred vertically within the label Horizontal centring is easy to change, but I don't see a vertical setting in the properties window.
-
- Macro that deletes itself after running
by GB Allan
- 3 Replies
- Last post
by GB Allan
- Hi,
I created a macro that runs a routine on other spreadsheets and copies them into the workbook, one at a time (the same workbook that contains the macro). I have a small on-open routine in the macro spreadsheet:
Private Sub Workbook_Open() Sheets("DATA").Select Range("A1").Select Sheets("INSTRUCTIONS").Select Range("A1").Select End S
-
- works fine manually, but not when pasted into XLSTART directory
by pacificwaters
- 2 Replies
- Last post
by pacificwaters
- I have a spreadsheet which contains C:\ path directories in some cells' "formula" (not text content) that I want to remove.
So here's the code within a .xla file that I use to do so.
Code Block
Sub Auto_Open() Cells.Select Cells.Replace What:="'C*!", Replacement:="", LookAt:=xlPart, SearchOrder _ :=xlByColumns, MatchCase:=False,
-
- iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :(
by sapphireoceans
- 14 Replies
- Last post
by Jillytodd
- Hi, I am absolutely clueless as to why this keeps happening, but it is driving me insane!! The exact error message reads: 'The exception unknown software exception (0x0eedfade) occurred in the application at location 0x7c81eb33.' Could anyone shed some light on maybe what the cause is and/or how I can fix it Thank you in advance to anyone who reads and/or offers any information. Laura x
-
- Advanced Find - CRoss Table Searches Possible?
by Matt Mc
- 4 Replies
- Last post
by MS ISV Buddy Team
- In CRM 1.2 I accepted that searching across tables was not possible, an example being:
If I wanted to search under 'Contacts' for people named 'John', and other search criteria looking under 'Activities' within a date range. This is searching under 2 tables - Contacts & Activities.
This was not possible in 1.2, and from first glance appears not possible in 3.0 - does anyone know anything
-
- Determing close method with vba
by JS
- 5 Replies
- Last post
by Andy Pope
- Hi,
How can I in vba code trap which closing method the usr has used. E.g. File -> Close, File -> Exit, workbook X or application X
Grateful for help.
Jonas
-
- Easy msgbox Query
by jaxgev
- 8 Replies
- Last post
by Andy Pope
- Here's what I'm looking to do in Excel: User inputs data in cell C7 A function in cell C11 calculates A function in cell C12 calculates I want to ensure that both C11 and C12 are positive based on C7 input If they are not, I want a msgbox to appear saying, "Enter a Larger Value." I used the Change event over the Calculate event because it's my understanding that the Calculate event wi