open a file

Hoping someone can advise me. Firstly for some advice. Can I do this in excel. Secondly: how do I go about it. This is for collecting data for a non-profit org. I have a "Client Analysis" spreadsheet that collects data. 1. I would like the Carers to be able to click on a client name, this...

I have some code which will create and save a new file in to a folder named after the value in cell A1, and also name the file after the value in cell A1 (e.g. C:\Folders\test\test.xlsm, where "test" is the value in A1). This is if the file does not already exist, so I have set this code up as...

As a warning, I am somewhat new to using VBA, butI have a feeling I am pretty close to figuring this out. I have a folder with a bunch of different files and I need to open them one at a time to compare them with a master file. My input box is where I will have the user add the specific file...

As part of a larger macro, I have a working piece of code that opens a new workbook, copies the first sheet of that workbook, pastes the sheet into a new sheet of the original workbook, then closes the opened workbook. I want to change this to allow the user to choose which sheet to copy...

Hello, I am trying to create a report from two separate .xls files. I want a macro to open these two files from a button form so that the end user does not have to manually open any files. The two separate files will be named by month and date in the format "MMM-YY". For example. if it is...

I'm currently using the loop: For i = 1 To 10 Application.Workbooks.Open ( files(i) ) Next To open several excel workbooks. It works fine, but the standard message "File in Use" message box doesn't display, and the files just open in Read-Only mode without warning. Is there any...

Hello Everyone, I need help in writing a code which does the following: 1. Open /pop up a dialog box which asks the user to select a file from the computer 2. Copy paste the data from a worksheet in another workbook (say workbook A) to this newly opened workbook I am not the only person who...

When I open files in excel 2007 I get this error every so often from files sent to me from co workers. I can't open them or sometimes when I can there are errors all over the file. They have excel 2007, 2010, and 2013. Error comes from any of these. No code or macros in the files. Any idea...

Hello all, I am quite green to VBA and today I need your help: I want to use UserForms and ask the user to open a file. This file is generated by an ERP system and everyday has a different name and extension based on the day that it was generated. (.77 .78 .79 etc.) Because it's a different...

In VBA for excel I'm using the `FileSystemObject` to loop through the files in a folder, then when I find an excel file I'm trying to open it and update any hyperlinks in the file. Whenever I try to open a file in excel, I receive the error message `Run-time error '2147024832 (80070040)'...

Hi Everyone! I am wondering if there is a code that will open my workbook whenever any excel file will be opened. Thanks.

Hello, I have doubt that I had been trying to find a solution for a long time. I want to open a specific folder while the browse option is in action to prompt user to select a file to open. I have tried the following code but the problem is its open up desktop or the last opened folder. I...

Hello everybody. I have been going crazy over this and although there are multiple threads regarding this problem none of them have helped so far. The Problem: There is a destination sheet that collects data from multiple Source sheets (12 atm, but may become more). The links have mostly been...

Hi Excel gurus, I've been pulling my hair out trying to do a potentially easy code for some experienced people, if anyone can help! I'm looking to : 1) Open multiple file names from my F drive. Details - With the file name of "issue303661.txt" the following file would typically be consectuive...

I have a master file on share point that I want to suck data from some team files (also on SharePoint in the same location). I am using a Macro to pull the data and paste into the Master file. The Macro worked perfect on my PC but when I moved the files to SharePoint the code errors out. In...

Hi there!! I've built a macro to open a file and copy one of its worksheets into a different file (both files are in Excel 97-2003 format). The macro works great when I manually select the macro from the macros dialog box and click "Run." However, I tried to assign the macro to a hotkey. Now...

What I would like to do is fairly straight forward, but I am having difficulty finding an answer that suits my needs. There have been replies to this question in other places, but they have not worked. So this is what I would like to do. Background: I have built a spreadsheet that analyzes data...

Hi everyone, With a lot of help from you guys, I have developed a macro enabled workbook that handles updating inventory on my website. However, it got to the point it was so big and complex, it was taking too long to run, was extremely difficult to modify (due to all of the references and the...

Hello, I am trying to write VBA code that will open a file with the following name: "Price Overrides" However, sometimes the name of this file is "Price Overrides-1", or "Price Overrides-2" depending on when I lasted open/closed my browser/excel which can be hard to keep track of sometimes...

The VBA code to download my csv from my account at dropbox is: Sub OpenCSVDropbox() Workbooks.Open Filename:= _ "http://bit.ly/15YwK10" End Sub However, a new workbook is always open. I want a new worksheet in the current workbook named "data1" to open not a new workbook.