-
- Need help concatenating with the " character
by Alberto Bustos
- 2 Replies
- Last post
by Alberto Bustos
- I am working with VBA for Excel. I am trying to write this formula in a particular cell:
=SUMIF($C$7 C$296,"=SUBTOTAL",D7 296)
So, I do this: (j is a variable)
.Offset(j, 3).Formula = "=SUMIF($C$7 C$" & (j + 4) & ", "=SUBTOTAL", D7 " & (j + 4) & ")"
but it turns red because of the "s around SUBTOTAL.
So, I
-
- where do I start??
by Eyalwu
- 2 Replies
- Last post
by Eyalwu
- Good evening.
Here is the thing.
I am using a Mass spectrometer, which exports data into excel worksheet. What I want to do now, is to process this data while it being exported into the worksheet, i.e: taking avrage value every (let's say) 5 values that being exported, or every once in a time interval, and save it somewhere else (a different worksheet for example).
Now, since I don't know
-
- XP SP2 CD Key
by terryls50
- 3 Replies
- Last post
by nurhi
- The PC at our church that contained our initial Win XP SP2 installation was stolen. We have the original Window XP SP2 CD and it's packaging, but we can not locate the CD Key. How can we find out what our CD key is
-
- Using WebBrowser Control to Print
by Scot R
- 0 Replies
- Last post
by Scot R
- For for the last 2-3 years i have been using the following code to print the displayed html.
Private Sub WebBrowser1_NavigateComplete2(ByVal pDisp As Object, URL As Variant)
WebBrowser1.ExecWB OLECMDID_PRINT, OLECMDEXECOPT_PROMPTUSER, 0, 0
end sub
Unfortunatly it was recently reported to me that this no longer works. I am getting the error description
"Automati
-
- 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
-
- Creating AxInterop.AcroPDFLib.dll and Interop.AcroPDFLib.dll in VS 2003
by Karl Miller
- 0 Replies
- Last post
by Karl Miller
- I'm wanting to create these DLLs. They don't come with Windows or Adobe Acrobat V7. References to them in C# code I'm maintaining exist, but the original author is not available and I'm not sure how they were created. Any help would be much appreciated. Thanks!
-
- 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
-
- Convert decimal string to Chr$()
by Jade_Emeperor
- 8 Replies
- Last post
by Jade_Emeperor
- Hi. I'm currently writing a program for RFID using Visual Basic 6.0
But however I'm not sure how I can convert my decimal string to Chr$(). Because I currently wrote the code like this:
Code Snippet
decimal_string = CInt("&H" & hex_string)
Char_String = Chr$(decimal_string)
And an error pop up telling me that is an invalid procedure
-
- update plots with cell info change
by Jonas.S
- 2 Replies
- Last post
by Jonas.S
- Hi,
I have a plot macro, see code below which I would like to continuously update the plots when a change been made to reference cells(E45:G45 and N3:P3). Anyone out there who can help me with this
Sub Engine() COG_t = Range("E45:G45") Eng_s = Range("N3:P3")
'Declaring variables Dim xmax, xmin, ymax, ymin Dim x, y
'Calculats the engine's position
xmax = COG_t(1, 1) +
-
- Read the contents of an email window
by Andy Brooker
- 0 Replies
- Last post
by Andy Brooker
- Hi
I am sure this is easy but I can't figure out how to do it !
In Outlook 2003 when someone creates a new email I want to add a button to that window that will allow me to read the contents, mainly the email address.
I have created a macro and made that a button on the email window, I have tried using inspectors but I just can't fugure out how to read the email address.
-
- ArcSin for Excel Macro
by Le Phare Rouge
- 1 Replies
- Last post
by Peter Mo.
- How do I implement an arcSin function for an Excel macro.
thanks,
-
- Macros in visual basic
by Mathinirai
- 1 Replies
- Last post
by Bruno Yu - MSFT
- i need solution for the below two queries..
am using source as outlook 2003 and destination mail as yahoo
1.How to forward the deleted mails from outlook 2003 to another mail like yahoo or gmail
2.How to forward the incoming mails which are not replied for 2 days to another mail id
kindly help me..
thanks in advance..
-
- WER wish list for developers 8-)
by Claus Brod
- 14 Replies
- Last post
by Joel Stein
- Jason Hardester posted today about some of the decisions made at Microsoft around WER, and concluded with a call to action to collect requirements for WER from a developer point of view. I'm glad to oblige (And thanks, Jason, for your helpful post.) My main issue with the current implementation of WER, particularly on Vista, is that it makes it hard for a developer to find out whether a crash rep
-
- Proxy username and password
by luca-spazio
- 2 Replies
- Last post
by luca-spazio
- A big hi to everyone in this forum, I'm searching a simple code to solve my vba (excel) problem.
The problem is:
I'm accessing a server outside my firewall, due the fact that I've to insert a password and an username each time I open an internet page, how could I do the same with a piece of code in VBA I need my proxy to recognize me as user and allow my connection to the external server.
-
- Microsoft Office Document Imaging no longer in Printers Folder, Using XP and Office XP Professional
by vab
- 13 Replies
- Last post
by N_Horden
- This problem has been mentioned by many other users (in a different thread subject), so I wanted to start a new thread. I have tried many suggestions, but none have worked for me.
My MODI has been a print option for me until just recently. It disappeared from my printers folder. I have repaired, removed, and re-installed Microsoft Office. The MODI will still not appear in the printers folder.
-
- Executing code automatically
by une
- 1 Replies
- Last post
by Andy Pope
- I wrote some code within a UserForm that does xyz when a command button in the UserForm is clicked. I then created a macro that runs the code in the UserForm using the statement "UserForm1.Show". I then added a custom button to a toolbar that the user can click to run this macro. The result is the user clicks a custom button on a toolbar and the UserForm appears, instructing the user to
-
- 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
-
- Populate Combo Box with Outlooks Address Book
by Tom LeBold
- 1 Replies
- Last post
by Andy Pope
- What is the code to populate Combo Box with Outlooks Address Book.
> Dim objOutlook As Outlook.Application Dim ObjOutlookAddress As Outlook.AddressList ' Create the Outlook session. Set objOutlook = CreateObject("Outlook.Application") ' Create the message. Set objOutlookMsg = objOutlook.CreateItem(olMailItem) 'Set ObjOutlookAddress = objOutlook.CreateItem(olConta
-
- VBA:how to set comment object's author in Excel 2003
by Daniel Yang
- 2 Replies
- Last post
by Andy Pope
- Hi all, How should I set or change the comment author of a cell in Excel 2003 I have looked up in MSDN. It only provides the sample codes of how to get the author value. I use the following codes:
Sub setcomment()
Dim a As Comment
For Each a In ActiveSheet.Comments a.Author = "daniel" Next
End Sub
The error message is wrong number of augm
-
- 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
-
- 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
-
- Position a Cell at the top left conrner of the window
by John in HK
- 3 Replies
- Last post
by Andy Pope
- I'm writing a routine to process a series of tables with user input.
The user needs to be able to see the table, as well as the UserForm which gets his input, so I need to move the window so that a particular cell is at the top left hand corner of the window - is there a way to do this in VBA
Thanks
-
- Help in Creating a cell formula with variables using a macro
by dubaikhan
- 1 Replies
- Last post
by magicalclick
- I need help in creating a dynamic excel formula using variables. I have a start date in a macro variable which I want to pass within a macro to the creation of new sheet that takes this variable places it in an excel EDATE forumla and places the data info another cell. I know I have syntax issue going on in the highlighted area and would appreciate some help.
'Populate Variables ProjectSta
-
- VB in Excel-setting chart source data
by jk2880
- 3 Replies
- Last post
by jk2880
- I am attempting to create a macro that automatically creates charts for columns of data in a different sheet.
I would like to replace the "hard coded" range property with a variable range(cells,cells) in order to cycle through several different columns of data.
With the following line of code, I receive the error "Run-time error '1004': Method 'Cells' of object '_Global' f
-
- 2 Small Macro problems.
by GB Allan
- 6 Replies
- Last post
by GB Allan
- Hi all,
Problem 1:
I am trying to delete a sheet within a workbook, as part of macro. Here's the code:
Sub DeleteInstructions() ' ' DeleteInstructions Macro ' Macro recorded 3/13/2007 by Gary Beckwith '
' Sheets("INSTRUCTIONS").Select ActiveWindow.SelectedSheets.Delete Sheets("DATA").Select End Sub
When I run it, I get the prompt "Data may exist in the