Entered data was missing when he tried to run a report. I've figured out he had other Excel workbooks open and that maybe where some of the data's gone there. How do i make the modules and code in Workbook A only run in Workbook A?
I have data in 2 different workbooks, and I need to transfer all data in 'Jx_ex1' to sheet1 in the 'template' workbook, and all data in 'Gr_ex1' to sheet2 in 'template' workbook. All data should be transferred to the same cell numbers, from A1 to Y5000. I actually have loads of workbooks to transfer to the template but if I have an example with the two then im sure I can work out how to modify it. All files will be in the same folder.
View 8 Replies View RelatedI have a sheet named sheet9 and i want to copy the data from this workbook-sheet9 to a workbook called import data and sheet named "database".
View 5 Replies View RelatedMy requirement is as follows......
I want to get a copy of worksheet from specific workbook to active work book in which i want a copy of sheet get moved.
I have a workbook that is used to calculate values from various data etc. On completion of calculating the values, eg. £20,000, I want to put the values into specific cells of another workbook template. I can of course do it manually by selecting the cell of the template workbook and do an = then reference the the cell in the calculating workbook.
What I want to happen when all the calculations are complete is that:
1. A new workbook, based on the template, is opened and saved with an appropriate title
2 The values from the calculating workbook are automatically entered into the new (saved) workbook at specific cells
I have 2 Workbooks A and B
I now would like to copy the entire row X from Workbook A to Workbook B.
Row X has to be selected: In Cell "C5" of Workbook B is a Number 12345. There is only one Row in Workbook A which has this number in column A.
So, Select the Row in Workbook A which starts with the equialent Number of C5 in Workbook B and Copy it.
I have a workbook with sensitive company information. I need a way to validate the computer the workbook is being opened on and then close the workbook if it is not a confirmed workstation.
The file is already password protected on opening, each worksheet and the workbook is protected, and the VBA code is protected. We just need to take it one step further.
Is there a way to check a registry entry or the computers MAC address on workbook_open?
I have found code to close the workbook without saving which I would use after a message box stating "You do not have permission to access this file."
If someone has their macro security level set to high or very high, that prevents my code from running. How can I make this work on any computer no matter what their macro settings are?
VB code, recorded by macro, it is working, but I need create different workbooks with different names , this one create just one specific name here is the first problem , second would be for saving in desktop folder "Ataskaitos" here another because it just for my computer , on other computer directory would not be found and third , then I deleting existing sheet in workbook from there I run the macro and copy sheet to new workbook it asking if I sure want to delete that sheet, so I don't need asking that I just need to delete it
VB:
Sheets("Ruooinys" & i).Select
ActiveSheet.Cells.Select
Selection.Copy
Workbooks.Add
ActiveSheet.Cells.Select
[Code] .....
I'm trying to link specific data from one workbook to another. So from the demo I've attahced, I need all of the 3rd row "ATP BASIC SERVICE : 1" to be linked to another workbook.
So normaly I could copy the row, go to the other workbook, "paste special" and link it to a column.
The only problem is the "ATP BASIC SERVICE : 1" data will not always be on the 3rd row.
So i assume I would need to automatically search for "ATP BASIC SERVICE : 1" and if it is found, copy the column over to the other workbook.
I have a work book with many sheets and staff continue to mess this up so I would like to know how I can have a specific sheet called Instructions open when this workbook is opened preferably no macro's is this possible
View 7 Replies View RelatedHow to create a hyperlink to a specific sheet in a different workbook.
Both workbooks are located on the same drive if that makes any difference.
I'm trying to import a range of cells from one workbook to another. I've got this far with it but am getting a Runtime Error '1004'.
Sub ImportData()
Application.ScreenUpdating = False
Set wb1 = ActiveWorkbook
[Code].....
to open a workbook at a specific time. I want to beable to flip my computer on at 8:50am, go grab some coffee and then at 9:00:00am have my workbook open and performing tasks. Besides turning on my computer, I dont want to have to open or activate anything prior to having my workbook open. However if there is code to turn on my computer from a sedative state that would be great too.
View 9 Replies View RelatedI work with a machine that takes readings and exports them into an unorganized Excel file along with irrelevant data. What I need to do is create a macro that will import only specific data and place it where I want it.
I only need to go from File A to File B, so no complex data compilation from multiple workbooks [at this time!] What may be an issue, however, is that there is no set number of data entries. It could be anywhere from 1 to 500 depending on the sample. What I'm hoping is that since the samples are added in a set pattern that it will possible to accomplish this. I've attached an excel file with two sheets. Sheet one is to represent the data file that is extracted from the machine and sheet two is a mockup template demonstrating how I want the data organized in the new file after import
This is a shot in the dark. I have a workbook with 12 sheets, one for each month of the year. Each month is divided into the different weeks of the month. For example sheet January is divided into:
Week 1: 1/1/12 through 1/7/12
Week 2: 1/8/12 through 1/14/12
and so on:
I would like my workbook to open on the cell containing the date range for that particular date.
For example, if I open the workbook on 1/10/12 I need the workbook to open on the cell range that contains Week 2: 1/8/12 through 1/14/12.
Looking for For Loop to loop through 5 specific worksheets in a work book.
Something like this, but can't find right syntax:
For iCounter = 1 to 5
If worksheet.name = "Recap" & iCounter Then
'do stuff
End If
Next iCounter
Need to have a particular workbook open at a specific time...
I wrote this and placed it in a Personal.xls module, did not run automatically. I then placed the 2nd SUB() in the "This Workbook" and nothing. Where or how is the proper way to run this...
----------------------------
Sub Open_IndexAnalysis()
Workbooks.Open Filename:="e:Index Analysis.xls"
End Sub
------------------------------
Sub Run_OpenIndexAnalysis()
Application.OnTime TimeValue("09:40:00"), "Open_IndexAnalysis"
End Sub
-----------------------
I have a workwook with multiple sheets. One of the sheet name is "ABC".
I have a macro which does a particular task. I want that when the macro is run, it should run on all the sheets of the workbook except sheet "ABC".
Here is whar I have tried:
Sheets("ABC").Activate
For Each ws In ActiveWorkbook.Worksheets
If ws.Name ActiveSheet.Name Then
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
End If
Problem: I want a macro to detect if a workbook is open so I can skip the workbook and move onto the next item. I do not want the user to be prompted in any way. I do not want the workbook to be shared. I simply want to pass over the workbook (but be aware I have passed it over).
--Long Version--
About forty team members have their own workbooks and at day’s end the team leader uses a macro to poll each team member’s workbook in turn to gather work results. When gathering these results the macro also needs to write some admin data to each workbook.
I am aware of the workbook sharing option in Excel, but I am wary of using it. It is not a show stopper if a team member’s workbook is already open and work is not gathered on a particular day – we’ll get it the next day. I just need to be able to trap the event and manage it. The central command I use to access a team member’s workbook is :
Workbooks.Open FileName:=WorkBookName................
i've got an excel workbook called..lets say.. "Database"..it contains spreadsheets with lots of exciting data..and Users view(and occassionally add to) this data through a variety of userforms.
what i'd love to know is whether theres any way to "bind" userforms to a specific workbook?
i.e. can i make it so my userforms "MIGHT" be displayed (might bcos it depends on the users selection)...while "Database is the active worksheet".....but not displayed if it isn't...e.g. if they open another excel workbook..
at the moment my userforms are present in every excel project (while Database is open and the forms are being used), which is clearly bad since they block half the screen....
does anyone possibly know how to have Userforms only show up when a specific workbook is being used?i've been stuck on this for a couple of days now and its driving me crazy.
equally if you don't think its possible, i'd love to know so i can stop wasting my time on this....there is a way around the problem..but it involves putting my "Main Menu" -which opens all my userforms- as part of an excel spreadsheet instead of a userform..and having it userform based just makes it look so much better.
I am trying to have a worksheet linked to another workbook, but this workbook name will change. It will always start with Blockbuster - Valuation but the rest of the file name is the date and the version of the workbook. Do you know how VBA can go in a folder and look for the entire file name of a workbook starting with Blockbuster - Valuation.
View 3 Replies View RelatedI can open a file at specific time using TaskSchedule. How do I close it at specific time?
I am trying to write a simple one-line code for that but do not know how to combine two statements:
Application .OnTime TimeValue("17:01:00")
and
ActiveWorkbook.Close
Also, this workbook is updated every 1 minute using the same OnTime method and everything works perfectly. However, when I try to close file there is a message saying that "OnTime method object application failed" and I have to click "Debug" or "End".
Only when I click "End", the file is closed.
I have an auto_open macro in my workbook that sets the workbook to FullScreen. However, it also makes existing open workbooks fullscreen. Is there some way that I can leave the previously open workbooks not fullscreen (i.e. so the toolbars are still visible)?
View 3 Replies View RelatedI'm looking for code that will move the cursor after the "enter" key is pressed through specific cells/order listed in the code, which can be changed as required. Using the option/tools cursor movement affects all excel documents which we don't want - just the specific sheet we are working in.
View 5 Replies View RelatedI would like the workbook to open to a specific worksheet everytime it is opened regardless of what worksheet it was in when file was saved. Can someone point me in the right direction?
View 2 Replies View RelatedI have over 200 worksheets within 1 workbook, is there a way to search or find a specific worksheet by its name? I've tried the find option, clicked search in workbook but it only searched cells within the different worksheets of the workbook and not the title (tabs) of the worksheets.
View 4 Replies View Related[URL]
"Is there a way to insert a column in a workbook that doesnt run all the way through the page?" Is a page break a potential fix?
I have the following macro:
[Code] .....
So right now the macro is run in every single worksheet in the workbook. Unfortunately, it appears the TRIM function erases formulas in cells. I want this macro to apply only to certain worksheets. Say the worksheets i want the macro to run on are named A1-A100.
I need a code (and where to put it) to open my application excel with only the userform so, with the workbook hidden.
Application.Visible=False doesn't work because it close all excels and moreover I can see the workbook for 1 or 2 seconds before hiding.
I'm looking to write a macro code that copies two specific columns to a separate spreadsheet in the same workbook, and then sort the rows by values in ascending order.
View 5 Replies View Related