activate workbook

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, I have workbook that I would like to bring to the foreground and activate when I press an assigned shortcut key (even if the workbook isn't active - .i.e minimized or hidden behind other windows) My goal is for the user to be able to bring the Excel workbook up with the shortcut key even if...

Hi, I have workbook that I would like to bring to the foreground and activate when I press an assigned shortcut key (even if the workbook isn't active). The idea is that the workbook could be minimized, hidden behind other windows, or visible, and when the shortcut key is pressed, it will...

I am making a macro that will export data from an excel sheet to a powerpoint presentation to skip repetitive copy and pasting. Some of the data I'm grabbing is of variable size. I want to use the input box to allow the user to select the needed ranges. However, upon opening the powerpoint...

Hello All, I am new VBA and Macros. I am trying to open a workbook and if it is already open just activating that workbook. But I am getting "Subscript out of Range" error again. Below is the snippet of my code. Sub Activating() Dim DestFile As String Dim wb As Workbook DestFile =...

Hi all... Ever get burnt out? The more code you write, the further you are from your objective? I knew you'd understand. Here's the fast summary of this userform action: Check to see if a workbook exists - fileName:="C:\Users\admin\desktop\KELLY'S CRAP\cambridge\Autosaves\Event " &...

Hello all. Complete somewhat self-taught newbie here (so sorry in advance). I have a macro that gives the user an option to copy data from EITHER a workbook (already) run once in the morning titled "YY-MM-DD BBC_Dispatch1.xlsx" opened from a folder, -OR- copy the report from a just-run workbook...

I have VBA in an Excel workbook which opens another Workbook. It opens the new Workbook, but when I Activate the Original Workbook it doesn't switch. Strangest thing is, that when I do a code step by step, it does switch. Why is this? Sub Switch_Script() Application.Workbooks.Open...

Hi Everyone, I am using MS 2010 and i have a question about activate the excel workbook over powerpoint? I opened and closed a ppt file but a blank ppt screen still on. I cannot activate the excel over ppt. I have to show the frm1 on screen because it has confirmation message. Could you...

Hello I have a requirement to to activate a workbook, with certain words in the name of that workbook. It may be simple for you all excel gurus out there, but I have been straining my brain since morning on this. I will explain a bit in detail. I have a template from which value in few cells...

I have a code that runs well in Windows XL2013, but is stalling on Mac when trying to activate another open workbook. Specifically the line in question at which the code stalls is: Workbooks("FGL Master Workbook II").Worksheets("Manifest").Activate I realize Mac Excel users are far and few...

Hi, I need to transfer data from a workbook named R2D2 to one named Matrix. It runs after a change event (date data inputted into cell C1). The code looks like this: Dim R2D2data As String Dim Matrix As String R2D2data = "C:\Users\Owner\Desktop\Excel Projects\R2D2.xlsx" Matrix = "Matrix...

Relates to Excel 2013 only- problem not found in pervious versions of Excel. ' Windows 8.1 V 6.3.9600 Build 9600 ' Excel 2013 (15.0.4551.1510) MSO(15.0.4551.1508)32-bit The simplest way for me to start explaining the problem I am having is the following four line procedure Test(). Sub...

Hello, I have been looking on internet for a solution to this common error message, but have not found it. I open a file, and in the code activate that file before closing it. I give you the code below with the line where I get the error message. Select Case nStage...

Hello,I am working in excel/access 2003. I have a macro running out of access in which I create an excel workbook (a copy of an existing template) and try to paste the results of several access queries into this workbook. I first try to check if a copy already exists or not. If it does I delete...

I am trying to run a macro from workbook A that opens workbook B (containing appointments), copies required data and paste it into workbook A. The challenge I have is that workbook A is renamed each week as 05/18/2009.xls....05/25/2009.xls. (etc.) so if I hard code the re-activate workbook A...

Hi all, could someone please explain the differences between Selecting a sheet/wb and Activating a sheet/wb? when do you use each one, etc.? Thanks

What is the correct syntax to activate an open workbook? This is the scenario: I am send a file I obtain the file name with: Dim vFileNames As Variant vFileNames = Application.GetOpenFilename While this file is open, I open another file (a static file that will always have the same...

Hi there I'm writing a macro which opens and operates in a separate workbook (FileB) to that which it is stored in (FileA). The problem is that I need it to bring data back from FileB to File A, but the name of File A is not constant and so I can't simply instruct it to activate the workbook...