Search results for query: *

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

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

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

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

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

I am attempting to move a file and rename it. The code I am currently trying to use is: [My.Computer.FileSystem.MoveFile("C:\My Documents\File2*.xls", "C:\My Documents\Sales\Processed2.xls")] I am getting a compile error. Any thoughts?, please advise. Belstoy

I am attempting to move a file and rename it. The code I am currently trying to use is: [My.Computer.FileSystem.MoveFile("C:\My Documents\File2*.xls", "C:\My Documents\Sales\Processed2.xls")] I am getting a compile error. Any thoughts?, please advise. Belstoy

I am currently trying to write code to open a file in excel that may or may not have a date stamp. Is there a wildcard I can use to open this file whether it is named "Status File" or "Status File 013107". I am currently using the following: [Workbooks.Open Filename:="C:\My Documents\Status...

I am trying to take a date format and convert it into text using a query. I have an automated process which sends an excel file out when done. The date format in the excel file is appearing as "00-Jan-00". Any thoughts? Belstoy

Hello, I am currently trying to create a cell with a 30 character max. I am then saving the spreadsheet to a text file. This field in the text file needs to be 30 characters long no matter if I type in 10 characters or 25. Thanks, Belstoy

I received an external spreadsheet from a customer with a "First Name" and "Last Name" column. It appears at the end of each cell there are invisible Hexadecimal characters. How can I remove them? Belstoy

Hello, I received an excel spreadsheet which contains First Name and Last Name columns. It appears at the end of every name there are invisible hexadecimal characters. How can I remove them, keeping in mind all Names are different lengths? Belstoy

I apologize, this seems like it should be easy, but I'm new to this.... I have a form which folks are entering info to create a db. I have a combo box with "Company ID" for folks to choose the appropriate ID on the form. The "Company ID" combo box gets its data from a separate table; "Company...