Answer Questions

• epoc No-longer-unpredictable problem with DateAdd

  Can anyone provide some insight into this date problem I have a Date/Time field called AppointmentDate in a table. I have a form that is based on the table with a bound text-box called AppointmentDate (I let the wizard add it to the form and bind it). I also have a button on the form that, when clicked, tries to figure out the day after the one in the AppointmentDate field. As far as I see it, the following should work. Dim tmro as Date ...Show All

• JoshSommers Length of an Excel Macro?

  I am writing a macro but I'm not sure if it is getting too long or if there is such a thing as too long. This is what I am asking it to do: 1. open a text file and convert to excel 2. save the full file in a folder 3. delete some colums and records then resave in a new folder then resort the coulms change some data and save in a 2nd folder then close 4. reopen original file and delete different colums and save in a third folder resor ...Show All

• Piers Lawson Defining a range according to the number of responses

  Dear all, I'm a new user of Visual Basic (version 6.3) and need to write a Macro for use in Excel. I need the Macro to calculate Rank values for an unpredictable number of scores. The number of scores that need to be Ranked will vary and I don't know how to incorporate this variation into the Visual Basic Macro. In my current spreadsheet there are 11 scores (Sorted in descending order) in column DS (cells DS2:DS12). The Visual Basic cod ...Show All

• tessy Is an Excel bug that set PivotItem.Visible to true will generate 1004 Macro Error?

  In a Excel PivotTable, I want to programically hide or show some PivotItems of a PivotField.  To hide, it works fine (just set mPivotField.PivotItems("xxx").visible = False).  However, to show, it does not work: mPivotField.PivotItems("xxx").visible = True.  Program breaks with an error 1004, macro error. When try to record a macro for setting a non-visible PivotItem to visible, macros recorded is to use ...PivotItem("xxx").visi ...Show All

• Doug Woosley Event handling for dynamically created control on userform

  hi, I am creating few controls say a command button on an userform(which is created either during design time or run time). Now I want to add an event handled to this command button. How do I do it CreateEventProc adds events to controls on userforms I tried it but couldn't. I could see samples which add events to Class modules using CreateEventProc. But I couldnt find one for adding events to controls created on userforms. I am using excel ...Show All

• RichardX Count the rows

  Hi I got a problem. I am using msaccess to create using a wisard the controls for a field that is repeated in some cases in the database but i am only displaying those that are unique! The problem i have is that i am also traying to do a count on these unique fields that i have displayed. I try and do a count on the Control Source but i get a count of all fields in the that i have displayed. Instead i want a count for each unique. Any ideas h ...Show All

• Desoohn possible to access word vba via c/c++?

  hello all, i wonder - is it possible to manipulate the word document object model like word vba allows, but using c or c++ apis specifically, i would like to know if i can create a c/c++ DLL that is capable of calling word vba functions. i do not wish to use visual basic or c# your advice appreciated, ADC Sure you can, you need to import/reference the word COM object and then you can work with word ...Show All

• Mandana Closeing shared files

  Hello Yesterday I stack with a problem of opening and writing some information to  file in AD domainm which was open by one user. I noticed that when someone open a file, then I can not do anything with it untill the time when he will close the file. My question is : Is it possible to close such session to the file for this user thru the vb.net or cscript code My program need to get full acceces to some files and I need to be sure that all ...Show All

• Leonardo Cantelmo Macro to sort an Excel column

  Hello, I am trying to create a macro to sort a column starting at a cell activated by the user. I programmatically select the range of cells starting at the selected cell over which I want to do the sort on. But I am stuck on what to do for the following snippet of code: Selection.Sort Key1:=.Range(<something>) ... I don't know what to stick in place of <something> to represent the selected range of cells in the column ov ...Show All

• LearningASP.NET Error refencing DLL in XLA

  Hi ! I have prepared an MSI Installer for my XLA to be deployed on the server, the MSI contains all the DLL referenced by the XLA. The MSI runs fine but when I try to open Excel on that server it gives me a reference error, I have to *explicitely* go in VBA Editor and set the reference for the erroring DLL, after that the XLA works fine. The strange thing is that in the MSI I have set the path to D:\ Prog Files\... but strangely the MISSING ...Show All

• REDLINE Suppress Linked View Unique Record Popup

  Hi there im linking a view on an ms sql server to my access database using VBA using DoCmd.TransferDatabase acLink, etc.etc. How ever, I can NOT get the `Select Unique record Identifier` pop up to stop coming up when the link is being made. I dont care about needing a unique identifier, its a read only record source. The only way ive found is using sendkeys command to cancel the popup - however this can not be relied on, if it happens when the u ...Show All

• Colin Reid What's your experience with the buddy program?

  Started by admin at 03-28-2005 5:11 PM. Topic has 2 replies. 03-28-2005, 5:11 PM admin Joined on 12-16-2004 Posts 14 What's your experience with the buddy program We've already received a couple of posts on buddy experiences (thank you!) and would love to see more of them, so feel free to jump in and reply to this post and share yours! Thanks, Brenda [msdn/isv] ...Show All

• sanjeeva.s macro doesn't run on open

  i have a macro that does not run when the excel worksheet that contains it is opened. i have tried Private Sub Worksheet_Activate() and Private Sub Workbook_Open but neither will fire when i open the excel spreadsheet. my code is contained within the Subs what else do i have to do Hi Both the events you have tried to use should work. Check that the security settings in Excel are not preventing your ma ...Show All

• Kalagara pls, help me to write a macro

  I got 4 columns, 3 of which should be indicators for the 4th column (I want the values in the 4th column to appear automatically depending on the values of the cells in the previous 3 columns). Here are the values which should appear depending on the cell values in the previuos 3 columns: * ZAO * * ZAO+SC * * * ZAO+SC * * ZAO+ * ...Show All

• GSCVirus Excel VBA

  I am using a user-defined type. Is it possible to access the individual variables with an index number rather than by the variable name itself For e.g.: Type DescType PN As String Qty As Integer Check As Boolean End Type Dim DescVar as DescType I want to refer to var PN as DescVar(1) or DescVar[1] or DescVar.1 ,etc and not as DescVar.PN Thanks, enkay Hi enkay, Me is a keyword in VBA th ...Show All