Microsoft ISV

Page 80




  • Topics
    Replies
    Last post
  • Problem passing a range as argument
    by Douglas Penna
    3 Replies
    Last post by Douglas Penna
      • Hello there, I'm developing a macro do do some calculations on a worksheet, but I always get a problem when I pass a Range as an argument to my function. My code is simple, and here it is: Sub Main()     Dim Range_do_Comeco As Range     Set Range_do_Comeco = Worksheets("Plan1").Range("AD2")     MyFunc(Range_do_Comeco ) End Sub Sub MyFunc(ByR
  • Option buttons
    by une
    2 Replies
    Last post by une
      • I have a user form under MS Word that contains 3 sets of 2 option/radio buttons (6 buttons total). Each set of 2 buttons represents a polar decision (ie Yes or No). Thus there are 3 Yes/No decisions to be made by the user in this userform. At the moment only one of the 6 option buttons on the page will show as "selected" at any one time. Thus the userform is effectively presenting one qu
  • Help! Please! dll
    by morozx
    3 Replies
    Last post by ke wenzel
      • I have windows vista and a long time ago I accidently opned a dll file with notepad and now i dont know what to do. A lot of my programs wont run, and i cant find a application to open it with. So i need to restart my computer but how ! !
  • Grabbing image from Clipboard & saving as jpg
    by BPurser
    1 Replies
    Last post by Andy Pope
      • So, I have done a truckload of googling this morning trying to resolve what I assumed would be a fairly easy task: to wit, using Access XP, I'd like to have some VBA that grabs an image from the clipboard (copied there from another application) and save it to a specified location with a generated file name. I can do everything but the salient point of grabbing the image and telling VBA to s
  • How to configure CER with no dialog?
    by John Brown
    14 Replies
    Last post by Claus Brod
      • I just tried to configure my XP SP2 workstation to send crash reports to a CER file share such that no dialog box would be presented. It didn't work as expected. ReportFault returned frrvErrNoDW and no crash report showed up in the file share. I have the 'Configure Error Reporting' policy enabled and a corporate file path entered. This works fine when I elect to 'send report' through the dialog bo
  • Excel: Public variable doesn't work
    by My_Head_Hurts
    2 Replies
    Last post by My_Head_Hurts
      • I have a routine that needs to sometimes display a form to get user input, then hand the result back to the caller. I use a Global variable to do this but the value is not returned. When I use Option Explicit, I get a run-time error, "Variable Not Defined" in the form. The code is like this: In the calling module... Code Snippet Public PsResult as String private sub Module
  • how to control equations in MS Word
    by ninjaneer
    2 Replies
    Last post by LeVraiNinjaneer
      • Hi! I need te create a table that calculates values for forks, knives and plates from one variable pax(number of people). This table has to be in MS Word. How can I setup a table that multilplies given constants by pax I need to be able to format the colours etc of the table to make it look attractive. Thanks a lot in advance for any help, I really need it Pieka
  • Routine to open file/point to url
    by GB Allan
    4 Replies
    Last post by GB Allan
      • Hi, I have the following routine as part of a larger macro, to open and work with a file: MsgBox ("Please open the new ABC File.") ABCFile = Application.GetOpenFilename("Excel Files (*.xls), *.xls") Workbooks.Open Filename:=ABCFile ABCFile = ActiveWindow.Caption Right now, I ask the operator to save this file on their computer, then open it when promp
  • Why the do while loop does not work?
    by lyp_sj
    6 Replies
    Last post by lyp_sj
      • Hello, Below is my code, the lastrowGSVGrowthRate is 101, I expected result is to copy all the "AFFILIATE" items. While with my code, it only copied the first "AFFILIATE" item. I do not know where I did wrong. Thanks so much! B.regards/Yaping raffiliate = 1 rowaffiliate = 1 Do While raffiliate <= lastrowGSVGrowthRate If cells(raffiliate, 1
  • ActiveX Slider Control 6.0 (SP4) Problem
    by Lars Bratt
    2 Replies
    Last post by Lars Bratt
      • Hi everyone, The 'On Updated' event does not fire after having modified the slider position. This is an MS Access VBA development project. Can anyone tell me how to get this event to fire Or is there another way that I can recover the value of the slider position after the user has moved it Any help or other pointers will be greatly appreciated ! Many thanks, Lars
  • Macro to add jpg to header of spreadsheet
    by GB Allan
    4 Replies
    Last post by GB Allan
      • Hi, I have a macro which formats a spreadsheet and adds a pic to the header. It works fine; but the problem is that it uses a specific path to locate the image file. If someone else wants to use the macro on their PC, I have to "tweak" the code by changing it to their file path, so the macro will locate the image file. Is there code I can use that will find the image, as long a
  • How to apply for Partnering
    by Bhavtosh
    4 Replies
    Last post by rs07
      • My company developing softwares using microsoft products and would like to become a microsoft partner. what are required steps for it any guidance is appreciated.
  • how can I count # of columns between two specific columns?
    by lyp_sj
    3 Replies
    Last post by lyp_sj
      • Hello, How can I count # of columns between two specific columns such like, how many columns between column A and column D Thanks so much! B.regards/Yaping
  • 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
  • How to rename worksheet without installed Excel?
    by Perry Choy
    5 Replies
    Last post by Andy Pope
      • I want to rename worksheet but haven't installed Excel
  • Cannot find project or library
    by Tuzz
    2 Replies
    Last post by Tuzz
      • Is it possible for an ExCel Spreadsheet created with a most recent revision of an ActiveX Control to not work on a PC running a previous version of the ActiveX Control. In other words, backward compatibility not supported. The Error code the user recieves is a Compile Error: Can not find Project or Library. This is with respect to the 'Format' function in VBA With that said, we che
  • Color for the arguments
    by ObiWanKanobe
    1 Replies
    Last post by Andy Pope
      • I use the following to send a workbook to receipent and everything works great,but I now have a need to change color of the arguments to a color such as red to indicate immediate attention. I can't seem to figure out how to do this or don't know if its even possible. any help would be appreciated. Application.Dialogs(xlDialogSendMail0.Show _ Arg1:="xxx@xxx.com_ Arg2:="wo&quo
  • calculate_worksheet event
    by Jonas.S
    2 Replies
    Last post by Jonas.S
      •   I have solved this in another way but if someone knows how to do it with calculate_worksheet event I would appreciate the knowledge!   Hi All, How can I use calculate_worksheet event just for checking some certain cells on a sheet I want it to check E45:G45 which are updated from other cells. When the range E45:G45 change I want to run a macro. Thankful for help
  • Office Communicator 2005 sign-in name, auto populate after install somehow?
    by markm75c
    14 Replies
    Last post by Mike@ALS
      • Does anyone know of a way to have the sign in name in communicator, auto filled in after an install or doing the install.. Basically every user has the same format.. first.lastname@domain for the login. I'd prefer to find a way to have this info auto entered after the install when it first tries to open. I'll be using communicator as a "broadcast" method.. and alot of users prob
  • WER and file version differentiation
    by Joel Stein
    3 Replies
    Last post by Joel Stein
      • When mapping files against version numbers, does WER (and the watson servers) compare all four version_info fields For example, I have mapped version 4 of my application, for example, MyApp.exe, which has version 4.0.6192.0. As bug fixes are done for this application, the last integer gets bumped...now we are up to 4.0.6192.27. Do I need to remap the application, and/or upload a new map
  • dll's in VBA
    by Keithyboy1
    1 Replies
    Last post by Douglas Penna
      • Currently in my VBA programs, I'm finding myself repeating a lot of code and functionality across different projects, and it would be great from a maintenance point of view if I could create something similar to a .dll, that I could import into a project and use. Furthermore, if circumstances change and I need to change how a sub-routine works in the .dll for example, all projects using it will be
  • Excel VBA open/select text in Word?
    by sdbenner
    1 Replies
    Last post by Peter Mo.
      • I'm trying to use Excel VBA and open a word document and select a few fields of a table to paste into Excel. Is there a way to search for a certain string and copy the adjacent table fields in Word so I can assign them to a variable for pasting into Excel
  • VBA, Null value and data object not set?
    by magicalclick
    3 Replies
    Last post by magicalclick
      • This issue is getting my nerves. In VBA, I can't just say, if MyObject = Null to determine whether the object is set or not. IsNull is pretty uesless since it will report false when the object is not set. VBA treats Null as a value, not an object that hasn't been initialized. Does anyone knows how to get around it Or maybe there is proper way to determin whether the object is initialized or not
  • programming "yes-to-all" functionality
    by pacificwaters
    4 Replies
    Last post by pacificwaters
      • I'm using VB 6.3, and I'm trying to program a Yes-to-All (and No-to-All) button, which doesn't exist in the MsgBox functionality. Currently trying to use the .doalert method: With Application.Assistant Select Case .DoAlert( _ "Invalid Member", _ message, _ msoAlertButtonYesAllNoCancel, _ msoAlertIconQuery, _ msoAlertDefaultFirst, _ m
  • 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