Hello Everyone
the code below currently opens the worksheet "Element list - Export.xlsx".
Dim wkb2 As Workbook
Set wkb2 = Workbooks.Open("C:\Users\andym\Desktop\Excalibur Winner\ExcaliburProPlus\_ExcaliburDataConfig\Element list - Export.xlsx")
I need to run this code on other computers...
I found the code below but it is not working.
I am trying to find a code that will find a file utilizing where only the first two characters in the file name are know.
This is in Excel 2010. My file names will always be AA_MMM_YYYY.xlsx, BB_MMM_YYYY, CC_MMM_YYYY where the "MMM" changes
each...
Hi All,
Imagine I have 3 Workbooks open with File names ABC12345, DEF54321, GHI00000. These partial names are present in a column of an excel workbook say XYZ (ABC in A1 cell, DEF in A2 cell, GHI in A3 Cell)
I want a macro which can select(or activate) the respective workbook by reading the...
I need a way to insert the part of the file name after PO.
In the example below, 3351 is the work order number, between brackets is the customer name, then the description and then the PO number.
The problem is the PO number varies in length and could contain digits, dashes etc. so I need to...
I am looking for some code that would open the most recent file in a folder if the file name starts with a specified string (e.g. Testfileyyymmdd.xlsx)
I found this code that opens the most recent file, but does not take into account the filename:
Sub GetMostRecentFile()
'To use...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.