Answer Questions

• Marko Tekavc Syntactical error within For loop (VBA excel)

  Hi all Having problems trying to get the following peice of code working. It's basicaly being used in an excel macro to automate a manual process i do regular in work. Sorry if its very basic but ive only started out with VBA today! Sub calc_award_value() 'IF statement to calculate correct award amount based on yrs service 'feel free to add more awards if necessary i.e. 35, 40 yr! For x = 1 To 300 If (Range("F2") ...Show All

• Har_ish Excel VBA - Worksheet_Change problem?

  Help please ... I have a SUB called "ValidateStopDate()" that I need run when Range("F2") changes.  In my Worksheet_Change sub, I have: Private Sub Worksheet_Change(ByVal Target As Range)     Dim KeyCells As Range     ' The variable KeyCells contains the cells that will     ' cause an alert when they are changed.     Set KeyCells = Range("F2")     If Not Applicatio ...Show All

• Bill Moline VB Excel - userinput -> UserForms

  I have made a program that has to take userinput from Multipage UserForm and place it into a spreadsheat, the user wont see the spreadsheet, because in the end all the result will appear in a listbox in the Multipage UserForms last page. My questions: 1. If the user forgets to put information into a txtbox or a combobox, how can I get the program to tell it to the user 2. Two of the txtboxes the user has to put in values, and one of th ...Show All

• asmand Output excel file to PDF format

  Dear all, I am new to VBA. I was trying to output an excel file to PDF format, where i have my PDF printer installed as "Adobe PDF". When i run the script, i manage to generate a pdf file but i can't open it. It stated Adobe can't open the file due to the resaon the file type is not supported or the file is damaged. Below is my printout line. ActiveWindow.SelectedSheets.PrintOut Copies:=1, Preview:=False, _ ActivePrinter: ...Show All

• burning snow about listview in vba excel

  hi... can anyone help me..... How to highlight an item in a listview using a textbox or how to search an item in a listview then automatically highlight the item if found It's me again Derek, Derek the commands work well with the listbox but i am using listview. I hope you will still answer me.. Thnx again FSV... Hey FSV, Not to worry the same logic still applies. You'll still want to lo ...Show All

• Fairy 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

• sbaba13 VB Script Crashes Access When Exporting to Excel

  I am trying to solve a minor problem for a small school running Access 2000 on a network. The program runs well with several forms and reports. The problem is that one of the reports is exported to Excel. This works fine except when the database is moved off the network, the export process either produces an error message or crashes Access. The database filename is AA92603.MDB. When it is copied to the C: drive on a computer off th ...Show All

• Michael Shorten - MB Limited Problem with CWnd::RunModalLoop(DWORD dwFlags) in wincore.cpp

  Hello, We have created a VC++ application that has 2 menu options. - submenu 1 opens the VBA IDE - submenu 2 opens a Modal Dialog to execute a functionality (say FUNC1) Whenever we directly select submenu 2 the application executes properly. But the application hangs whenever we select submenu 1 (opening the VBA IDE) and then select submenu 2 (having the VBA IDE still open) On debugging we find that in the problematic c ...Show All

• Brian R. Bondy Runtime Error '1004': Copy of method Worksheet Class Failed

  I have a function designed to create a new worksheet by copying and pasting a template. It works fine for the first many sheets, but beyond a certain number of worksheets, it fails. I am confident that I have ample memory to continue creating new worksheets, however, at a certain point i get Runtime Error '1004': Copy of method Worksheet Class Failed . Here is the function I am calling: Function MakeNewSheet() As String Dim shtcount As Integer ...Show All

• Dopey Coder FIELD AUTO NUMERIC ALPHANUMERIC

  I need to know how convert a mixed field between text & numeric characters and do it autonumeric acording to the numeric part, it's possible with some input mask which one please. For example: 001TYPEA 002TYPEA . . . 00NTYPEA: COUNTING AUTOMATIC WHILE THE TABLE IS FILLED. The first part does the autonumbering of the string and the second part splits the string into the number part and ...Show All

• Ranjay Excel macro question - ref: sheets (hopefully a simple one!)

  Trying to debug a macro in Excel and it has an odd line. Could someone explain it to me please. "Sheets("comparative_report.pl reportNam").Select As you can't have a question mark in the name of a sheet - what's this all about Sorry if I'm being a bit thick but this is new to me. Thanks Damian Hi again, I see what you mean by a perl script now, the script 'comparative_report.p ...Show All

• hassanmushtaq Simple question on FrontPage / Internet Explorer

  I have just learning FrontPage 2003 using the Step by Step book. When I look at pages with ActiveX items in design view I see the item, if I switch to preview I dont see the item just the area it occupies. I suspect that I need to change a security setting in Explorer, but I don't know where to start looking. Can anyone tell me which setting needs to be changed and the likely consequences When I open will I ...Show All

• Stephane Tombeur Help: How can I deploy my VBA?

  I have VBA code for both excel2003 and Outlook2003. I'd like to know what tools I need to be able to deploy them. Hopefully I do not need to convert to .net My excel VBA is just code which "processes" data on a worksheet. I need to understand how to deploy it and once deployed, how it can be called (will buttons go along with it etc.) My Outlook VBA also uses custom toolbars...'twould be cool to be able to deploy those too. A ...Show All

• SunHunter Email from MS Excel

  With thanks to another poster I've managed to get the code below opening and sending an email from MS Excel. The only problem I'm having is I want the value from a particular cell in a worksheet to appear in the message body. This value is actually a formula and will change as the source worksheet changes hence it will differ each time an email is sent i.e. the value at time of sending will convey the message I require. My unsuccessful att ...Show All

• Andy Perkins Date Problem

  I need to gather yester days date to us in a few place in my script.   I thought it would be easy but the way I previously planned this out I would always have a problem with the last day of the month.   Can some help me out with an easily way to do this.   Below is the code I use for the current date, but how is the best way to get yesterdays date   I Need the it in the following format 12032005 Thanks! Dim varDay,varM ...Show All