fname

I have a macro that first opens a directory window where I store daily .txt files. I double click on the latest file and the marco imports it into Excel and continues. Been trying to find code that would at the start of the macro open the directory and import the latest .txt file. Here's what...

i have this code that will filter a row on my table named "Table5" i want to stop the code if the Field 2 has no data, is that possible? thanks!

I am trying to write some VBA so create a save as button that saves the document into the correct location and creates the correct file name... I am a bit of a VBA noob, I can do basics but this has me stumped!:confused::confused: Please see the code below that I have tried to butcher from...

I'm using this to loop through the selected items in a multi-select Listbox on a userform; With Me.ListBox1 For i = 0 To .ListCount - 1 If .Selected(i) Then Application.ScreenUpdating = False Sheet2.Activate...

Hi, When I run this code. My aim is to have a user be able to pull data based on their selected criteria from the inputbox from a closed file (which isn't going to be opened). That closed file is updated (with a new file name) each week, hence the user having to select the file initially to...

Hello, I have a macro that open a user form with few buttons and a has progress bar. The macro is working like this: - Button Browse = open Explorer to search for files to process (first open). - In the same time is counting the files (to be used for progress bar) - Button START = to run main...

I have code to export / copy sheets to a new workbook. The issue is, some of the color formatting is missing. Can someone help answer why? Sub Report6Export() Dim Fname As String, ws As Worksheet Dim Ary As Variant, tmp As Variant Dim i As Long Fname = "Review - " &...

Here's my code: Function Export() Dim Fname As String, ws As Worksheet Fname = "Vesting Review - " & Sheets("Instructions").Range("D5").Value Sheets(Array("VDR", "SP", "DDR", "VOR", "TDR")).Copy For Each ws In ActiveWorkbook.Worksheets With ws.UsedRange .Value = .Value End With...

Good Morning, Trying "in vain" to show the original file name in the "file name:" dialog box. Can anyone help? ================================ Sub RGH_SaveAs() Dim FName thisfilename = ActiveWorkbook.Name thisfilenameinquotes = Chr(34) & thisfilename & Chr(34) IniName =...

I'm trying to Save the current file, then Save As to a new filename (for the new quarter/period) prior to clearing the data from the previous quarter/period. I want the user to be prompted for the SaveAs filename and path, but I'd like a default filename to populate in the prompt window using...

Hello, I know my error must be easy to spot, but I've tried everything I know. I literally only have a command button and an Image in the Form and a simple graph in Excel. I want my "1 Gráfico" chart to appear in Image1 when I press the button (I'm spanish, that's why it's called like that :)...

I googled a tweak for the mac version of GetSaveAsFilename, but it was wanting to prompt the user to first resave the whole excel workbook with a new name before making the pdf, and it also didn't seem to work when I tested it on a Mac anyway. I can navigate Macs, so maybe it did work, but it...

I have a macro to export and save the table to a PDF. However, it is only exporting the data rows. The pdf doesn't show the header row and total row. Sub PrintMileage() Dim ws As Worksheet Set ws = ActiveSheet Dim tbl As ListObject Set tbl = ws.ListObjects(1) tbl.Range.Select...

Afternoon, I have the code in use shown below. Can we edit this code so upon the Macro button press it would then put the image into the cell as opposed to me manually doing it each time. Here is some info that might help you. Part number is always in Column & currently A3 then done the list...

I am stuck, have a table with [ID, Fname, Lname, Amount]. Need to create drop-down list showing [ID, Fname & Lname]; ID be returned to be used in other calculations. Is this possible in Excel or VBA?

Hi, I am using the Macro code shown below. Currently when i press the button a box pops up & i then need to browse to where the picture is. I would like to be able to press the button where this time when the box pops up just take me to the folder. The path for the folder is called...

Hi All, I found the following code form Jerry Beaucaire's website: CODE Option Explicit Sub Consolidate() 'Author: Jerry Beaucaire' 'Date: 9/15/2009 (2007 compatible) (updated 4/29/2011) 'Summary: Merge files in a specific folder into one master sheet (stacked) '...

This code saves me a 5 minutes several times a day. I fill in a stock acceptence document, export the data to another worksheet that summarises this data, save a copy of the acceptance sheet to a folder, then print the sheet. I'm using the range E11:H52, although the data is mostly not filling...

Hey community, I use userform where users can select workers name and gets details about him. I want to put chart in userform to show workers progress. But it shows only last result. it is not updating when i choose different worker. Any solution for instant update of chart result ?' Private...

Good morning. I need some help altering existing VBA. Right now, the code will paste under the last used row. I would like to modify this so that the copied data is pasted starting at B5 of the master, with each file pasting underneath. What I currently have is this: 'set to the current...