saved

So I currently have 2 excel files that are identical and file 1 is where data gets entered and it feeds file 2. What I am wondering is it possible to lock a cell in either file once the data has been entered and saved? I am trying to avoid any potential for data in file 1 being deleted by...

Hi everyone, I am trying to auto save a worksheet every 5 mins using vba code. I have saved the code to workbook and module and it saves every 5 mins. Issue is it reopens any excel file that was open and it saves those files too. Any suggestions?? Thanks in advance. Saved in workbook...

Hello All- I've asked this question before a number of different ways but I've never gotten an answer that worked. I have a workbook that's name when it saved comes from a series of cells. The file name when it's saved is formatted as follows and we'll just say it's from Sheet1 A1 A2 A3 -...

Hi, If someone can help me with the below it would be much appreciated. For some context, I'm wanting a macro that can look through a file location and return specific ranges from any file saved in that location (potentially up to a 1,000 different files in this location). This will effectively...

Hi, I need a formula or macro that can loop through a particular file and return specified cells from EVERY file saved in this location (up to say 2,000 potential files). Furthermore, I'll need this formula / macro to sore the data alphabetically by client. For a little more context, I'm...

Hi All, I am Trying to export a particular sheet to Text (Tab Delimited) File. The path to save the file and the name of the text file should be selected by the user. I tried searching in internet and i am Fed up on this. I tried the below code but the whole workbook is getting saved in the...

Trying to have 3 different userforms popup based on the document having three different names- basically I want a userform to popup when the document is the "template" then once it gets saved as "working" for the first time, a different userform will popup, then as it gets saved as again...

Hello everyone :), I would like to get your help for the following: This table shows the items that have been purchased during the year. My objective is calculate how many we saved when we purchased each item (I'm trying to compare each time the price of the last purchase with the current...

I have this code; Private Sub Workbook_BeforeClose(Cancel As Boolean) Worksheets("test").Range("A1:A11").Clear End Sub Its in a template spreadsheet that gets repeatedly populated and saved as other filenames. I want this code to run only on the template version, not on the saved as...

I have 3 Excel files File1.xls, File2.xlsm, File3.xlsm. Every day File1.xls is produced and saved through a process. File2.xlsm is let's say the today file and File3.xlsm is the same as File2.xlsm, just saved 6 months ago. File2.xlsm and File3.xlsm in one worksheet have the following...

Hi All, I have command button that will save chart from a sheet as a jpg file.(Ifound this code on this Forum) This is working OK but I need to make sure the file is saved to the users desktop. I pretty sure the code I have used is OK for this but I won't mind someone checking it please...

Hi All, I have command button that will save chart from a sheet as a jpg file.(Ifound this code on this Forum) This is working OK but I need to make sure the file is saved to the users desktop. I pretty sure the code I have used is OK for this but I won't mind someone checking it please...

I have one Excel file that is slow to open, often crashes Excel, etc. The only "complicated formula" (I have some "left" and "right" trim formulas) the worksheet has are v-lookups but I have limited the ranges searched- not searching entire columns. I have also saved the file in binary...

Hi, I have an excel sheet of which i would like to copy a specific range, then save that range as a pdf file on the desktop. When the file is saved it just needs to be called LR CODES The range to copy is A1:K16 I have the code below but not entirely sure its correct,because i copied it from...

Hi Im currently using Excel 2010 Is there a way of doing the above? the external file in question is in a separate directory "\\H:\Dashboards\P6Update I would like my spreadsheet to just show the latest saved date of this file whenever it gets saved in cell C2 Thanks

Hi, I've been told that you can use VBA to loop through a file location (example: I:/MyDocs/P7) and return specific cells (example: A2) from every file saved in this location, providing the filename is saved in the correct format. If anyone has any idea how to do this or a link to a separate...

I currently have a workbook where all I need to do is have worksheet3 copied and that copy saved to a variable shared network location based on cell value. R3 = NY Example: :C/MyDocs/Book/NY - - -- file saved here with file name R3= GA C/MyDocs/Book/GA - - -- file saved here with file name...

Hello, Is there any way to use a VBA macro to create new workbooks using an existing Excel template and have the new workbooks saved with each of the business days of the month/s? such as SSB Template Update.xls being saved as SSB 09.03.18.xls. Thank you, Peter

Hello Its becoming a pain since few days. I am trying to connect to Access database saved in sharepoint through vba Excel is also saved in sharepoint Code i am using is Conn.Open "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" & dbname & ";" sconnect = "Provider=MSDASQL.1;DSN=Excel...

Hey all, Last week I could run a saved query in Excel on my Mac - it would pull a url from a text file and import a table into my spreadsheet. This week the option has disappeared, and I'm left only with an option to 'Get External Data', which is refusing to pull any data from the url. Has...