opening files

How can I solve the following problem? I use SAP to extract reports into Excel spreadsheets. I save this file on my computer, and every time it's saved, it opens the file. I no longer want it to open the saved files from SAP. How can I make this setting?

Hi I know it is possible to open a file with using wildcards, but is it possible to get the full address/filename using wildcards without opening the file? eg opening using wildcards: FilePath=FolderPath & "*DUB*" Workbooks.Open FilePath And I know you can get full address/name with...

Dear All, I have a huge Excel file almost 30 MB with Tables and Macros. I used PowerQuery to automate it earlier but failed then I removed all quires from my file but it still stops and show a status "Loading .Net Framework..." when I open it which takes time. I want to know if Excel actually...

Greetings knowledgeable sages, I would like to create additional Excel workbooks in a folder/directory where a master workbook is located (or potentially one level up in the directory hierarchy). I have various template files, so want the user be able to select the specific file to spawn from...

I have a dropdown Combo box, and figured out how to tab from the combo box to next cell. Now, the last piece of the puzzle to make my file perfect, is that, when I open the file, the cursor will automatically be in the combo box, since it is my first cell. Ideas?? I can attach my file if someone...

Hi all, Please could someone assist with a project that I am starting? What I would like to do is create a program that will open (one at a time) all workbooks in a specific directory. Once open I need it to open and then close a number of other workbooks from another directory. The purpose of...

Hi I have another question for you. I do routine tasks every day which involves opening 3 different files and pasting data into my main file. The data is always in the same format, and the 3 files are saved in the same location (3 different folders through). The 3 files are saved each day and...

I threw together the two methods I use to open files in a folder based on criteria to see which runs quicker. (In this case it was m1 by roughly 1 second per file). I was wondering if there are any other accepted methods of opening files en masse. p is the folderpath and p2 is a filter such as...