Answer Questions

• Ajit_C# How do you test a user's input for alphabets?

  Hello programming gurus! Is there anyway to test if a user's input contains only alphabets Thank you! Hi again, You'll need to create a form with a textbox as you'll need to handle the keypress event of the textbox and thats something you can't do with an input box. You can't apply any validation with the input box until after you have the whole string input. Checking that a whole string only c ...Show All

• Doug2005 last Modified date in Excel spreadsheet

  Hello Can anyone help me read details about a current workbook. Bascally everytime an excel spreadsheet is opened I want to saved the last modified date to say Sheet1.range("A1") Thank you in advance. Hey man, The Workbook has a property named 'BuiltinDocumentProperties' that you can use to get pieces of information about the document. One of these is the Last Save Time Cel ...Show All

• Shrikant24227 Close excel

  Hi!! I've a problem. Need close excel when raise an error, but a don't know how can i do it. can anyone help me thanks. Regards. Hi there, Will the error be raised in your code If so, you can probably put an error handler in the appropriate place and call Application.Quit and this'll close Excel. Hope that helps, but sorry if it doesn't and I miss the mark completely. thank you very much!! it's just all I need. Than ...Show All

• The Villager Distributing a Macro across an organization - how to delete existing .bas files within a .dot file?

  I have been maintaining a large macro within my workplace.  It is basically a find and replace macro that let's the users easily create client documents.  It is housed within the Normal.dot template and contains a "MyName" module and "AcctMgr" module.  I have just completed an upgrade and I simply want to replace the "AcctMgr" module with a new one.  Replacing the whole Normal.dot file just causes too much pain for the person ...Show All

• TheBigIrishman Why Excel 2003 keeps PivotItems with zero record count after refresh?

  After a pivot table is refreshed, if some pivot item is no long exist in a pivot field, the pivot field drop selection still show that pivot item to allow user to select.  Selecting this kind of pivot item will lead to no data showing at all. This is no good. I perfer Excel will remove zero record count pivot item from the pivot field drop down selection box after a refresh. (I don't mind Excel keeping zero record count pivot item inte ...Show All

• mdreyerza Excel edit mode

  How can i detect "edit mode" in excel macros Thank's for idea(s)   Yes but Application.Ready is not an event !!! and tranfsorming a state reading in an event by a timer is ugly and buggen!!!! My AddIn is written in cpp and code is running even in "edit mode" so i have to know if the user is abled to do actions or not ! Any idea to resolve my pb   ...Show All

• SteveS 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 Coming back to this, the only thing I can think is that this is a Perl script but I hav ...Show All

• LadySQL so lost and buried in help printouts

  Hi- I don't know if this is the right place to post this very beginner macros question for Word for XP but I desperately need to get this done so here it goes... I created a form in Word 2003 and I created a command button that I call my help button. I also created a very basic macro which I need to run when you click on the help button to explan a specific part of the form. HOWEVER, I get the macro to run when I hit run thru the tools/mac ...Show All

• Gold333 custom toolbar error

  I built a custom tool bar for my applicatoin. It works ok on PC Excel. But I got an error message on a Mac Excel: Run-time error '-2147483640(-7FFFFFF8)': Method 'FaceId' of object 'CommandBarButton' failed If I comment out the        .FaceId = 642 Then the error message becomes Method 'OnAction' of object 'CommandBarButton' failed The original code in VBA look like this: ..............    Private Sub Cr ...Show All

• ... no and then!! Extracting Symbols from Word

  I'm trying to extract characters from a Word document which includes some Symbols (such as alpha, beta etc) When these characters are encountered (using the document's Characters collection) they all report their text to be "(". Any ideas as to how I can get the correct character values Current code is simply: Dim doc As Document Dim char As Range Set doc = Application.ActiveDocument For Each char I ...Show All

• Misbah M Hasan Openening an Excel file from within Project

  Does anyone know how to open and read/write to an Excel file from using Microsoft Project Visual Basic Thanks, Per our support engineer: Hi Mark, you can use excel automation from visual basic to open /read/write to an excel file. How To Automate Microsoft Excel from Visual Basic http://support.microsoft.com/kb/219151/ INFO: Using Early Binding and Late Binding in Automation http://support.microsoft.com ...Show All

• MichaelLatta Getting a checklist to report back only what is checked in VS 2005?

  Hi I am creating a web form inside of a master page. I am using the Multiview option inside the content handler. In one of my views I have 3 seperate checklists with multiple items in each. These are selected if applicable if they meet ceretain criteria. Once the form is completed it sends an email to the appropiate group. All that works except in the email it will only show the first item checked in each checklist and not any others. Is there a ...Show All

• CTEZ VB writing data to an Excel file

  I have run into a problem with what I believe is formatting my data that I am writing to my excel file with VB 6.0. Here is how I am writing now: Sub NestComplete() Dim ExcelSheet As String Dim RecordNest As ADODB.Recordset Dim CycleTimeMin As Integer Dim CycleTimeSec As Integer Dim CycleTime As Single TodayNestTotal = TodayNestTotal + 1 CycleTimeMin = Asabtcp1.GetDataWordM(1) CycleTimeSec = Asabtcp1.GetDataWordM(2) C ...Show All

• KoMas Novice VBA User needs help with using data from input box for Cell Find

  Hey all, what I'm trying to do is take data that is entered by the user in a InputBox and using it in a cell find. However, my code doesn't work. Any thoughts/ideas Thanks! Dim Message, Title, MyValue Message = "Which channel name do you wish to choose "    Title = "ChooseOriginalChannelName"    MyValue = InputBox(Message, Title)        Cells.Find(What:="MyValue", After:=ActiveCel ...Show All

• johnnym Hyper link Macro

  I am new to this stuff. I want to add hyper links to a series of numbers.eg 100 101 102 103 etc There is a number folder for each hyperlink in excel. So the 100 hpyerlink will open the 100 folder and so on. I can do i Macro to do one folder. How to i get it to do hundreds without repeating myself. Thanks for you help, cheers Hi, thanks for the information, worked fine. However i dont think you h ...Show All