openfile

I've been toying around with Lists as my boss tasked me to update our data input from Excel. Lists is cleaner-looking and more corporate. I can get behind that. Thing is, in my Excel file, I used macros extensively, but one key element was to check in other sheets when data was entered, and if...

Hello guys, I written a code where it will open a file based on Prefix of a file name. But I need to open a file based on certain file name matches. Example: If file name is RSNOS_20200906_Summary and if RSNOS_Summary matches with the file name then macro should open the file. If file name is...

Hi all, I am new to this forum and this is my first post here since I have been searching through the web but cant find an answer:) I have an excel called NAME and the first and second column looks like the below table, essentially the name and date is used to construct a set of folders and the...

Hi What is the difference between them? Not sure why we have 2. I noticed there are many things like that SortField SortFields and OpenFile vs OpenFiles. Thank you.

Hello Again, I have adopted below code which I have found on the web but it is not working. What I am doing here is trying to do here is searching specific or part of file name of a PDF and open. Uptill searching is working but it is not opening the PDF file. Below is the script. any help is...

Hello, I have a case here, I want to open multiple text (TXT) files using vba macros, then smoothed the data first before being transferred to sql server, here's my code to open multiple file, but i still have problem in looping process.. the problem is, it's only open the first file and i...

I have a code below： --------------------------------------- 00 Dim filename As String 01 filename = "C:\ExcelVBA\test.xls" 02 Dim sn As Object 03 Set sn = Excel.Application 04 sn.Workbooks.Open filename 05 ' sn.Workbooks(filename).Close 06 Set sn = Nothing...