-
- Highlighting cells within a worksheet
by pfunkmasterflex
- 3 Replies
- Last post
by Andy Pope
- Several of us in our office have a fantasy golf league and we administrate it off-line using an excel spreadsheet (we haven't found a free website that lets us tailor the rules to the way we like it.) Anyway, it is a salary cap format, meaning that only one golfer can be on one team at a time. To keep track of this, one of our worksheets has a list of all the golfers. That same worksheet also has
-
- ISV Software Requirements
by jk_0321
- 2 Replies
- Last post
by cUtEpInKbUnNiEs
- Hello all,
Sorry I'm new here and was unable to find an answer to my questions using the search feature.
Because Microsoft requires several MCPs to satisfy their non-ISV competancies, I need to take the ISV route to get Certified Partner status.
If I was to go for the ISV Competancy, what kind of application are they expecting me to develop I read on the lionbridge site that games and of
-
- 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
-
- Replacing (changing) the pictures in PowerPoint presentation
by Hani Simo
- 2 Replies
- Last post
by Hani Simo
- I am trying to write a small program to replace pictures in PowerPoint presentation... To find the pictures, I check Shape Type (Shape.Type = msoPicture)... But the problem is: how can I change the picture after this step What is the method I should use to load the new picture from file to the Shape Best regards and have a nice day, Hani
-
- Using Inputbox to detect a worksheet
by Jonas.S
- 1 Replies
- Last post
by Andy Pope
- Never mind I solved it, see red marked for solution
Hello,
I want to let the user add a serie to a chart. While doing so the usr will collect data using Inpubox from a different worksheet. He will need to go there three times to collect all data. I would therefore want the code to recognize on which worksheet the usr collected the first data set on and then when the usr has co
-
- Excel Macro running slower in 2003 vs. 2002
by Tim M.
- 0 Replies
- Last post
by Tim M.
- I am trying to figure out why a macro runs slower in Excel 2003 vs. 2002 and narrowed it down to a function that deletes rows. This function is used numerous times and before this function is called a varying row is selected, then is processed in this function. I think the Selection.Delete command is causing the slowed performance but not sure why it is. Does anyone have a suggestion Up to 100 ro
-
- ReportFault() vs. WerReportCreate/WerReportSubmit() on Vista
by Claus Brod
- 12 Replies
- Last post
by Jason Hardester - MSFT
- Hi all, I'm experimenting with the available APIs for error reporting. On XP systems, I'm using ReportFault(), which seems to work as expected- it displays the WER dialogs, sends data to the Winqual site (including minidump data), launches a debugger when asked for by the user etc. Is this the right place to ask questions about those APIs If not, please ignore the following. (But if you know where
-
- height of a field in word
by vsyam
- 6 Replies
- Last post
by Shasur
- Hi,
Any idea as to how we can get the height of a field in word in vba
Thank you.
-
- Problen reading Cell
by zeroton
- 2 Replies
- Last post
by zeroton
- Im from Brazil, and my regional seeting are "," to separete decimal places But when i use VBA to read a cell value, if it is 0,93 he only reads 0, but if it is 0.93, he reads correctly this is a sample of the code that i'm using
Code Snippet
Dim Proj(500, 500) As Double Proj(3, L) = Val(Cells(21 + L, "N").Value) My regional settings are ok
-
- Bloomberg + Execel = True?
by AndersBank
- 4 Replies
- Last post
by eric888
- Ok my situation is like this: I have a computer that runs Windows XP Professional. On the computer I have a Bloomberg subscription i.e. I have an ordinary monitor, but a Bloomberg keyboard and it is "true" Bloomberg subscription (it is not the Bloomberg website I am referring to). I have an Excel spreadsheet that is connected to Bloomberg and updated once every day using a DDE connection
-
- ApplyCustomType question
by NeitherMightier
- 0 Replies
- Last post
by NeitherMightier
- I'm running Office XP with current updates, and I'm observing some peculiar behavior when I try to use ActiveChart.ApplyCustomType in Visual Basic. The FIRST time I run my Macro after opening Excel, none of the code after: ActiveChart.ApplyCustomType xlUserDefined, "name" executes. After the first time I run the macro, the VBA Project (XLUSRGAL.XLS) appears in the "Project" wi
-
- opc
by ksona
- 14 Replies
- Last post
by MartinBrasil
- I am trying to develop an opc - da client using .net technology. Have gone through the documents on opc and opc client and all, but am still not sure how to implement it, can someone give me a direction on how to start with it
-
- 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
-
- DoCmd.OpenReport passinh param to underlying query in MSAccess
by acki4711
- 3 Replies
- Last post
by Bazz07
- Hi all,
- I have in Access (2003) a report who's datasource is a saved query. - This query needs a param
How can pass the param to the query using the DoCmd.OpenReport method
Any help is highly appreciated.
TIA
Dan
-
- "Cabs requested" icon
by Claus Brod
- 1 Replies
- Last post
by Jason Hardester - MSFT
- Hi, a number of the crash reports we're seeing is marked with the "Cabs requested" icon (cab icon with a little clock in it). The documentation says that this icon means that ".cab data has been requested and is not yet ready for download". I'm not quite sure how I should read this. My current interpretation is as follows:
For some crash reports, the .cab file is not tran
-
- Save As event not firing in Office 2007
by kvreddy
- 0 Replies
- Last post
by kvreddy
- I wrote an event for Save As menu , it works fine for Office 2003, but its not working for Office 2007 (1 line of code below)
If evtFileSaveAs Is Nothing Then Set evtFileSaveAs = 'Application.CommandBars("Menu Bar").FindControl(, 748, , True, True)
I am expecting doubt like Save As Menu Id is not 748.
Is there any solution for this
Thanks in advance and help
-
- Exporting the access resultset to excel programmatically
by Alex Kurama
- 1 Replies
- Last post
by Shasur
- Dear all,
I would know how can I export the access resultset to excel. Can I get the query from Access which I have done and saved in access directly, so that I do not need to rewrite the SQL statement in the VB, if yet, then how I think I need to use something like
Set rs = db.OpenRecordset("Query name") or such
but I don't know how. Can anyone of you can he
-
- Excel 'Freeze panes' from Access VBA (Off2000)
by Jasperz01
- 1 Replies
- Last post
by Jasperz01
- Hi, I'm searching for a way to freeze the upper part of my Excel sheet (with headers and such, like the 'freeze panes' menu option in Excel), from my Access VBA code. I've been searching for a while but didn't come up with something usefull. Anyone any suggestions Thanks in advance, I'd be really glad if someone knows this!
-
- Message for display during macro execution
by une
- 3 Replies
- Last post
by une
- I have a macro that takes a long time to execute. While it is running I would like to put an object on screen to inform the user that the macro is running and they should just wait. Otherwise they may think something is wrong. It would also be good if this object had a button on it the user could click to end the macro if they run out of patience. I thought about a message box, but when it is disp
-
- Upgrade problem Access 97 and Access 2003 on same machine
by ADG
- 0 Replies
- Last post
by ADG
- Hi
We have finally started to upgrade to Office 2003, I still have a copy of Access 97 on my machine to maintain databases which cannot be upgraded until the roll out is finished.
However, when I run my code now I am getting a problem. Access 97 now will not use the Trim$ function is an SQL statement, I get a message that the function is not available. Trim$ will work outside of an SQL state
-
- How to check if a date exists
by HMote
- 10 Replies
- Last post
by HMote
- Could anyone point me in the right direction I just need a way to see if a date exists...example: "6/31/07" doesn't exist, whereas "6/30/07" does exist. Thanks!
-
- Clearing a manually created indent for a paragraph
by kkrishna
- 3 Replies
- Last post
by Andy Pope
- I am testing the process of removing indents from headings. I created a manual tab indent (pressed Tab and created an indent for the heading text). Now I want to remove this indent by code. I tried the following:
oPara.Outdent
oPara.TabIndent(-1)
oPara.TabStops.ClearAll
The above codes were tried individually and collectively. I was not able to clear the indent created.
Ho
-
- BSM 2005 Server Installation Failed
by Jayaprakash Lingamaneni
- 1 Replies
- Last post
by MS ISV Buddy Team
- Hi All
We are trying to install Business Scorecard Manager 2005 Single Server Installation. We are getting error "Failed Microsoft Sharepoint Extended Site".
We can able to create a new website and extend another web site from Central Administration.
Please help me how to fix this error
-
- Internet Explorer 7 jpeg and gif blurry after tools/internet options/advance/reset
by remitdlo1944
- 5 Replies
- Last post
by bbenz3
- I was working on another problem and reset my advanced options. After all my jpeg and gifs now are fuzzy when displaying in only internet explorer 7.0.5730.11 all other programs display normal.
-
- API and OpenGL in VBA for Excel
by Spinor
- 7 Replies
- Last post
by @sanya
- How to use in VBA for Excel such API functions like, SetPixel, GetPixel, LineTo, PolyLine or ArcTo acting on the new created standard UserForm or in the special new window opened by appropriate API function. I know that it is trivial within VB applications, whereas VBA makes troubles (handle address of UserForm). I would be grateful for some simple examples (which have been tested and work well).