open file

  1. M

    How to open files from an AxitiveX combobox list that is populated by a macro?

    Hello, Long time answer searcher, first time poster. Still limited macro knowledge but I have usually been able to solve my macro-writing problems with a few searches and sometimes cobbling together different answers that I find online. No such luck this time. I have the macro below (found...
  2. M

    To hyperlink &open file from foldername which ismentioned in activecell as value

    Hi Friends, can you pls help me out with the code which can hyperlink the active cell value mentioned in the sheet,and open that folder and its file whichever i will choose to open from it. My code is doing upto 70% of the task, but unable to open the choosing file from it. It throws the error...
  3. D

    VBA - Open workbook and import data to next empty row

    Hi, I am relatively new to the VBA world and would much appreciate some assistance with the following. A project currently being worked on requires a macro to do the following: Open excel file from "Open file" dialog box Find data in specific ranges Copy data to next empty row of original...
  4. S

    VBA help to fix broken code - delete rows, paste transposed data

    Hello, I've tried to record a macro and expand that in order to help solve my problem. I've fixed some things I need to do by looking at solved threads, but not everything. Below is my code. Ideally, I'd like to do the data sorting operation for a bunch of text files in a named folder, but...
  5. K

    VBA to open different Excel file - doesn't work in Office 365

    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...
  6. X

    Open a CSV File with VBA Macro and copy/paste data to worksheet then close CSV and run Bat file within VBA macro

    Hi, I would like a macro to open any and all .csv files into excel (new window) found withing a specific directory one at a time (may need user prompt to keep organized). Once the code has opened the first .csv file and has focus on it, I have a macro in place to copy it's data and paste into...
  7. Tim_Excel_

    Opening a file using a hyperlink with VBA

    Hiya forum, I'm trying to open some files automatically, which shouldn't be too hard. Unfortunately, so far I've been really held back by the file being located on a weblink. Let's call the weblink http://classifiedlink.com/" & VRl & "type=PDB. Set sh = Workbooks(var1).Worksheets(1) With sh...
  8. T

    open file excell diferent format

    i can't open my excell when i open it sho notification that : the file are trying to open is in a different format than specified by the file extension. if i enter yes my workbook is blank please hepl me thanks
  9. T

    Macro To Open .pdf file From Partial Filename

    Trying to make a macro to open a .pdf file whose file name contains the selected "Item number" in a spreadsheet. It will open in Internet Explorer. I'm getting close, I can open a file if its entire file name is the item number: Sub OpenPDF() Application.DisplayAlerts = False...
  10. N

    VBA - Open workbook, Copy all sheets, paste as values, save as new workbook

    Hello Long time user, first time poster. I am using Excel 2010. I am currently trying to create a Macro that will do the following. Open a workbook based on text written in cell Copy all tabs from the opened workbook Paste as values Then save as a new workbook, also if possible from a...
  11. Prevost

    Prevent Excel From Loading Charts When Opening File

    Hi There. Is there a way to prevent excel from loading and displaying charts on worksheets and tabs when the file is opened? We have charts that plot many data points and opening the file can be lengthy when you wait for the chart to load. Also, when you scroll through a sheet it pauses at the...
  12. M

    Date Format Changing when VBA opens a file

    Hi If I manually open a CSV file all of the dates appear in the UK format DD/MM/YYYY. When VBA opens the exact same file the way it interprets the dates is in the US format MM/DD/YYYY. So the date 09/02/2015 changes from 9th Feb to the 2nd Sep. And the 26th Feb becomes a text field. I am using...
  13. L

    Search through folders and subfolders to find a file and open it.

    Hi I have started this macro but I am having a problem (Labeled '????? below). I am tring to find a file which is typically .doc/docx/.pdf within a folder or its subbfolders then open it if found. Can anyone modify my solution below to to alos searchthrough all subfolders? file =...
  14. E

    Need help to open certain file

    Hi guys I got this file: UCHP_Translation2.xls (the file can have any name) The file contains loads sheets and different columns sv,es,ru etc. now I need a a script, that check in the file if the columns contain text then check in a folder after the filename (UCHP_Translation2.xls) the file...
  15. E

    Can't openfile call a variable

    Hi guys, Could someone help me I can't open MyLangFile variable see code below: Sub OpenLangFile() Dim myLangCol As String Dim myPath As String Dim myFile As String Dim mySheetname As String Dim myLangFile As String myPath = Application.ActiveWorkbook.Path For Each sht In...
  16. F

    Open / Close Workbooks Sequentially

    I have a large number of Excel files that I need to open, wait for their opening sub to run, and then close. Then on to the next one in the list. etc. Currently, I'm doing this with a .bat file that simply lists the file names. It's pretty easy to manage. But, the disadvantage is that I have to...
  17. D

    VBA - Open External Files

    Hopefully this isn't too confusing... So I'm trying to open a outside xls file (File 2) from within a workbook (File 1), copy the contents of File 2 and paste it back into File 1. The only snag is the File 2 is automatiicaly FTP'd to me daily in a custom folder. Everyday a new folder is...
  18. R

    Adding Opened Workbook to Collection

    Hi, My code uses GetOpenFilename to open a file. Once opened, I check to see if the file is already opened. My code works great if the file is not already opened. My question is, if the file is already opened, How do I include this file in my collection. Here is my code: FName =...
  19. B

    Can you tell when an excel file has been opened?

    Is there a way to find out the date and time an excel file has been opened within the file?
  20. A

    Excel and Project seize

    I am trying to get excel to open a MS Project file and then run a project macro on it. What is happen is that when I run my code it works, and then excels VBA window freezes up and the run arrow goes away, and if I try to open project I just get a chiming noise and it won't open. For now I...

Some videos you may like

This Week's Hot Topics

Top