filetoopen

  1. H

    Error 1004 no data was selected to parse after FileToOpen

    I have created a macro that asks users to select an excel file to open, and then creates a pivot table with the imported data. The macro works great if the user selects a file, but if they choose "cancel" I get error code "1004 no data was selected to parse. " I added a line of code to have a...
  2. K

    Importing data from multiple workbooks to one sheet in master workbook

    Good day all. I'm busy to automate some of our time sheets and overtime reporting. Each employee completes his/her own timesheet in a Excel Spreadsheet. Some of this information is then merged into a monthly summary. At the end of the month the employee is using a button, with a Macro, to print...
  3. D

    DIR Do While Loop not working as expected

    I am trying to open all of the files that meet a search criteria and are in a specified folder. I want to copy and paste the contents of certain worksheets into one worksheet that will contain the combined data of the sheets. I had it working earlier and now it is copying the contents of each...
  4. G

    VBA Help to pass over workbook if not relevant

    Hi all, New to the forum to post but have used teh information many times, I have teh following to help populate a consolidated workbook which pulls in data from selected workbooks: Sub PopulateData() Dim wb1 As Workbook Dim wb2 As Workbook Dim wb3 As Workbook Dim wb4 As Workbook Dim wb5 As...
  5. B

    Workbooks.open not working consistently

    I have a macro which I created about 10 years ago in VBA for Excel for Mac. I and others in my company used this consistently over this time period with no issues. Now I have been having multiple problems since switching to Excel For Mac in Office 365. I use this one particular macro to...
  6. sharky12345

    ByRef Type Mismatch error

    I'm trying to get a procedure where a user browses for a file and check if it's open. I've played around with this but it's giving me an error; FileToOpen = Application.GetOpenFilename(FileFilter:="Excel Files (*.xlsm), *.xlsm") If FileToOpen = "False" Then ActiveWorkbook.Close...
  7. M

    Set default folder to open in FileToOpen

    Hi all I'm trying to specify a certain filepath (happens to be SharePoint) in a FileToOpen command, but it doesn't seem to keep the path when other people use it the extract of code is below Sub Get_Template() CurrPath = ActiveWorkbook.Path 'ThisWorkbook.Path SetCurrentDirectory...

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
Back
Top