Microsoft ISV

Page 124




  • Topics
    Replies
    Last post
  • Adding a drop down to a excel sheet.
    by knuckels23
    1 Replies
    Last post by ADG
      • Hi Guys, I am new to VBA. Based on a keyed in text, I need to populate a drop down list in a excel sheet. I was able to populate the Drop down list in the design mode. But i dont know how to populate it Dynamically for different texts. I would like to maintain the data in a seperate sheet or in an access database. Could any one please provide me with some sample code for both
  • Projects, objects & modules
    by une
    14 Replies
    Last post by une
      • I started learning VBA in MS Word yesterday. I have some programming experience in C++ and Java. I am trying to understand how the environment is structured and what Projects, Objects and Modules represent. For example I recorded a few macros using the macro recorder and then opened the VB Editor to see what was created. I notice that under "Project" are 3 folders. One is named
  • Macro that deletes itself after running
    by GB Allan
    3 Replies
    Last post by GB Allan
      • Hi, I created a macro that runs a routine on other spreadsheets and copies them into the workbook, one at a time (the same workbook that contains the macro). I have a small on-open routine in the macro spreadsheet: Private Sub Workbook_Open() Sheets("DATA").Select Range("A1").Select Sheets("INSTRUCTIONS").Select Range("A1").Select End S
  • running webscrape on workbook open vs regularly gives different results
    by Boris Yeltsin
    0 Replies
    Last post by Boris Yeltsin
      • Hi, I built a web query that pulls the date from an excel cell that has today()-3 in it but when I run it through workbook_Open() it returns the default information on the webpage (todays information) and when I run it at another time it works fine. Could this be because excel hasn't updated the cell to turn =today()-3 into the date for 3 days ago How can I get excel to update the cells bef
  • LCS 2005 SP1 Server-Side Contact Lists Not Populating within Communicator 2005
    by KCrockett
    1 Replies
    Last post by MS ISV Buddy Team
      • I am having trouble creating server-side contact lists for my employees using Communicator 2005. We have an LCS 2005 SP1 SE virtual test environment. All my users are LCS enabled (right-clicked on OU within AD to enable). Background knowledge... Contacts.txt looks like... msRTCSIP-PrimaryUserAddress sip:u ser1 @domain.local sip:u ser2 @domain.local sip:u ser3 @domain.local ACESFile l
  • How to allow cookies for Windows Live ID
    by Ralph Burns
    6 Replies
    Last post by Coqui88
      • Help me!
  • Dynamic Lists in Excel
    by SHolst22
    4 Replies
    Last post by suna2006
      • I created a list in Excel as described in http://www.contextures.com/xlDataVal02.html I want to have the following structure of dependant list. List 1 List 2: Contents dependant on List 1 List 3: Contents dependant on List 2 List 4: Contents dependant on List 3 List 5: Contents dependant on List 1 I created List 1-4 using the method described in http://www.con
  • Connecting to a csv file using ADO
    by Keithyboy1
    0 Replies
    Last post by Keithyboy1
      • Hi All, This is more of an issue with Active-X Data Objects, rather than VBA, although I'm developing in VBA. I've got this really wierd and obscure issue when loading a txt file into an ADO Recordset. For some reason, some of the data is missing in the recordset completely and there seems to be no logical reason why. I've looped through each record in the recordset printing the resu
  • vlookup
    by eds000
    2 Replies
    Last post by Peter Mo.
      • I am using vlookup and I want to obtain the value in column B for the second occurance of the lookup value This code comes up with error DestCity = WorksheetFunction.VLookup(" Line#1 CITY ", Range("CPARSdata"), 2, 0) _ And WorksheetFunction.VLookup(" Line#1 CITY ", Range("CPARSdata"), 2, 0) If I use the first part before the "And" it wi
  • Extracting text from a text file
    by DracoM
    2 Replies
    Last post by DracoM
      • I have a text file which begins with a few lines of comments and then is followed by the text string ' FESTWERT' I want to extract everyting from the first instance of 'FESTWERT' till the end of the textfile and put this in another file. Can somebody help me
  • 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!
  • Macro to Delete Rows
    by GB Allan
    6 Replies
    Last post by GB Allan
      • Hi, I am writing a macro that I want to do the following with: 1-Sort spreadsheet by column J. 2-Search for the first instance of the term "unbilled." 3-From that point and down, delete all rows below. 4-Delete specfic columns. I'm having trouble with steps 2 and 3 - the search works, but for the deleting of the rows, it's picking a specific row range. I want it to del
  • Importing multiple textfiles into Access
    by DJRave
    4 Replies
    Last post by DJRave
      • Hi, For a project I need to import multiple textfiles into Access. Between 40 and 50 files everytime. Using the wizard wouldn't be a great sollution in this case. I've tried to use the transfertextmethod but the only problem is that I need to specify the exact location of all files in VBA but since the number of files varies every month this creates an error when a file isn't present that m
  • IsError function from VBA6.3 to v6.0
    by SuzukiBandit
    8 Replies
    Last post by SuzukiBandit
      • Hi All, I'm having problems with a small VBA script that I wrote in v6.3 but need to implement in 6.0. Excel 2002 -> 2000. The following code works fine in the later version: For i = 2 To LastRow ' select the next row based on loop vString = "A" & i If IsError(Application.VLookup(Range(vString).Value, vRange, 31, False)) Then Y = "NEW" Else
  • Worksheet Object - Update cells
    by GB Allan
    4 Replies
    Last post by GB Allan
      • Hi, I have the following routine to update cells H5 and O5, depending on the content of cell A5: Private Sub Worksheet_Change(ByVal Target As Range) Dim MyVal As String MyVal = Range("A5") Range("H5,O5").FormulaR1C1 = MyVal End Sub It works great. The only problem is, I want it to work as well with each of the other cells. In other words, if
  • Strange behavior when setting controlsource property in report
    by JLS123
    1 Replies
    Last post by JLS123
      • I'm using Access 2007 and in Report_Open I am trying to set the controlsource property of various fields. Example: Private Sub Report_Open(Cancel As Integer) Me!F01.ControlSource = "Quantity" Me!F02.ControlSource = "Total" Me!Major1.ControlSource = "=Sum([Quantity])" Me!Major2.ControlSource = "=Sum([Total])" End Sub where F01
  • How to generate a Desktop Alert programmaticaly
    by vikalp
    0 Replies
    Last post by vikalp
      • Hi All, Sorry if I am asking a basic Question ,How can I can generate a desktop Alert Programmaticaly .I want to give a alert when ever a "Application_ItemSend" event is triggred.
  • Loops using Index and LinEst functions??
    by chilehed
    0 Replies
    Last post by chilehed
      • My worksheet has columns of paired x and y data, the number of rows and columns can vary. I need to do a first-order regression on each set of data and assign the results to variables for further calculations. I know that I can use the INDEX and LINEST functions directly in the adjacent cells on the sheet, but I really need know how to automate it because this is only a part of a much larger data
  • Starter
    by suadi
    1 Replies
    Last post by Shasur
      • Dear VB gurus Im desperately in need of learning VB for the purpose of progamming for my Excel needs.Please guide me how to start.
  • Sub or Function not defined
    by artist0
    1 Replies
    Last post by Andy Pope
      • I came accross a strange problem. I tried to record a macro where I used Solver. After I tried to run it, I was given an error message: Compile Error: Sub or Function not defined. The function where VBA stops is "SolverOK". It is not a macro that I coded, I recorded it in the excell sheet. Thanks for any advice. Lubomir ------------------
  • Data in combo box convert into date
    by alexthian
    2 Replies
    Last post by alexthian
      • I'm using VB6. I create three combo boxes which represent day, month and year. What I want to know is how to convert this three data into date, which will save into Access database. Any advice is appreciated.
  • Operating on arrays? Possible?
    by cfel
    3 Replies
    Last post by Cringing Dragon
      • Hi all, I'd like to perform some simple arithmetic on all the numeric values in a column in one workbook and copy the results into a column in another workbook. I would prefer to do this within the macro that is already running, instead of writing the formula into each cell. Currently, I am just running a FOR loop for the length of the column and performing the arithmetic and copy/paste act
  • Remote MS Access Database connection On Web
    by Danish_ara
    3 Replies
    Last post by Danish_ara
      • Hi, I am going through some serious issues while connecting to ms access database on web. My database is on a shared hosted site. I am trying to access the db.mdb file. I can connect to the file correctly using the following syntax in asp 3.0. set conn = CreateObject("ADODB.Connection") conn.open "Provider=MS Remote;" &_ "Remote Server
  • 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
  • Checking the status of autofilter
    by pps!
    1 Replies
    Last post by Peter Mo.
      • I have an excel report on which i have to write the program for making formatting changes in that. But before that i want to check the autofilter (Selection.AutoFilter) status (whether on or off). Is there any command for this