-
- Run Time Error 9 when Calling a Userform
by Joe Dawson
- 6 Replies
- Last post
by Joe Dawson
- Hi folks, I am getting a run time error # 9 when I run a macro that calls a Userform or when I try to run code in a Userform module. The code performs beautifully on my computer, but it did not work on a coworker's computer. It ended up working on 3 out of the 5 computers I have tried it on. I have tried changing security settings to low, and a bunch of other stuff, but I cannot get the code to r
-
- Excel CheckBox - Enabled "False" but I don't want it grayed out
by suznal
- 6 Replies
- Last post
by Andy Pope
- Is there a way with VBA to have a CheckBox with the enabled property set to false but defeat the "grayed out" quality.
I have checkboxes that take their value from other objects and I do not want the users to be able to select them, but I don't want them to look grayed out either.
-
- iexplore.exe - Application Error
by bennett1016
- 14 Replies
- Last post
by rreynard
- I get the following error message when I close my internet explorer.
The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program.
Any ideas what is causing this
-
- 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
-
- How to make a macro to copy some parts of a table to an email that it will create?
by kebever
- 8 Replies
- Last post
by kebever
- Hi,
I'm quite new to VBA but had some experience coding for Excel. I now require a macro to help me solve a problem in Word and email. I hope someone can help me here. Thanks in advance!
The issue is that I need to copy some parts of a table in Word to an email that it will create too.
For eg.
There are two columns to the table, with the 1st row, column 1 being "Na
-
- 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
-
- Excel VBA
by Anony24
- 2 Replies
- Last post
by Anony24
- Hi everbody!
I am using Excel and I wrote a code using VBA. I have subroutine which open and read text file. I call this subroutine in the master program. The object of the program is to open read a text file(numeric) and make average of the data , make a table and fill the table with the data. However, I want to modify the program so that it can open 5 text file at the same time and
-
- .mdmp files not being created
by David Ching
- 14 Replies
- Last post
by JPSA
- Hello, Under what conditions is the .mdmp file created or not I have written an app that (deliberately) dereferences a NULL pointer, but the generated error report does not have the "Files that help describe the problem" section when listing the report from the Control Panel "Problem Reports and Solutions". Viewing other reports that had been put there, some of them have the f
-
- How do I accomplish this in VBA using Office 97 and later?
by Bioengineer
- 0 Replies
- Last post
by Bioengineer
- I am trying to come up with a system that would improve efficiency in creating Request for Quote and Purchase Orders. As an example, here is what I am trying to do with the Request for Quote.
1.) A new document from a template called "Request for Quote" is created.
2.) The system asks for an Excel file to import that has bid item information in specific columns and from a set r
-
- ASP .NET 1.1 fails at install, but not .NET Framework 1.1
by PopeR
- 1 Replies
- Last post
by PopeR
- Hi there,
My Scorecard Manager 2005 installation finds that I do not have ASP .NET 1.1 installed, but it finds .NET Framework 1.1 installed. I could not find a download for ASP .NET 1.1 outside of the .NET Framework 1.1. Can anyone explain in a few words what is the difference between the framework and the asp .net
To note that when I try to install the .NET Framework 1.1, which I cannot see
-
- How to allow cookies for Windows Live ID
by Ralph Burns
- 6 Replies
- Last post
by Coqui88
-
- Projects, objects & modules
by une
- 14 Replies
- Last post
by une
- I
started learning VBA in MS Word yesterday. I have some programming
experience in C++ and Java. I am trying to understand how the
environment is structured and what Projects, Objects and Modules
represent.
For example I recorded a few macros using the macro recorder and
then opened the VB Editor to see what was created. I notice that under
"Project" are 3
folders. One is named
-
- A macro to count the number of macros in a woorkbook
by slimshamus
- 4 Replies
- Last post
by tracycan
- Hello all,
I need to loop through a bunch of excel workbooks, open them, and determine if there are any macros in the workbooks, and if there are, how many.
I know how to loop through the workbooks and open them. But how can I display the names of the macros that are defined in the workbook This must be possible.
Thanks!
-
- ComboBox listing on Startup
by Philsophaie
- 8 Replies
- Last post
by Philsophaie
- The ComboBox1 doesn't initialize the list automatically. It only puts up a blank ComboBox . Here is the code I am using:
Private Sub Form1_Load() ComboBox1.Items.Add ("Open App1") ComboBox1.Items.Add ("Open App2") ComboBox1.Items.Add ("Open App3") ComboBox1.Items.Add ("Open App4") End Sub
-
- PASSING MS OUTLOOK DATA TO EXCEL
by Andrus1
- 2 Replies
- Last post
by Andrus1
- Is it possible to pass Outlook information such as dates and durations of meeting to an Excel spreadsheet I would need to do this via a macro. I need this to create a time card that tracks how much time is being spent in meetings. Thanks!
-
- MDI on old Office but not on new Office 2007?
by Alexander in Denver
- 1 Replies
- Last post
by MS ISV Buddy Team
- I had regularly emailed myself in the past from my older version office {2003} {work laptop with no printer attached} to my newer office XP on my personal system to print but now that I have upgraded to Office 2007 the MDI is not recognized. How can I install the MDI drivers so I can print again
-
- referenced memory error
by rham
- 0 Replies
- Last post
by rham
- hello people. can someone help me. My computer displays an error saying instruction at "0x269e7875" refernced memory at "0x269e7875". The memory could not be "read". Click ok to terminate the program. And I cannot switch from one user to another. I can log-off from windows and switch user. It needs to be restarted every time I want to switch from one user to another.
-
- Visual Basic Code Corrupted?
by DenoBest
- 2 Replies
- Last post
by DenoBest
- Hi,
I have been having several problems on a complicated excel spreadheet that I have been developing, that have led me to believe that the file i am working on has been corrupted.
The problems started when I switched PC's that I used for developing (i.e. was given a slower PC to work on).
Since then, I have been having all sorts of problems with my macros. Now, even when I op
-
- Removing "Trial Version" from Web Components on SharePoint web sites
by Christian.Lorenz
- 0 Replies
- Last post
by Christian.Lorenz
- Hello,
I would like to remove the "Trial Version" as stated above. I used CSS but then other part disappear as well so this is not an option.
Then I tried JavaScript but wasn't working either. Question: is it somehow possible to do it with JavaScript (I have only limited scripting capabilities).
Or can I directly access the template that creates the different sharepoint web
-
- Multithreading with VBA6 and Access
by Nico van de Kmap
- 0 Replies
- Last post
by Nico van de Kmap
- Hello,
I'm not so familiar with VBA/Access. I have to maintain an existing application. Now I need that a user can use the application and in the background a function must at certain times (these times are in a table param) lookup and export a XML file from a query.
IS IT POSSIBLE TO CREATE MULTITHREADING WITH VBA AND ACCESS AND IF YES HOW
I read at some forums it should be possible but
-
- Validation with List drop down?
by Scott Boyd
- 8 Replies
- Last post
by Handyman_994
- Hi
I want to add some simple validation to my Excel sheet but can not for the life of me remember how to do it! Basically i have a drop down list as in the image below and want so that when 'No' is selected, the user is forced to enter the reason in the next cell
http://i102.photobucket.com/albums/m82/sc0ttb_2006/excel_list.jpg
I can remember doing this before and used some VBA code but c
-
- How can I show the formula result in my cells?
by lyp_sj
- 2 Replies
- Last post
by lyp_sj
- I assigned a formula to Range(D2 10), but I cann't see the formula result in the spreadsheet, what I can do is only show the result by using msgbox. So how can I show my formula result in the spreadsheet Thanks so much!
Private Sub CommandButton1_Click() Worksheets("MMS_RSP_Tonnes").Range("D2 10").FormulaR1C1 = "=MMS_RSP_GSV!R[0]C[0]*1000/GSVperTonne!R[0]C[0]&qu
-
- Windows media files have changes to Nero
by shihad
- 10 Replies
- Last post
by ssmack3000
- Hi just wondering how I change my music files back to windows media player, they changed to nero flies last week after burning a CD. Hate the nero player, but love windows media player. Hope someone can help me Thanks Shihad P.S check out Shihad single ALIVE
-
- Icons In ListBox
by M_Taha
- 3 Replies
- Last post
by SiraB
- Hi dears
I want to add icon to the items of VB.NET 2005 ListBox ,
Could i do ...
-
- Finding Quartiles From 2 Dimensional Array Using Excel's Quartile Function
by GAtkins
- 6 Replies
- Last post
by GAtkins
- Greetings Everyone:
I am trying to use Excel's Quartile Function in VBE to find the quartiles in the Columns of a 2 dimensional array.
I am having trouble getting my mind around this, I think due to the fact that I do not know how to define each column as a range so that it can be used in the Excel Quartile Function in the form =Quartile(Range, 1), where 1 is the first quartile in th