Search results for query: *

I was hoping to do the conversion, and the reading, from within the VBA program.

Many apologies, but what I was hoping to do was convert the PDF file to some readable format (TXT,DOC,XLS) that I could then read via my VBA program. I know that the formatting would be different, but I can search for specific strings and likely find what I need. 3rd party programs exist that...

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

Good to know - thanks very much.

Thanks guys for the responses. Column F is where the user enters items to search for in a file defined later in the program. If for whatever reason the user has cleared column F, I need to display a message that no items were found. 5000 is an arbitrary number of items that I know will not be...

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...

They don't - they're just the index of the selected items. Thanks.

Thanks - that worked. I couldn't figure out how to get information back from the _Change event. I guess a label on the userform is the only way. I used a space for my weird character.

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...

Thanks very much - fso worked. Paul Hudgens Denver

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...

That works - thanks! Paul Hudgens Denver

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...

Many apologies, I have just figured out what the problem was. I was not including one very large folder that I intended for the program to ignore. The folders to be ignored are harvested from a listbox of all available folders. The user selects those to ignore. My bad. Again, many apologies...

Here you go. The two strings (folders) I'm trying to match are: R:\MEM\CurrentProjects\Noble\Larkridge_MA03-09D\OffsetWellData & R:\MEM\CurrentProjects\Noble\Larkridge_MA03-09D\Logs\FMI The program is finding matches for both, but not skipping them when it does, as it does do when using the 3...

Yes - I find no discrepancies.

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 have them so that the dialog opens in the D drive, rather than some other obscure place, to make navigation easier for the user. Is there a way to make the GetSaveAsFileName dialog prompt for overwrite if the user selects an existing file? As it is, VBA just overwrites the file without...

That worked - thanks very much.