Search results for query: *

I know this is likely a stupid question, but does anyone know of a way (3rd party software?) to read a PDF file on the fly via an Excel 2007 VBA program? I realize this will likely require conversion to some other file type. Thanks, Paul Hudgens Denver

I am using the following code to define a range in Excel 2007 VBA: With ThisWorkbook.Worksheets(MainWks) Set List = .Range("F3", .Range("F5000").End(xlUp)) End With This works fine if there are any non-empty cells in the range from F3 to F5000. If there isn't, List will become the first...

Does anyone know of a way to determine the order in which items in a Listbox were selected by the user?

Does anyone know of a way to determine the order in which a user selects items in a Listbox in Excel 2007 VBA? I know how to determine which items have been selected, but I'm not sure how to determine the order in which they were selected. Does it require a multi-column Listbox? THanks, Paul...

I'm writing data to text files from within Excel 2007 VBA that sometimes includes special characters. In the resulting file, which is being saved as a txt file, the special characters are being converted to ASCII characters. I have to go in and manually change the characters back and save the...

I have tried both the FileCopy and fc.CopyFile methods to copy files between folders using Excel VBA 2007, both work great - unless the file being copied is already open. I can't find code that allows me to check if a file is open before trying to copy it. Does anyone know of any such code...

I'm using the following code as part of a recursive subroutine to find files in all subfolders of a user specified intital folder. Set f = fs.GetFolder(FolderSpec) Set fc = f.SubFolders For Each F1 In fc 'ChkFldr = FolderSpec & "\" & F1.Name 'For i = 1 To...

I am using the GetSaveAsFileName method in Excel 2007 VBA to allow the user to navigate to and specify a folder & file that will be used later in the program for output of text data. Following is my code: With Application FileName = .GetSaveAsFilename(Filter, FilterIndex, Title)...

Access 2007 VBA does not recognize the GetSaveAsFileName method that Excel VBA does. Nor am I able to find a way that Access VBA allows a user to browse for and select an existing file, or specifiy an entirely new file, to be used for outputting text data. As far as I can tell, the FilePicker...

I'm using the following VBA code in Access 2007 to reference a user selected field. The field that the user selects is placed in the string variable: ThisField. Both the field and it's associated table have been determined to exist. I get the error message: "Item not found in the collection."...

In MS Excel 2007 I can place a button on a worksheet and then assign a macro or module to that button. I'd like to do the same thing in MS Access 2007, placing a button either in the main window area or on the toolbar, but I'm not seeing a way to do that. Can anyone provide some insight...

I'm quessing that there is no simple way in Excel 2007 VBA to move a folder and all it's contents (including all potential files and sub-folders) to a new location as a folder under an existing, user-defined folder. I found the writeup on Tek Tips about the MoveFolder function, but that assumes...

I've done some investigation of running VBA in OpenOffice and can't get a feel of where things stand. Does anyone know if OpenOffice Excel can currently run VBA programs created on a PC? Thanks for any help, Paul Hudgens Denver

I'm hoping to find a way to access an Oracle database on a UNIX machine via VBA. Does anyone know if it's possible? I see that there are conversion tools for converting VBA to Python and have heard that Python can access Oracle. Does anyone have any experience along those lines? Thanks for...

I'm using the VBA Sort routines to do 3-level sorts of 2-dimensional worksheet tables of data in Excel 2007. This works well, and requires a minimum of code. I'm wondering if there are similar VBA routines to sort multi-dimensional arrays of data, ie data that has not been written out to a...

I'm wondering if there is a way to create an input area on User Forms in Excel 2007 VBA that would be sized and populated depending on user input in other areas on the form. It would be like a mini spreadsheet with 1 or more lines, scroll bars if needed, in which the user could arrow up and...

I have a vague recollection that Excel VBA does not do sorting. Is that why when I run the following code: For i = 0 To iTotalZones iOffset = i * 3 With Workbooks(ThisWkBk).Worksheets("Operators") Set SortRange = .Range(.[A2].Offset(0, iOffset + 1), .[A2].Offset(0...

I'm using the following code to try and define an offset range of cells, but VBA is not accepting the syntax. VBA accepts the WriteCell definition but not the Opers definition. I get a "Expected list separator or (" message at the . following "A2". Enclosing the "A2" and/or "A50000" in...

I am filling a ComboBox on a user form based on entries made by the user in another page on the same user form. Once the combo box has been loaded, I would like the user to have the ability to edit those entries, line by line, if needed. I'm not finding a way to do that in a VBA combo box...

The following code triggers upon any change in the textbox "MinusICells", including deleting the existing value. I'm trying to get the code to trigger only when the value is actually changed/updated. Private Sub MinusICells_Change() Dim ic As Integer, iCount As Integer, jCount As...