-
- iexplore.exe does not respond
by herman_hhh
- 1 Replies
- Last post
by Gwendelyn
- Hi: I just got a new desktop and ie7 was installed when running windows update. It didn't work well and I decided to uninstall it. ie6 was back. However, ie6 now slows the pc significantly. When I close ie6, I can still see iexplore.exe running in the task manager. Plus, when I want to turn off the computer, it says that iexplore.exe doesn't respond and I have to press "End now" 2 to 3 t
-
- Protecting formulas in cells
by chrstdvd
- 6 Replies
- Last post
by js06
- Hello,
Other than coding formulas, is there a way to protect a cell in an excel spreadsheet, no mater, if the sheet is protected or not, so that formulas can not be erased or overwritten
Thanks Chrstdvd
-
- 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
-
- Worksheet_Change event and dropdown list
by ADG
- 4 Replies
- Last post
by x_centric
- Hi all
In Excel I have a cell with validation set , (restricting input to values in a range), and a dropdown list for the user. When the user changes this cell by using the dropdown list it does not seem to trigger the worksheet change event. I want the change of cell to trigger an event to collect data relating to the selection. Any ideas why the drop does not trigger the event as expected
-
- Performing a spell check on the contents of a userform field
by rabbitoh
- 2 Replies
- Last post
by rabbitoh
- I want to run a spell check on the contents entered by a user into a field on an active Form. This can be either automatic as user types or manually activated via a button on the Form itself. Can this be done and if so, what code would allow this to take place.
-
- vlookup
by Namrata Prashar
- 14 Replies
- Last post
by Namrata Prashar
- Hello
can anyone help me with how to write the excel vlookup function in vba
the function in excel looks like this
VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE)
how can i get something similar working in a macro.
thanks
namrata
-
- Stuck on logic for Excel problem...
by Scott Boyd
- 6 Replies
- Last post
by Scott Boyd
- Hi I am stuck on the logic for the following problem. I have a list of employees and each has a manager attached. I want to write a macro that will loop through all the employees on the sheet and compile a list of the managers with all employees reporting in to them. I've attached an example as this may be hard to visualise! http://i102.photobucket.com/albums/m82/sc0ttb_2006/Sheet1.jpg
htt
-
- Combo Box Headache
by Techgrrl
- 4 Replies
- Last post
by Techgrrl
- I have a combobox control embedded directly in a word document.
I have added items as such:
cboResults1.AddItem "text", 0
Why is it that when I put in the indexes, the control doesn't work
-
- Event Procedure
by Access Keen User
- 4 Replies
- Last post
by Access Keen User
- I want to set [Event Procedure] as I have set so many Event but one of my form, shows me following message.
Code is simple
DoCmd.OpenForm"My Form Name"
Where is the fault, if some one help me.
The expression On Click you entered as the event property setting produced the following error: Procedure declaration does not match description of event or procedure ha
-
- Updating Database on Server from multiple databases on C:\ with MS Access
by sqglmrflover
- 0 Replies
- Last post
by sqglmrflover
- Here is the problem: On everyone's C:\ is an MS Access database that is linked to our MRP system JobBoss. I have created a custom program for producing inventory labels. I need to capture each part that is labeled in a central database so I can monitor progress, check for problems, etc. I am unable to update the database on the server. I do not get any error messages. Simply the table on the serve
-
- DOS Command Question
by okieflier
- 3 Replies
- Last post
by Derek Smyth
- Im sure this is easier than what im trying to do, but any help would be great.
The following code is from my .bat file, the problem is I have numerous file names that change on a daily basis, that I know I can programically change. Im not sure how I can send the dos command though from MS Access/VB. I don't want to use a .bat due to having to change file names. The following is what is in my .b
-
- VBA and Excel - If and Find expressions
by Ronan OK
- 2 Replies
- Last post
by Ronan OK
- Hello
I am trying to use an If statement to find an piece of text and then go to the cell that contains that text. I have, as part of the if statement, an else statement that just cancels the expression and does something else if it cant find the iece of text. However, the expression doesnt seem to work when VB cant find any cell with the specific text and it just comes back with a run time err
-
- 3 consecutive periods = 1 character
by une
- 3 Replies
- Last post
by une
- I am using VBA under MSWord 2002. It seems that MSWord 2002 often treats 3 consecutive period characters as a single character. This is causing me grief as I am trying to write code to count punctuation marks in text. Thus my code counts 3 consecutive periods as 1 period. How can I get around this
-
- protect cell containts
by Abhijeetkadam
- 1 Replies
- Last post
by Bruno Yu - MSFT
- Hello,
I have office xp .
i am not well versed with visual basic in excel programming.
i have one sheet where i have created a macro which returns current system date by pressing ctrl + o
i need two things
1)
i have 15 lines in A column wich contains list box .
user have to select a option from that list box and next to that option by pressing "ctrl + o" record
-
- adding a non-adjacent cell to a named/defined range
by bilo_krewol
- 2 Replies
- Last post
by Andy Pope
- I have a set of data in a spreadsheet that I want to run a macro through that will:
1. test each cell against specified conditions;
2. depending on what conditions are met, add that cell to a specific, named range; and
3. run statistical analysis on the named ranges.
#1 and #3 I am OK on, but #2 - I have not been able to figure out how to resize the range to add a specific, non-adj
-
- Creating Excel File Error
by CoderMike
- 2 Replies
- Last post
by CoderMike
- Hello,
I'm trying to create an Excel file using ADO. I can read from an Excel just fine, but creating it has been more of a problem. When I try to open a connection to a file name, I get "object not found" error. According to the MS article I read, the workbook should be created automatically when I create my first table in the workbook. However, I can't see how I can do this if t
-
- Using Inet to download an FTP File
by Dudeman
- 4 Replies
- Last post
by Jack_II
- I am creating a macro in Access VBA where I need to retrieve a text file from an FTP site and store it on my c drive. The code seems to be working fine but it does not do anything. It should be creating a file on my local computer, but no file ever comes back. Please advise with any suggestions that could get this code to work.
Sub FTPCheck() Const cHost = "ftp://ftp.xxxxxx.com/xxx/xxxxx
-
- Creating and Editing Microsoft Access Reports using Visual Basic
by bennymacca
- 3 Replies
- Last post
by bennymacca
- Hi,
I am trying to create a report based on the selection from a combo box in a form.
i have some data, of which one of the fields is callled "projects". the combo box selects selects a project, and i would like to be able to open a report showing the data that belongs to the specific project on the click of a button.
i have written the code below, but the report is only ever bl
-
- WER Dialog not showing up on Vista
by Jerry Noll
- 7 Replies
- Last post
by Claus Brod
- What should a managed application do in order to have the WER Submit report dialog appear
We have a managed client application that is subscribing the App domain's UnhandledException event. When this occurs, we log the exception, stack trace, and inner exception to the Application event log. We would like to report this event to WinQual. However, we are not seeing the WER dialog appear. Do
-
- Add additional value axis gridline to msGraph.Chart.8 object
by Bunglemutt
- 2 Replies
- Last post
by Bunglemutt
- MS Access report with embedded msGraph.Chart.8 object.
Graphing the series based on the rowsource to my satisfaction, but would like to add a pass/fail reference line to illustrate passing/failing datapoints.
Can I simply add a value axis gridline with the appropriate value and a custom color to illustrate the pass/fail reference line
If not - can I fake doing that by plotting another se
-
- A question from a beginner...
by meisaka
- 6 Replies
- Last post
by meisaka
- Hi all:
I am new to the programming world, and I am interested in learning VBA. So, please provide some tips where should I start
Thanks in advance.
-
- email using CDO (Collaboration Data Objects)?
by MyLady
- 3 Replies
- Last post
by Andy Pope
- Hey,
How do I, from Excel, send email using CDO (Collaboration Data Objects)
Best Regards
Cathrine
-
- Help needed: Retrieve tables in word and copy them to Excel
by Rz1986
- 3 Replies
- Last post
by bi-lya
- Hello everyone,
I have been assigned a task at work to write a VBA for automation. We have many word documents in a folder that have hundreds of tables within them. I want to create an automation program that is going to retrieve tables from the word document specified and go through the document table by table copying these tables into a separate Excel sheet named after the document itself
-
- Creating LookUp/Filter Command Button In Access 2003 using VB
by KaysWeb
- 3 Replies
- Last post
by Cringing Dragon
- I'm trying to create a LookUp/Filter Command Button using VB. I am not a programmer so I tried using what I found on the internet.
My Field Name is: Last Name
My Table Field Name is also: Last Name
The code that I am using is as follows:
Me.Filter = "Last Name = "" & me.Last_Name & "'"
Me.FilterOn = True
When I click on the Command But
-
- Office 10 \ winword.exe runtime error
by Kdean6869
- 14 Replies
- Last post
by Jyh-Cheng Chen
- I have downloaded the service pack 3 but I'm still encountering the problem when I try to open MS Word. MS Excel, MS Outlook , MS Powerpoint & MS Viso all work fine. Any time I try to open MS word I receice a Box vissual c++ runtime library. This application has requested the runtime to terminate it in an unusaul way. Microsoft Office\Office 10\Winword.exe.