Search results for query: *

Thanks for your constructive criticism. I have been successful with the following code: (I am moving the most recent file to another folder, where I am then opening it). [code]Dim FSO As Object Dim FromPath As String Dim ToPath As String Dim Fdate As Date Dim...

Thanks. I did some research, but I am still having an issue with the actual code. I ran across some code, However, I am having an issue pointing it to the right folder. Application.RecentFiles(2).Open

I am creating a job to open the most recently dated file within a specific folder. The files have a naming convention of "filename.yyyymmdd.xls" Looking for code to aid me in doing this. Thanks, Belstoy

This issue has been resolved off-line. Thanks!

Hello, I am attempting to close Excel through Access with an Auto_Exec Macro using the RunCode option. Initially the code in my module was as follows: Sub test() Dim y as Object Set y = GetObject(,"Excel.Application") y.DisplayAlerts = False y.Quit Set y = Nothing End Sub I could run...

Issued Resolved! I changed the sub to a Function. Belstoy

I am trying to run the following code via a macro command, but I am not having any luck. Which command should I be using? Runcode or something else? [Private Sub cmdExcel_Click() On Error GoTo Err_cmdExcel_Click Dim oApp As Object Set oApp = CreateObject("Excel.Application") oApp.Visible =...

Worked like a charm!! Thanks Skip. Brilliant!

Yes, the files would all be in the same folder and there would be no other files in the folder.

The design of the template is per a client's specs. There needs to be an empty row between each branch's data in excel. On the most basic level, I need to know how to open several files, no matter how many there may be, without having to identify them by their exact name.

Hello, I need a code to open several xls workbooks and import the data from all those workbooks into one xls template (with a row between each set of data). File names are similiar, but could be a different number of files each run. See File names below: RPT_BRANCH_663 RPT_BRANCH_731...

Thank you both for your guidance and advice. Belstoy

Thanks all, This is very helpful!

I am looking for a way to name a sheet in an Excel Workbook without having to identify the sheet as "Sheet 1" or "Sheet 2" etc... This job will be on a loop that is naming multiple sheets using values within cells. Is is possible to name a worksheet just by identifying it as...

Yes, problem is solved!

SBerthold, Your code did work. I thank you. Belstoy

Thanks so much. This is extremely helpful. I have finally made it work. Thanks again!

Can you show me how exactly how that code should look using MyFile? [MyFile = Dir("C:\My Documents\File2*.xls")] [Dim fso Set fso = CreateObject("Scripting.FileSystemObject") fso.MoveFile "C:\My Documents\MyFile", "C:\My Documents\Sales\Processed2.xls"] Thanks, Belstoy

Thanks, I am actually just trying to move one file. It's just that the file will always have a different data extension on it. Example: File2120106 or File2010107 (that's why I was using the wildcard). If I use the DIR function: [MyFile = Dir("C:\My Documents\File2*.xls")] Can I use the...

Thanks, I am rookie when it comes to this stuff... I am still having some issues. Is there another alternative? My system doesn't seem to respond to this code. Thanks for your help! Belstoy