I tried to open an old Excel sheet, and columns A through AM were hidden. I cannot open the hidden columns by using the Unhide action (highlighting the entire sheet). Any suggestions that would enable me to open these hidden columns would be appreciated. Thanks.
I have a workbook that pulls data from another workbook.
At present both workbooks have to be open for the data to pull through.
What I am wanting is a way to pull the data from 'workbook1' to 'workbook 2' without 'workbook 2' being open.
I cannot use vba as I also have another workbook...
Hi - hoping someone better than me can help with a slight adjustment to the below code. I think its easy for someone with the skills.
So it currently opens all the files in a picked folder and renames the sheet to Sheet1, so long as there's only one sheet.
Problem is I have a combination of...
I want to log the date that a file is opened. For example, If I open the file today and I entered case#2 then the date should be today date in date column but if I open this file tomorrow for case#3 then tomorrow date should be in date column at the same time case #1 and 2 date should not...
Signal is generated in Excel Either Buy or Sell. The Vba should Open the Another Application Perform Functions Like enter amount, name,.....From Excel Only then Submit and Close. Wait for next Signal and Repeat the same Process Again.:)
Hi would it be feasible to be able to open a workbook then by running a macro import the first sheet from multiple workbooks book1 book2 book3 book4 book5 book6 book7 add them into the open workbook and rename them sheet 1 to 7
Hi, I have been searching with no luck to find a solution to copying/pasting data from an open chrome web page.
I have chrome web page open (the web page has a title, so hoping to use the title). On the page there are columns with headers and columns of data. I'd like to select certain columns...
I have 1 macro that I use on different workbooks to pass data into a fixed workbook.
So I want to be able to open that fixed workbook and then run my copying macro from the changing workbooks. The problem is when I use vba to open the workbook it makes it the active one and the macro copies the...
Good EveningEveryone :),
I would like to create an AutoOpen sub that automatically opens up to a specific worksheet based upon the current month.
For example, we are currently in October, so I'd like it to open up toWorksheets(4).
If its November, I'd like it to open up to Worksheets(5).
I'm looking some help with referencing a combo box in a outlook form. I have a total of 4 pages/tabs, the first is where the user will select from a combo box and depending on which option is selected this will navigate the user to the correct page. I've never used vba in a outlook form...
I am looking for a code to pull data (a whole row) from sheet 4 to sheet 1 based on a criteria. Sheet one should only show the entries that show status as open. This status is in the last column M of sheet 4. Data starts from A20 and should look for the open entries in the sheet 4 where...
I have a wb with a drop down menu that correctly references an external wb to get the list but the external wb needs to be open to do so. It is going to be used by more than one person and will be stored on a server. Is there a way to have the external wb open when the cell with the list is...
A friend sent me a file to open for him. The file extension has now become like this:
From his end, he inserted a flash drive into his system and all his files got the new strange file extensions.
I have come across such situations, mostly when I send an unzipped workbook...
I would like the userform to open when i open the workbook.
At present i have the following which works fine when i navigate worksheet to worksheet but need some advice please for it to run when i open the workbook.
Private Sub Worksheet_Activate()
If Range("A2") = "" Then...
I was wandering if someone could help me edit the code below to open the pdf in the file that has the letters GGS in the file name?
Public Sub openJOBLIST()
Dim path As String
Dim PDFfile As String
path = "\\hq\dfsdata\Data\UserHomes\jamey.eerson\My Documents\pdf-NEW\Latest...
Hi - Could someone please give me bit of assistance, I am trying to get an excel document to auto resize to different monitor/screen sizes so bosses do not have to scroll around document. I have tried the code below but does not work (also not sure if putting in the right place, fairly new to...
I have a excel sheet that opens with a message box. The sheet is a template and is used to create other sheets with different variables. My question is this how do I have this box open whilst the sheets name is "Auto Blank feed sheet" and not open when the sheet has a different name...
Weird question, but i love the ctrl + open bracket trick to take you to where the formula is happening, but is there a way to get back to the original cell? It can get tedious to have to trudge through several sheets or rows, especially if you are working with large file.
Thanks so much!
Is it possible to Open a file only for specific computers.
A VBA code for let’s say 3 MAC Addresses is linked with Workbook Open Event & the file should open for those 3 computers who’s MAC Addresses are there in the code - otherwise a msg box should prompt saying that you are...