Microsoft ISV

Page 109




  • Topics
    Replies
    Last post
  • update cell value using loop
    by Alen cappelletti
    1 Replies
    Last post by Spidermans_DarkSide - MSP, VSI
      • Hi, I try to develop this script but now I have a brake. What I must do I got an array of column like C, E, F, T,... and I must update all cell setting above everyone the char '. Example: my cell have the value of sun...I must update like 'sum. This for a problem of import values into integration services of SQL server 2005 (SSIS). But the loop must be run untill the last
  • faster code for a reccursive file count/size in excel vba?
    by lyosha
    2 Replies
    Last post by duck thing
      • ive got some code to do a reccursive file counts, i need to get the total count of files and sizes for a range of folders.. is there any way to speed up my code.. i am pretyt new to this and i know my code is kind of ugly, thought this would be a good place to start.. what the actuall excel sheet looks like: a place to paste file paths, sometimes 10 sometimes 200 folder paths, and a button t
  • Erratic Performance using Workbooks.Open
    by lgoldstein
    1 Replies
    Last post by magicalclick
      • Using Excel 2003, I'm writing what should be a quick application using VBA to open a series of Excel files and perform nearly 800,000 calculations (sad, but true). Typically, I use the Workbooks.Open method, either preceeded by Application.GetOpenFilename so the user can select the file to open or without where the filename is generated programatically. I'm running into Error 1004 (applicati
  • Sorting cells in a spreadsheet by colour
    by Josh Ord-Hume
    7 Replies
    Last post by crainsworth
      • My apologies if I am asking this question in completely the wrong forum. I am trying to create a VBA macro that will order data in an Excel spreadsheet according to colour (so that like colours are all grouped together). I wonder if somebody would be kind enough to spend some time explaining how to do this to a more or less complete VBA novice! Many thanks... Josh Ord-Hume
  • Renaming files with VBA
    by DJRave
    2 Replies
    Last post by DJRave
      • Hey there, I'm a rookie in VBA programming and I've got a problem that I want to solve with a VBA script. I've been trying to rename files I receive and after this import them in Access. I have a script that imports the files but the renaming is a problem. The filenames change every month. Further the number of files I receive varries between 70 and 80 a month. They have long filenam
  • 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
  • Inserting a row in VBA
    by KenCubs
    8 Replies
    Last post by KenCubs
      • When I insert a row from Excel in my spreadsheet, the formulas (from the columns that have formulas) are copied from the prior row (with addresses properly changed) to the new row. When I insert an entire row from VBA, nothing is copied. Does anyone know what I need to do Thanks, KenCubs
  • run a batch file with excel
    by gr44gs
    2 Replies
    Last post by gr44gs
      • I want to run a simple batch file (runBFI.bat) in excel. How do i get vba to pause while the batch file is running. I can get the batch file to start, I think. Sub Run() ' ' Macro2 Macro ' Call Shell("W:\Work\BFI\BFIResults\Copy2of05455100b\runBFI.bat", vbNormalFocus) ' End Sub
  • Timer on macro execution run time
    by une
    8 Replies
    Last post by Andy Pope
      • I have written some text analysing code that takes a long time to execute if the text selection made by the user for analysis by the macro is too large. Therefore I would like to add the following functionality to the macro; If after 15 seconds of execution the macro has not completed, I would like execution to halt and output a message to the user asking them to reduce the size of the sele
  • VBA Excel - Getting file Extension
    by ajliaks
    4 Replies
    Last post by ajliaks
      • Hi guys, I am looking for a VBA Excel function which lets me change the name of a file without oppening it. (any file, not only office). for example if I have the file "myDocument.doc" I want to call it "myNEWDocument.doc" without oppening it. If there is not such a function, what I will do is: Opening the file Saving the file with the new name Killing the fi
  • Run Time Error 9 when Calling a Userform
    by Joe Dawson
    6 Replies
    Last post by Joe Dawson
      • Hi folks, I am getting a run time error # 9 when I run a macro that calls a Userform or when I try to run code in a Userform module. The code performs beautifully on my computer, but it did not work on a coworker's computer. It ended up working on 3 out of the 5 computers I have tried it on. I have tried changing security settings to low, and a bunch of other stuff, but I cannot get the code to r
  • Hello!!! I want to know how to find a string in a Cell
    by JGttttt
    3 Replies
    Last post by JGttttt
      • I am Importing .csv file into a spreadsheet. There are certain text string values within a column and muliple rows. I need to check to see whether or not that value is there and then use that value to move data in other columns. I am running a Do Until loop that cycles through all the data on the sheet until a null value is found. I'm then running If then conditional statements that checks to see
  • Trouble with Word
    by Anonymous584592
    1 Replies
    Last post by Eric Jacques
      • Hello, I'm having trouble with weird characters popping op in MS word. When I hit <return>, Word inserts a character that somewhat looks like a 'normal' (not capitalized) <q> but longer and with an extra vertical line behind the first one. Also, the little circle to the left of the stick is black. I can't copy-paste it so I include a description. Also, for every <space> I ente
  • How do I display the same modified embedded chart each time?
    by Steve. S
    3 Replies
    Last post by Steve. S
      • How do I display a modified chart when a command button (cmdShowTemp) is clicked on a worksheet I used the code generated from a macro I recorded creating a chart using the wizard - using the data and making the changes I would like to see i.e. wider chart area, fill color etc, for this command. But I notice in the code the line Charts.Add, which I assume is why every time this command is clicked
  • Empower program software keys
    by abzA
    4 Replies
    Last post by Microsoft Empower for ISVs Tea
      • I recently signed up to the empower program and received the software yesteday. I expect that my membership id has been activated but msdn does not recognise it and so I cannot access the keys to install the software. I have type in my name, email address and membership id and am getting the " The subscription information you have entered is not valid." error message. Has anyone
  • How can I use a variable in formulaR1C1?
    by lyp_sj
    3 Replies
    Last post by Andy Pope
      • Hello, I'm trying to use .FormulaR1C1 as below. "K" is a variable. How can I write the code if I want to build "K" into the formula Thanks so mcuh! cells(j, lastcolumnCAGR + 2).FormulaR1C1 = "=RC[-1]^(1/k)-1" B.regards/Yaping
  • Newbie in VBA Drag and Drop..
    by den2005
    8 Replies
    Last post by den2005
      • Hi, Do not know if this is possible drag and drop effect of items in dropdown control inside a word application The task is to import and export data from and to database, but user can select from a list columns what they want to add, there will be a dialog will appear and allow user to select data to be included in a word document, how can this be done Thanks in advanced. den2005
  • Live Communication Server 2005 SP1 - Specified backend for the pool is current in use
    by Jensan_Ahsay
    7 Replies
    Last post by Peter Gu
      • Hi, I have installed the Live Communcation Server 2005 SP1 on my x64 computer with Windows Server 2003 R2 SP2. I found that i have given the wrong name for the DNS, and therefore i am trying to re-install it. However, when doing the step "Create/Upgrade Existing Pool", it gives the error "[0xC3EC78BA] Specified backend for the pool is current in use". The error is unders
  • text parsing in excel
    by Derek at Potters Clay
    3 Replies
    Last post by Anonymous
      • I am collecting data that another person has done in excel to be used in a access database. The problem is that a lot of the cells have 5 spaces before the actual text. how do i write a macro to first check if there is a space at the beginning and then to delete the spaces. If there is a space, it is always 5 spaces.
  • Does Winqual accept WER reports from Vista systems?
    by Claus Brod
    14 Replies
    Last post by Jason Hardester - MSFT
      • Hi all, we recently registered for the Winqual site. Reports are coming in about crashes in our application which occur on Windows XP systems, so it seems like the whole registration process worked as expected. However, we also ran our application (same version as on XP) on Vista, and provoked several crashes (same type of crashes as the ones on XP) there - but don't see *any* reports on the Winqu
  • .mdmp files not being created
    by David Ching
    14 Replies
    Last post by JPSA
      • Hello, Under what conditions is the .mdmp file created or not I have written an app that (deliberately) dereferences a NULL pointer, but the generated error report does not have the "Files that help describe the problem" section when listing the report from the Control Panel "Problem Reports and Solutions". Viewing other reports that had been put there, some of them have the f
  • Exporting data to multiple textfiles
    by DJRave
    0 Replies
    Last post by DJRave
      • Hey there, I've been trying to export data from one table to multiple textfiles. This should be done based upon 2 fields in this table. I have tried modifying an example that I found elsewhere but it returns this error as I run it: Error '3027' Cannot update. Database or object is read-only. I want to create a seperate file for every product for each supplier so something has to be ad
  • Setting properties
    by une
    4 Replies
    Last post by une
      • It seems that there are two ways to set a property. Using the example of a label on a userform, the property for it's initial caption and colour can be set by editing the appropriate fields in the properties window. That is easy, but these initial settings do not show up in any code on the userform. How could the initial settings for the caption and colour properties of the label be set via code i
  • 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
  • *** How can I add module code to a specific module? *** NEED HELP !!!!
    by sydney2000
    4 Replies
    Last post by NWAprog
      • Hi, I am currently working on an Excel Workbook where I have added a brand new code module called "Calculations2007". This module (*.bas) file contains several new functions. I have been searching on the web on how to deploy this new module in my workbook to a group of production workbooks. Basically I need this new code to get to production. I have gotten to a point wher