Programming

importing multiple text files into Excel with corresponding filenames
Dear members, I need to import 100+ text files into Excel. In addition I want EACH Excel column to show corresponding filename too (where the data comes from). How do I accomplish this? TIA ... 3 Feb 2010 06:10

open text file, get file from directory, update file
Hi Diana This should do what you want to do. It assumes you are wanting to use the first field in the current file as the criteria for the CSV file to open. Take care Marcus Option Explicit Sub OpenCSVFile() Dim sPath As String Dim sFil As String Dim strName As String Dim myRow As Integer Dim PNa... 3 Feb 2010 00:45

Paste Value Toolbar Icon
Can you call the PasteValue Toolbar Icon in a macro to execute. Bottom line I am trying to Paste Value and still be able to Undo if needed. Thank you, Steven ... 3 Feb 2010 11:44

Found the answer...
I found the answer. I need to dim as "single"... "laavista" wrote: I need to store the value of a percent in a variable. The value in the cell is 48.4%. If I change the format to a number it's 0.484320557491289 I've tried dim ThePrecentage as long (I get a value of 0) d... 2 Feb 2010 22:27

Run Time Error on trying to save workbook
This code worked perfect when it was in the User Form Code Window, but I moved it to a module and I get a Run Time Error "424' Object Required Code in the User Form Window -------------------------------------------------- '******************************************************* 'Save Installer Forms 11 Cont... 3 Feb 2010 00:45

RefEdit in UDF ?
Hello, I often use this simple UDF: Public Function RANDNAME(ElementList) Application.Volatile (True) RANDNAME = WorksheetFunction.Index(ElementList, (Rnd() * WorksheetFunction.CountA(ElementList)) + 1) End Function which provides a random text element from a list (named range). It works fine. ... 3 Feb 2010 10:35

Need a way to verify a string is present in 1-column array?
I need to verify than an operator string (part number) input is valid from a predetermined listing of "acceptable" part numbers without getting #N/A error. Help! ... 2 Feb 2010 22:27

On/Off control?
Hi all, Does exist a VBA control that helps me run a "thread/subroutine" temporary for a determined period of time, limited let's say by two events: OnClick(to start it) and OnRealese(to stop it)? I created a VBA subroutine that helps me save automatically and gradually values in Excel as long as I'm typin... 2 Feb 2010 17:30

formula to place real time in a cell when data entered in an adjac
I'm not sure which column you are concerned with so I assumed Col. A is where users enter data and Col. B is were you want the time stamp to go in, right. This macro should be placed in the worksheet module your users will be entering the data. Make sure you format Col. B to the time or date format you want t... 2 Feb 2010 17:30

HELP: Populate Excel FORM from Access - Pull from multiple rows
Hi All, I know how to pull data from access and populate fields in excel userform when I have only one row to pull from for a particualar Student_Id, BUT I am having issues with pulling data from multiple rows for the same student( if the student has multiple courses, it is displayed in multiple rows in a ta... 2 Feb 2010 17:30