-
- Status on MSDN service (site down?)
by skaue
- 1 Replies
- Last post
by MS ISV Buddy Team
- I couldnt find a proper place to post this, but I'm trying here first.
My company is Empower so I have access to MSDN Premium.
However lately I've been unable to access the pages where you can see product keys and download dev tools. After a quick call to support a lady there told me the service were having technical difficulties and I should try again later. I did this morning and now its u
-
- dynamic creation of userform
by jiml27
- 10 Replies
- Last post
by Andy Pope
- I am trying to create a userform dynamically. I am having limited success, and have a few questions. For early binding, I use this code:
Code Snippet
Public UserForm1 as UserForm The question, then, is how to instantiate the userform The code that I use for late binding does not work:
Code Snippet
set UserForm1 = ThisDocument.VBProject.VBComponents.Add(3) and nei
-
- WSS 3.0 "This stock feature has been retired."
by bafadam
- 14 Replies
- Last post
by cis365
- What is this error No hits on google, nothing wrong with the page....nothing (that I know of) has changed recently.
Anyone have any clue with this could possibly be referencing
-
- Future of VBA (and VBScript)?
by fiatlux
- 28 Replies
- Last post
by fiatlux
- We developped a number of tools in VBA or VBScript, sometimes using COM objects, and the large compatibility of VB, VBA and VBScript was certainly nice. We would no mind moving to .NET (the framework API being quite interesting), but it is not clear what is going to be the future for VBA and VBScript. Can we expect a VB.NET"A" and a VB.NET"Script"
-
- Corrupted Error Report?
by Optical10
- 3 Replies
- Last post
by Optical10
- Hello
Whenever computer recovers from a serious error after restarting the Windows error report is corrupted so I get this message in the Explorer responds page,
”°Corrupted Error Report
Unfortunately, the error report you submitted is corrupted and cannot be analysed. Corrupted error reports I rare. They can be caused by hardware or software problems, and they usually indicate a serio
-
- 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.
-
- algorithms vba or c++
by magellan90
- 3 Replies
- Last post
by magicalclick
- i've been asked an opinion on number-crunching using algorithms - the question was whether c++ or vba was more adaptable and effective. i have used vba to construct algorithms in excel and have no technical knowledge of c++ to really evaluate the difference. essentially we're looking for conversion speed from mass data input.
thanks for any response.
-
- Spooler error 1068
by Terminator484
- 14 Replies
- Last post
by virginia3443
- I have been all over hell and high water trying to find some way to fix this error, but alas, my efforts have been fruitless; so here I am. The Situation: After moving about a week ago, I just got around to re-attaching my printer (a Lexmark X1185 ). I then discovered that my computer (Windows XP sp2) apparently deleted my printer drivers all by itself, so now I cannot use the printer. I downloa
-
- Sharepoint alerts (email) not opening in Outlook 2007 (error)...
by markm75c
- 9 Replies
- Last post
by markm75c
- Not sure if this is the right forum for this one ...
Some of our users are reporting that the Sharepoint email alerts sent to their Outlook (exchange 2007) email is not opening.. I believe these are only 2007 office users..
If they click on the email, there is no preview.. and if they open it...
"cannot open this item. outlook cannot add the requested sharepoint folder. c
-
- Heap dump (dmp) in cabinet file
by paso
- 5 Replies
- Last post
by Jason Hardester - MSFT
- I have configured the error reporting so that the reports are stored on a shared volume iso being sent to Microsoft.
When the crash occurs I can see that there is not only a mdmp file but also a hdmp file on the temp directory. Howerver the cabinet file on the local share does not contain the hdmp file.
Is is possible to force the hdmp file in the cabinet when using a local share for report
-
- Digital Certificate Error
by Kinglars
- 3 Replies
- Last post
by Adrian B Jones
- I am trying to create a digital certificate. When I run Selfcert.exe I type in the name of the certificate. I get the error "An error occurred during certificate creation. Selfcert was unable to create your certificate". I am running XP pro and Office 2003. Any suggestions on how to fix
Thanks.
-
- Merry Christmas and Happy New Year
by Derek Smyth
- 3 Replies
- Last post
by RhysDavies
- This is the forum I've maybe spend the most time in, although not so much recently but that can't be helped. To everyone who posts here often enough to know my name, and to anyone else to happens to read this... have a great Christmas and New Year... and even if you don't celebrate them I hope you enjoy the holidays.
-
- Exporting VBA Modules from Access to Excel
by gavinabrown
- 0 Replies
- Last post
by gavinabrown
- Hi,
I wonder if anybody knows how to use VBA code to export a module from Access into an Excel spreadsheet. I have no problem exporting the module using VBA and then importing it manually when I open up the spreadsheet in Excel. However I would like to do the whole thing from an Access form without having to manually import it in Excel. Can this be done from within Access
Thanks.
-
- 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
-
- Activate task
by Janfry
- 1 Replies
- Last post
by Shasur
- In Windows XP, Word 2003 SP2, I use Task.Activate() to give focus to the Word window to show the document I've launched, but the Word-task doesn't activate itself, it remains blinking and I must click with the mouse to show the Word.
I've tested with Task.Activate(True) and Task.Activate(False), Task.Visible(True), Task.WindowState, etc.. but nothing works, always blinking.
However
-
- Microsoft Platform Test for ISV Solutions
by Eli Gazit
- 2 Replies
- Last post
by EliGazit
- Hi.
My company is getting ready for the "Microsoft Platform Test for ISV Solutions".
Can I find more detailed directions and resources to set the designated application for the test
i.e. to pass "managed code" tests- I know that the application is free from 'DllImport', but I'm not sure that:
This is enough.
One of the components I'm using works with unm
-
- runtime error 1004 The macro 'Main' cannot be found
by bose321
- 2 Replies
- Last post
by Andy Pope
- Hi,
Iam developing a utility using VB2005 which imports a log(.all extn) to a excel (WIN XP) and then has to plot graph according to user selection from the menu bar of the VB form.
Following is the piece of code, where i open a standard template and save it. then i import the .bas file which has the macro to import from the log file. The VBP was working fine and suddenly it strats po
-
- Outlook 2003 custom task item conflict
by Nick1234
- 0 Replies
- Last post
by Nick1234
- Hi,
We use custom forms based on the Outlook task item. Multiple users view and update these items and we are experiencing high levels of conflict errors when forms are updated simultaneously by multiple users.
Is it possible to programmatically determine whether when opening an item whether the item is already open by another user and who that user is so that some sort of warning, s
-
- Use excel to update records in a sql database or access
by robace
- 4 Replies
- Last post
by Cringing Dragon
- Can VBA code be written to modify records in a sql or access database I can write vba code to query a database very easily and pull out the data I need, but can I write back to that same source and modify/add records through vba
-
- Preserving .hdmp and .mdmp files
by Dyolf Ztlof
- 1 Replies
- Last post
by Claus Brod
- Has anyone figured out a way to prevent the dump files generated in C:\WINDOWS\PCHealth\ErrorRep\UserDumps from being deleted after the WER crash dialog is dismissed Is there any configuration or hack to accomplish this (other than attrib +R)
It would be wonderful to be able to get at the dump files without the winqual overhead.
-
- Find and Replace in Two Sheets
by rachel777
- 1 Replies
- Last post
by Adamus Turner
- How do you add the sheet specifications to the code below so the code will look in column G in sheet named "Questions" for B2 text in sheet named "Solutions" The information for the two sheets are the following:
"rGCol" is in Sheet 1 named "Questions"
"sB2Text" is in Sheet 2 named "Solutions"
"G:G" is in Sheet 1 n
-
- VBA + Bloomberg
by macduss
- 5 Replies
- Last post
by Joe Dawson
- Hi All,
i am building a macro in which i retrieve info from Bloomberg.
i have to compare these data with other values.
Before comparing i would like to copy and paste special value the data retrieved from bloomberg.
How can i do to perform the copy paste special value only once all fields are updated (i.e. how the macro can know that the fields are ok and it is time to
-
- Common Dialog error...
by sdbenner
- 2 Replies
- Last post
by Shasur
- I am trying to use Excel VBA to open a folder and populate an array variable with all the word doc filenames in the folder. I am getting an "ActiveX component can't create object" error on the following code, specifically the Dialogs(wdDialogFileOpen) line, and I'm struggling to figure it out. Any suggestions Public Sub Main() Dim FileArray() As String, ffile As String, ffldr As String,
-
- 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
-
- How to paste an image in ppLayoutObject
by lollol8754645
- 1 Replies
- Last post
by Andy Pope
- I have wiritten a code that selects the right shape, but how to insert an image in it I tried to do it, but image displays on de slide as a new shape. Pls help me my code: Sub Code() ActivePresentation.Slides.Add(Index:=ActivePresentation.Slides.Count + 1, Layout:=ppLayoutObject).Select ActiveWindow.Selection.SlideRange.Shapes(ActiveWindow.Selection.SlideRange.Shapes.Count).Select End Sub