file open

  1. A

    VBA Macro Opens Multiple files/Version of the same file

    Hi, I have the following Macro: '--- Reads File Name from Filenames Worksheet ---' Windows(Master).Activate Sheets("Filenames").Select datafile = Range("A" & cntLDC) '--- Opening File ---' Workbooks.Open Filename:= _ "U:\OPERATIONS\Reports\" &...
  2. R

    Continue Macro after opening file

    Hello everyone. Does anyone know if it's possible to make a macro continue only after opening another file, and if so, how to do it? The idea is that when the explorer opens the folder (this part works), i open a chosen file, and only then the macro continues. Here's my code (don't worry...
  3. A

    How to simulate File Open Dialog in Excel using VBA

    hi guys I've been lurking the forum for a while now and has always found good answers. However, I'm having trouble finding a way to simulate the file open dialog using VBA. I'd like to users to click a link to a directory and it opens in the File Open view as if the users just clicked File/Open...
  4. K

    From Active Worksheet Trying to Open another file, cut, paste to original file; works in debug but shortcut fails

    Hi - I'm old to programming but very new to VBA. I'm using Excel 2010 and have a pretty functional routine. Where I'm running into trouble with opening a 2nd file, copying a column, pasting the column to the original file (from which the code is being executed) and then closing the 2nd file...
  5. S

    Opening an Excel file and NOT run Workbook_Open macro

    Hi there, I have an excel enabled file that needs to open another Excel file and copy an image from that file, however, this Excel file that I wish to open has a "Private Sub Workbook_Open()" macro that runs and has a couple of messages that require a response. As I wish to have the opening of...
  6. K

    Excel 2010 locking up in Windows 7 when 'file open' icon clicked - pdf filemaker add on

    I just got a new laptop with windows 7 and when I click the file open icon in excel 2010, the entire spreadsheet locks up. It sounds like this could be an add-on issue. The only add-on I have is pdf filemaker. Once I am locked up, I have to kill excel through the task manager. Has anyone...
  7. X

    Opening a File and Macro Issues

    Hello I have a file on a corporate network, that uses macros and has an Workbook_Open event. For months there has been no problem with Enabling Macros on opening (as I only have security set to medium) and Don't Update Links (as there are few links to external files). There has been no change...
  8. P

    open workbooks in a date range

    I have two strings formatted as dates. strDateOne, strDateTwo. I have one workbook saved for each date: formatted DayOneFilemm_dd_yyyy i need to open each workbook between strDateOne and strDateTwo copy the sheet and close the workbook. Any help would be appreciated.
  9. W

    File open help

    Hi, I would like to open a file to copy two worksheets from. The issue I have is the file name and or lcation need to be considered as "unknowns". I need the Open window to allow me to search and fine the file needed. Once the file is found, I can then copy the sheets I need. How do I call...
  10. S

    Slow to open - large file ???

    Hi, I a, new to this forum and impressed by all the knowledge on here. I have a question for you all. I am a teacher and have an excel doc which I use to record all of my students grades etc. But, every time I open and close it, it seems to be extremely slow. When I take a look at the...
  11. M

    Counting the number times a file is opened

    I have a workbook setup as Read only for reporting purposes. I would like to capture the number of times and if possible, the users that are opening the file....is there a way? thanks, MP
  12. C

    FileOpen/FileSave Command doesn't work?

    Hey! So I am having an issue that I can not seem to figure out here... I want to be able to use my own custom dialog box when a user requests and Open or a Save (in Office 2007). I can do this via VBA and macros, but I have a shared add-in that I have created in VS2008 that does this for me...
  13. D

    Macro - User Txtbox entry to open a file

    I need a macro that will open an existing excel file using a txtbox that the user has to type in the last name of the person they are searching for. The macro then searches a prepopulated list of names. (I don't want to use a listbox either). The user must then verify the correct person by...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

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.
Go back
Top