Microsoft ISV

Page 22




  • Topics
    Replies
    Last post
  • 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
  • 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
  • Excel: SaveAs dialog won't accept a Web path
    by My_Head_Hurts
    0 Replies
    Last post by My_Head_Hurts
      • I'm bemused why something so basic works in Word but not in Excel. I have a custom version of Workbook_BeforeSave, one that assists the user to specify a SharePoint path, should that be their wish. The full file name (path + name) is then provided to the SaveAs dialog, thus: Code Snippet Application.Dialogs(xlDialogSaveAs).Show sFullName ' sFullName is both path and name If no pa
  • a question about iterative loop to print a sequence of number
    by crazyfisherrr
    1 Replies
    Last post by Cringing Dragon
      • Dear all, I am trying to find a newsgroup about VBS but fail, and I am sure someone here will be a master of VBS as well. Just trying to write a simple script that uses an iterative loop to write the numbers from1.0 to 1.9, then 2.0 to 2.9, etc up to 10.9 to a text file. Is it possible to do it in VBS thanks very much !!!
  • MS Word Macro Help
    by spphat
    2 Replies
    Last post by Shasur
      • Hi Everyone: I did a search before asking this, but could not find anything, so I apologize if this has already been asked. I am creating a macro in Word, but I only want the Macro to run on the text that I select within Word - how would you do this Thank you very much to anyone that can help!
  • Vba Excel 2003 - Prompt Message Box with timer
    by ajliaks
    2 Replies
    Last post by ajliaks
      • Hi guys, I need to prompt a mesage box telling "XYZ" and automatically close it after 3 minutes. Thanks in advance for any help. Aldo.
  • Disabling the X (close) button on a UserForm
    by rabbitoh
    5 Replies
    Last post by rabbitoh
      • Does anyone know how to disable the X on the top right corner of a UserForm so that when a user clicks on it to close the form, they get a message saying "Please use the Exit button" (which is a macro button on the form itself)
  • Ways of sharing data between VBA and another non-dotnet application.
    by Aleksey Nagoga.
    4 Replies
    Last post by Aleksey Nagoga.
      • Hi All, I need to share some text data between VBA and another non-dotnet application. The solution needs to be easily deployable as both application are on the client side and need to be hidden from a naked eye, meaning that I can't just create a text file in one app and read it from the other. (sensitive material like passwords may occasionally be sent as well) I considered using shared me
  • How to track changes
    by Muhammad Essa
    4 Replies
    Last post by Muhammad Essa
      • Hi Can any one tell me how to track the changes brought by other admin users in ISA server or any option modified by them. Any log or .... any one
  • SeriesCollection(i).Delete
    by chrisger
    3 Replies
    Last post by tronTech
      • Hi, I added some series to a chart and .seriescollection.count results = 6. That's OK. Now, series(6) references to empty cells. I want to delete the series but that's not possible. Err. 1004. Series with data can be deleted without problems. How can I access the series 6. Chris
  • 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
  • Cannot Uninstall or Install Internet Explorer Version 7.0.5730.11
    by t12u0ng
    0 Replies
    Last post by t12u0ng
      • I have trouble with my Internet Explorer 7. When I try to access the Internet Options it shows up and disappears within a second. I tried to uninstall Internet Explorer 7 a series of errors pop up. I've uploaded one of the errors onto this site http://tinypic.com/view.php pic=530d1ll can anyone help me out
  • Action Pack Question
    by Tone Southerland
    12 Replies
    Last post by Mark.Rowe
      • I am interested in the Action Pack. I understand that it comes with the Vista upgrade, not the full edition. I do not have 10 licensed copies of XP Pro to upgrade from. So does that mean I will need to purchase a licensed copy of XP Pro for each machine that I want to put the Action Pack upgrade version of Vista on
  • Excel Inserted Image Files - Compress
    by suznal
    1 Replies
    Last post by Andy Pope
      • I am trying to compress inserted .jpg files in a workbook. There is a button on the picture toolbar in Excel, but I would like to execute the command when the picture is inserted. However, "compress" does not seem to be a property for any event. I have recorded a macro where I compress an image file, but it does not record the event - the code is blank! I have the code in plac
  • Cells
    by LRFT
    6 Replies
    Last post by magicalclick
      • I'm really confused as to why I activate a cell: x = ActiveCell.Row Yet when I try to select that cell: Range (Cells(x, 1)).Select It comes up with an address way out of whack! What am I doing wrong
  • Determine if and where the .NET Framework is installed using VBA
    by TU71
    6 Replies
    Last post by vtortola
      • I have an Excel spreadsheet that needs to determine if the .NET Framework is installed as well as the path to that install. How can this be acomplished in VBA code
  • 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"
  • 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
  • Putting formulas in Excel cells via a macro
    by KenCubs
    2 Replies
    Last post by KenCubs
      • I am creating a formula for an Excel cell in the macro. The address that I want to put in the formula is the evaluation of an expression in the macro (cell(x,y).address). How do I get VBA to put the value of the expression into the formula. Right now, the resulting Excel cell looks like this: =sum(1,-cell(x,y).address) . I want: =sum(1,-a3)
  • Obtain formula value in VBA
    by DinnerPlates
    3 Replies
    Last post by Andy Pope
      • Hi all, I have created a macro (thanks once again to the help of Andy) which looks like this:
  • run an exe file in excel using VB
    by mambo5
    5 Replies
    Last post by mambo5
      • Hi, I want to run an exe file in excel using VB, any simple coding for that Thanks.
  • Question about VBA and Office 2007
    by loganscott2000
    5 Replies
    Last post by magicalclick
      • Hey, everyone. We have several (dozen!) Word template files that contain a LOT of VBA code. We are evaluating the benefits/risks of converting these docs to Office 2007. That said, my questions are: 1. Are there any known issues with converting them to 2007 Specifically, if I just open the file (and convert it) to 2007, is my code going to *** out on me 2. Do I have to convert (or
  • Gantt in Acess
    by Toblerone
    7 Replies
    Last post by LCarato
      • Hi all, I have an app in which I need to create forms and controls on the fly (A form that designs itself from table data). That part i have solved and it works perfectly. The problem i'm faced with is not being able to create forms once the db is compiled and converted to .mde I have been reading about workspaces. My idea is to create a workspace and generate the forms in that. None of the forms
  • Planning first deployment of new .Net application suite with SQL server...
    by Harald Stensrud
    0 Replies
    Last post by Harald Stensrud
      • What are the preferred tool for managing installation for end users. I have Wise & Install Shield on my preferences list, but I would be happy for any input from experiences that ISV's have had. Pros and cons... Application is a Win Forms 2.0 database application, but also in the suite is MFC & windows mobile solutions. Thanks Harald Stensrud
  • Table not uniform
    by kkrishna
    0 Replies
    Last post by kkrishna
      • Hi All, I wrote a macro that formats the cell text of all the tables in the Word document, if the tables are uniform. Since the macro accesses each cell for formatting, I wanted to avoid formatting non-uniform tables. This works quite well for Word docs generated from databases. I converted a pdf document to Word using Acrobat 7. The generated Word document has many tables and all of them ap