open workbook

When opening theExcel 2003 version of the workbook, it roughlytakes 5 seconds to open. This is about 60 MG in file size.<o:p></o:p>We convert this toExcel 2010 and now it roughly takes about 17seconds to open. This is about 14 MG in file size.<o:p></o:p> There's no VBA code in AutoOpen event. I...

Hi, I have some code which seemingly works fine. It takes a unique "ID" code from a list and then opens the file which begins with that "ID" code from a specified location. This appears to work fine, except for one file. There appears to be no difference with the file name, extension, type or...

Hi guys I can't figure this one out. (I'm a novice) I really want to learn to use arrays to and from ranges because it will be much faster than the looping methods I currently use. I searched the forum but see nothing exactly like my problem. The code I pasted is part of one of my procedures and...

Is there a way to use a cell value in one workbook to address a macro opening another workbook? So in workbook Source.xlsm i have a cell that will have a value 1-10. Can I have a macro button that will open the appropriate destination workbook? Destination1.xlsm or Destination2.xlsm...

Hello, I try to write this macro which could enable me to open files according to cells value I chose previously in my active workbook (In "Inputs" sheet to be accurate). These files I want to open are closed and under other folders. Here is my code but I have this message poping up "Type...

When I try opening an Excel 2007 document it opens Excel as a program but not the specific workbook I've chosed to open. I have to open it separately in the program. Is it a known issue? It's a new problem that I haven't experienced before

Hi, I have a problem with the Workbooks.Open(fileName) method. The sub I am using works perfectly fine on my computer but returns a "Cannot open workbook" on my colleague's computer. The sub looks as follows: Sub ImportOldFile() Dim fileName As String Dim wbk, wbk2 As Workbook fileName =...

I was just wondering if it was possible to open different sheets on different cells? For Example, I want sheet 1 to open at A1 but I want sheet 2 to open at B5. This is because the majority of cells are locked on some sheets so I want it to open on an unlocked cell. I am using Excel 2010...

I am creating a group of interactive excel forms They are all in one workbook, but the coding is extensive with many VBA objects on each sheet some of the sheets have over 25 pages of code I am also using named ranges for any cell references scoped to individual worksheets to enable copying of...

Hi All, I am using part of the below formula to always start with the sheet "Dynamic UI" when the workbook is opened. It is not working. Any ideas? Private Sub Workbook_Open() Dim frmSplash As GPUActionsLog 'Show the form modelessly Set frmSplash = New GPUActionsLog frmSplash.Show...

I need some help with this error. I have some VBA code in Outlook that runs whenever a task reminder goes off. The code is supposed to open a workbook, send email based on the info in the workbook, then close the workbook and quit excel. The task reminders are set to go off every two hours...

I have a long macro that adds data to four workbooks and saves the data. It then copies and pastes info within the workbook running the macro, prints two forms, gives the workbook a new file name (save as) and closes the workbook. I currently have all the workbooks open on my display. Is...

I have a workbook that can be opened by different users at the same time. My goal is to ID each time it is being opened so it can be saved by that ID. What I am thinking is to date, time and user stamp the workbook everytime it is being opened. And because it needs to be unique, a database...

Earlier I posted a question (Goto specific cell/row upon open) to which wongm003 provided an excellent response which works well. I responded with one issue I found in that string, but thought my question may be buried, so am opening a new thread. The macro code wongm003 provided works well...

What I am trying to accomplish is have a macro that runs from "personal" searches through multiple folders and sub folders, which are set up identical for all agents, and runs the predefined macro on each workbook in a folder with a defined name. What I would like the macro to open, run, save...

I'm trying to get a feel for how often some of our woorkbooks are used. I can generate a message box that gives a count on open using this code; Private Sub Workbook_Open() notimes = GetSetting("MyCount", "A", "Count", 0) + 1 MsgBox "Workbook has been opened " & notimes & " times."...