open workbook

Hi Folks, Have checked Google and come a blank on this one. Does anyone know if it's possible to use VBA---in a Private Sub Workbook_Open() macro---to check if the filepath that the file has been opened from matches a specified path, and if not, close the workbook? Kind regards, Doug.

I have been using the following code to open a workbook to a specific sheet and going to the next available row for data entry. It had been working fine. Then in the course of testing, It stopped working and I would get a "ws = nothing" error... Private Sub Workbook_Open() Dim ws As...

Hi all, I am completely new here. I have looked over the forum and I have found posts, that related to what I am looking for assistance with. However I cannot get the solutions to work for me. Question: I have the below VBA code and it works a charm - It could probably be simpler, but it works...

Hi All Firstly, many apologies, I know this has been asked and answered previously. Unfortunately I am not experienced (or intelligent) enough to make those solutions work for me! I am therefore asking about my specific situation. I save a daily .csv file in Sharesync with the previous...

Hi I have just upgraded to excel 2016 and Im having problems opening another workbook from a userform and making it the active one. It opens it ok, but you cant type anything unless you change to another sheet first then back again, it seems to still be active on the original workbook. Code...

Hi guys, I need to copy information that matches a provider name from one Workbook/[Provider Sheet] to another workbook where I need it to append certain columns of all providers information. So far I am using the code I found to choose the workbook/sheet/range from a windows and select the...

Hi ! I'm looking for a solution to block a 20.worksheets.workbook acces if the user dont activate is macro first. And after activation then he will see and have acces to the full workbook.. ? Any solutions ? Thank you very much and have a great day! Steve

I am trying to open up a workbook that is declared as a variable. Is there a way to do this by using the variable name? I'd rather not have to use the long file path name. In the code after I move "blanksheet" from "dailysales" to "monthly" the dailysales workbook will no longer be open, as...

Hi Guys, I have a Excel file which has a macro to open multiple spreadsheets based on the location specified within macro. I used this file (and macro) for about a year and it was all good until we migrated to Windows 10 and Office 365. All other macros seem to be fine but the most important...

Hello all, I'm looking to add some code to my opening procedure that will check if another workbook is open. I found some examples online, but they seem to look for a specific filename. Is there a way to look for any .xls or .xlsm file open? Thanks!

Hi, I am trying to write one code. In this code, there is one file which I need to activate among the existing open excel files. Also if this file is not found open, I need to open this file from the given location without giving any error(I am not sure how to do this part). The objective is to...

I have a MAIN workbook and i also recieve daily data (in Excel format) that needs to be added to this Main workbook. This daily file is saved in a specific network folder. I'm looking for VBA to open the "Workbook Open" dialog box on a specified network path by default and to allow the user to...

Hello, I have a macro built to open a "source" workbook, copy and paste a range into a "master" workbook. The "source" file has the .xls extension, but when you open it you get the warning that its in a different format. Below is my code - its works fine if I have recently opened the "source"...

Hi guys, These are my Subs: Sub Undosave() Application.ScreenUpdating = False Application.OnTime Now, "Undosave2" ThisWorkbook.Close SaveChanges:=False End Sub Sub Undosave2() Application.Workbooks.Open ("C:\Users\Seth\Documents\Costing Program\Process Costing\Process Costing Updating")...

Hi there, I have a macro which opens files based on the contents of a cell range. This cell range has the file names and the macro specifies the folder directory. The macro opens whatever cells are selected and then it closes all files. I want it to run as is but with one minor tweak - only to...

Hello, I have multiple workbooks that I need to combine into one main master workbook. I have a macro already in place that opens/closes all the workbooks, I just need help looping through each open workbook and placing the data into my master sheet. See my progress below so far: My main...

Alright I have a doozy for everybody. I have a master sheet that I copy information in from rep's tracking sheets for the work they do. I created a sheet that auto copies all of their sheets based on the file paths which I use another button to populate in row J. Everything is working swimmingly...

Hi, Please help me with this. I keep on getting application/ object not defined error messages. I have no idea how to fix it, as I dont know what I did wrong. Thanks. Best, Morris Here is my code: Dim wb As Workbook Application.ScreenUpdating = False Set wb =...

Hello Everyone. I hope someone will be able to assist me with this issue. Each time I open my Ms Excel Workbook it shows the sheet it was on before it was closed. What I want to do is, on the click of a button, it will do three things: 1. save the file. 2. Return to a main page 3. Close the...

I'm trying to open an excel workbook and read the data from sheet1. when it gets to the "With Workbooks(xyz).sheets(Sheet1)" it gives me an error "Run-Time error '9': Subscript out of range. Also when I try and close the workbook, it gives me an error. Any help would be appreciated. Danka...