filename=

I have a folder that is a template for multiple forms. I wrote a code that open the forms and publishes to another location. Works fine. My problem is that since this is a template that my users use to make a new file the location changes The area in red font is my issue. my simplistic...

hi , i currently use the following code:- Sub PrntEU()' ' PrntEU Macro ' print as PDF TimeSheet & EXP ' ' Range("A1:J22").Select ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "C:\UsersTimesheets\To Be Approved\TSheet WC 11-02-2019.pdf" _ ...

I have 4 workbooks with several worksheets (the names of the worksheet range from 0801 to 0899, some also have 081A, 082B etc). Not all worksheets are in each workbook. These workbooks are named AvailFunds, Detailed AP Transactions, JVTransactions & Encumbrance. I want to have several...

When I open a file through a macro, it doesn't show up in the recents. How can I make it show up? Sheets("RAW DATA").Select Range("A2:K2").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Workbooks.Open Filename:= _ "\\blah\blah\blah\Elimination...

Hi i am looking to save quotes, and name them the clients address and date. Any advice on this code? cheers Sub Save3() Dim filename As String Dim Path As String Dim path1 As String Dim path2 As String Path = "C:\Users\James\Documents\Excel Test Folder\Quotes PDFs Test" path1 =...

Hi I have a number of files saved each day, with either the current date or previous working day date in the filename. To open yesterday's workbook is now no problem: Workbooks.Open Filename:= _ "Z:\Secondary Market\Pricing\Daily Index Levels\Index Levels " & Format(Now() - 1...

Hi Guys, Very first time using VBA - complete Newbie. I'm using the below code to basically organise and copy data into a monthly master data sheet. I would want to build in the control to prevent duplicate values to be posted in the master data with an error message. Appreciate your help Sub...

Hello, Why doesn't this work? The error is in the line that starts with ChDir abc & ""... abc = "C:\a\b\c" f = Range("A1") Sheets("1").Select ChDir abc & "\" & f & "\" & "\g" ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "a" & "_" & f & "_" &...

Hello! I have a list of file paths in a workbook, in cells A1:A307. I would like to open some master data files, then open the files listed in Column A one-by-one, update formula values that are referring to the master data files, save them, and then close them. If the file is unable to be...

Hello! :) I have a number of file paths listed in Column A of Sheet1 that have to be opened and saved daily. There are formulas in these sheets that are linked back to other data sheets that should remain open the whole time. However, the current macro I have fails to a full stop if one of the...

https://www.mrexcel.com/forum/excel-questions/580779-switch-open-workbook-using-partial-name-wildcard.html I am not comprehending how to add the fuzzy criteria to my code. Any help would be greatly appreciated. Windows("Book1").Activate ActiveWorkbook.SaveAs Filename:= _ "Daily...

Hi Gurus I have recorded a macro and I need help to fix some of the code. Sub ConvertExcel()' ' ConvertExcel Macro ' ' Workbooks.OpenText Filename:= _ "D:\Work\2017\June2017.txt", Origin:= _ 437, StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _...