file1

I have a macro that will ask for a date to append 2 workbook names and copy their data into the current workbook. I would like to add the names (File1 and File2) to a table on a worksheet in the current workbook. So this table will grow as the workbook data is added incrementally. I am having...

Hi, i have the following: Sub fg()Dim WB1 As Workbook, WB2 As Workbook Dim WS1 As Worksheet, WS2 As Worksheet file1 = Sheets("variables").Range("A1") myFile = "C:\Temp\1\" & file1 & ".xlsx" Set WB1 = ThisWorkbook Set WS1 = WB1.Sheets("Sheet1") Set WB2 = Workbooks.Open(myFile) Set WS2 =...

My macro does things to a file, File1 - a file with a different name every day. Then it looks up some data from a tab in another file and uses that data to do stuff in the first file. At least it should. The ThisWorkbook.Activate doesn't make the macro stay focused on the first file. When it...

Hi all, I am currently in the process of trying to create a macro to run from my current workbook (file1) and be able to open an excel file from SharePoint (file2) to refresh and update using the data from (file1). The only problem I am running into so far is when opening (file2) it is...

Afternoon All, I'm trying to create a way to have my master file lets call it file1 have hyperlinked connections to some of my other files lets call it file2 with the file2 document number that will be in cell D2 to be the name displayed as the hyperlinked name. However It would be really good...

Greetings All, I have a spreadsheet which sends account information every 30 minutes 24/7 via Outlook to company executives. My original code worked but was a little buggy sometimes and tied up my clipboard until the script was through copy/pasting. I posted in this forum and received a new...

Hi. I'm a noob in this vba stuff and I need to solve a little problem. I have a worksheet named "File1" where I have some sales data and the same with a worksheet named "File2". I have 3 values among all the columns (val1, val2, val3) that I need to compare between the two worksheets. If the...

Hello All, I am using Excel 2013 and have the following problem. I have two workbooks which I use for Data entry and for updating the master Data Sheet Both the workbooks are open at the time of Data Entry. Data Entry is done on the Active Sheet of File1 eg: File1.xlsx – From file...