-
- Why I can't get my crashes in winqual account?
by Nikolai Bochkarev
- 3 Replies
- Last post
by Saar Picker
- Hi!
Continue working with WER Api in Delphi
Part I " Some questions about WER "I
I try to integrate WER support in delphi application and write own exception process based on WerReportCreate and WerReportSubmit functions.
I'm raise exception, get right Bucket ID ( 50248784 ) and view status : Report Sent (see next screenshot)
I can't get this^^^ report in
-
- VBA Macro created in Word Template not running when template is launched in Internet Explorer
by S Prasad
- 6 Replies
- Last post
by S Prasad
- Hello:
I have a Word template that contains a VBA application. This application is launched through a macro and runs fine when I double click and open the template using MS Word. However, when I tried to open the same WORD template file in Internet Explorer (this is the final requirement), it fails to launch the application or run the macro. I am already using the following code in the ThisDoc
-
- SpeedUp a Macro in Excel - Disable Functions
by PYA_Ferro
- 8 Replies
- Last post
by PYA_Ferro
- Hi all, In my macro I used this sentences to speed it up:
Application.ScreenUpdating = False Application.EnableEvents = False
But I've also created some functions and they are beeing recalculated every time my macro do a change in a worksheet.
Is there any way to disable the calculation of functions
Thanks and really sorry for my English.
-
- Opening a .xls from a .ppt macro
by BarneyMKM
- 1 Replies
- Last post
by bi-lya
- I thought this would be easy to do, but it's proven to be difficult. I have an excel spreadsheet that I want to open from a Powerpoint macro. I've tried multiple variations of Workbooks.Open("....") , but get an Object Required error. Anyone know what I've done wrong
Barney
-
- How to determine the cursor position to Excel range
by Perry Choy
- 6 Replies
- Last post
by Perry Choy
- I want to get the cursor position of excel application range A1
-
- narrator/vista
by joe030303
- 4 Replies
- Last post
by pkclark1
- is there any way to permanently turn this thing off it drives me crazy
-
- VBA Language Definition
by RyanH106
- 2 Replies
- Last post
by RyanH106
- Hi, just a quick question
Does there exist anywhere a formal definition of the VBA language It would be really useful for my dissertation as i am writing a program that interprets macros so could do with something that would tell me, for example all the different ways that variables can be defined, or all the different types of statement that can be used etc.
Any advice is much appreciat
-
- Obtain Unique Work Units via SQL
by AlDeb
- 14 Replies
- Last post
by AlDeb
- Below is the SQL I have for a Query. The results of my query are below the code. Everything works great except for the WorkUnit totals.
I am getting the total Records for the date range and I really need the Unique workUnits for the date range. For this particular daterange I
have a total of 197 WorkUnits but in reality there really are only 89 Unique WorkUnits.
In the example below on on
-
- Certification of Web Application?
by Draok
- 2 Replies
- Last post
by marceloshb
- I am a developer of a web based medical application that is viewed in a web browser. It is developed using asp.net and is hosted from an IIS server. There seems to be some confusion in my company regarding the type of Windows Logo certification that can be applied and tested for with ths type of applicaiton. I have always thought this kind of application was only available for the Windows Server 2
-
- Interactive entry of data to the VBA script
by kkrishna
- 2 Replies
- Last post
by kkrishna
- Hi All,
I am working on a script which compares the cell values of two ranges in different workbooks. I could work out the code with the actual workbooks, worksheets and range names manually written in the code before running the script. Now I want to generalize this script to select the workbooks, worksheets and the ranges while running the script. I could select the workbooks by the GetOp
-
- Using a Check Box in Excel
by aburnett
- 3 Replies
- Last post
by sjoo
- I have never written any code before so I need some help. I would like to insert a check box on a sheet in excel. If that box is checked I would like to copy specific information from a range of cells from another sheet to the sheet with the check box in it. For example, I would like to copy data from cells D7 through CO7 in sheet 1 to cell D1 in sheet 4.
I know how to insert the check box
-
- Sorting an array
by une
- 4 Replies
- Last post
by une
- I have have an array named punc, is there a function I can use to sort its elements
Would the command be;
Array.Sort(punc)
it doesn't seem to work.
This code did not work either and I can't work out why;
Dim punc(3) As Integer
punc(0) = 8 punc(1) = 7 punc(2) = 6 punc(3) = 5
Dim i As Integer Dim j As Integer Dim temp As Integer For i = 0 To 3 Step 1 For j
-
- Runtime Error 1004
by akn112
- 5 Replies
- Last post
by akn112
- I think i've asked on almost every VBA forum
Here's the error code im getting: Method 'Range' of object '_Global' Failed
It comes every second time i run the code. Originally i thought it had something to do with the variables. But i have set my code to set my variables to nothing at the top and bottom of my code. I also close the application and close the workbook.
This code should 1) op
-
- Numbers in textboxes VBA Excel
by rascalcat
- 4 Replies
- Last post
by rascalcat
- I am trying to use a userform with 3 textboxs. 2 are for user input of numbers. The other is to display the calculation result using the input numbers. Having problems getting the + operator to do what i want
-
- "StackHash" crashes
by Claus Brod
- 3 Replies
- Last post
by Jason Hardester - MSFT
- Hi all, this is probably not the right place for this question, but I'm giving it a shot anyway, counting on the fact that we have experienced people here who crash applications for a living I recently noticed APPCRASH report data which specify something like "StackHash_1703" in the "faulting module" parameter of the Windows Error Reporting crash data. When this type of crash
-
- Excel - CheckBox Tick Color
by suznal
- 4 Replies
- Last post
by suznal
- Is there a way to change the color of the tick mark in a checkbox without changing the default color of the box itself in VBA I want the default black checkbox, but when selected I want a red checkmark in the black box.
I found that I could change the color of everything (box and checkmark) in the properties window of the checkbox, but it's not what I'm after. I also could not not find a proper
-
- Spin Button programming
by une
- 3 Replies
- Last post
by une
- I am trying to do the following without success as yet. I have a label and a spin button on a userform. I want the label to initially show an integer value of 7. I want the user to be able to change this value to any integer from 1 to 12 inclusive by clicking the up and down arrows on the spin button. When the up arrow of the spin button is clicked the value will increase by 1 until it reaches 12.
-
- Rostering
by Starfish
- 1 Replies
- Last post
by Cringing Dragon
- Would it be possible to use excel formula to create a roster I am rostering the office staff to do reception duties during lunch. I want the sequence of rostering to be one staff from each department until the last person has been scheduled. Can this be done
-
- How do I deal with files of more than 65k rows?
by chilehed
- 8 Replies
- Last post
by chilehed
- I need my code to be able to deal with .csv files of well over 65k rows, but haven't the slightest idea how to do it.
I've heard of a technique called "paging", which distributes the data over more than one sheet but processes it as if it's on one.
How is this done
Thanks.
-
- Opening an access database to memory
by Kevin Porter
- 2 Replies
- Last post
by Kevin Porter
- I am trying to open an access database to memory, then test somedata in Excel against, then send that data to individual worksheets.
The bigggest problem I am having is actually connecting to the database. The only way i can get it to work is if I open the database into a worksheet, which I do not want. I want to simply connect to it.
It says I am using Microsoft Visual Basic 6.3, I sta
-
- trying to highlight selection in a combobox on a userform
by yoshikatsu
- 3 Replies
- Last post
by yoshikatsu
- Hi,
I have a combobox embedded in a frame in a userform. I populate the combobox and make its initial selection in the userform_initialize() event and then set the focus to that combobox.
What I would like to do is for the current selection in the combobox to be highlighted (ie text and background inverted, like when you double-click on a word in text, so that the user knows that the first t
-
- Integrating VBA in our own Application
by Igor Mendizabal
- 1 Replies
- Last post
by Pedro Fenoy
- Hello,
I'll try to keep this short: we are using VBA to extend our application, so that our distributors can make their own changes to the standard behaviour.
Until now, we added and removed objects to the VBA IDE manually, that is, add the object to the VBA project list when it is created by our application, and remove it when it is destroyed.
We want to automatise that, and
-
- Adding a new area in Entity Navigation Pane of CRM 3.0
by A. Gazi
- 0 Replies
- Last post
by A. Gazi
- Is it posible to add a new Area to the Entity Navigation Pane of CRM 3.0
If it is, does any one know how to do it
Thanks
-
- Auto-populating form fields based on the selection in another field
by rabbitoh
- 0 Replies
- Last post
by rabbitoh
- I want to a number of form fields to auto-populate with data obtained from locations on a EXCEL worksheet, based on the selection made in another field on the form. For example: If "apples" are selected from a drop-down field, then a number of related fields (edit boxes) are to display the attributes of the apple i.e it's colour, it's size, etc. If an orange is selected then the related
-
- How to create a chat room on Communicator 2005
by Marco Antonio Ribeiro
- 6 Replies
- Last post
by MS ISV Buddy Team
- Hi fellows!! Is it possible to create a chat room, or a meeting room, whatever, in Communicator 2005 I'm trying to keep a chat window with my friends for all day long, but it closes every 10 minutes.... I wanna keep this persistent for all time that members are logged in. Thanks for any help!!! Regards, Marco