I'm aware that I can use activedocument.follow hyperlink to download a file given a URL, but I'm unsure of how to interact with that file after it has been downloaded. Is it possible to rename the file upon download or specify where the file is downloaded to using VBA? Furthermore, how can I go...
I am having multiple problems:
I created an if statement that first clears out any pre-existing content and then adds new data to the cells from a Userform. The Userform has 5 tabs within a Multipage and when I set the first page as active I want the data to be exported into a BOM. I have a...
I have several worksheets in the same Excel file where I need to clear the contents in these specific columns (A,D,G,J,M,P,S & V) starting at row 2 in each column. My worksheets are named (8am, 12pm, 2pm, 4pm and 6pm) - Here is the code so far that clears these contents but it seems like I...
Here is my dilemma, everyday I check the last entry in a column and cross reference it with data from another workbook to see if I need to add data to my original sheet.
So when i recorded my macro, I thought i'd be able to copy the contents of my last entry and paste it into the find...
Private Sub CommandButton1_Click()
Dim arr(1 To 2) As Variant, word As Variant
If Len(Me.TextBox1.Text) And Len(Me.TextBox2.Text) Then
arr(1) = Split(Me.TextBox1, " ")
arr(2) = Split(Me.TextBox2, " ")
For Each word In arr(1)
I've played around with this problem and had no success so far. A search of this forum yielded nothing.
I've got a some large spreadsheets with confidential information. I need to clear the contents and redact rows where cells contain specified text.
I'd like some VBA code that will...
I am trying to retrieve contents of a cell in another sheet based on the contents of that sheets adjoining column as I want to find the data in sheet (ABC) based on the contents of sheet (ABC') column (C) if c1= U then display contents in cell (a1) in sheet(ABC) to sheet (DEF) (K14). I need it...
I'm a little out of my depth with a task I'm trying to do in Excel and would appreciate help!
What I'm trying to do, when on sheet A, is create a macro to find a cell on another sheet and replace it's contents with the contents of a cell on sheet A.
For example, on sheet A
Cell A1 has the...
I use a xls sheet as a help for keeping track of website user login and pwd's.
I know this isn't really best practice, but up to now it's still my most convenient solution.
Pwd's aren't conveyed in full, but represent a 'hint' that is obvious to me to help reconstruct the pwd as...
I have a drag and drop feature using a listview on my userform. I am trying to drag and drop emails from outlook to my excel userform. I am not very familiar with the MSComctlLib.DataObject type and its actually a bit more complicated as I thought. I am wondering if someone could point me...
looking for help with something outside my comfort zone
In cell A1 in workbook "result " I need the contents of Cell B20 from workbook "example", worksheet "show" when it matches the contents of cell B2
Normally I would use VLookup
But the cells are offset, ie the target cell/matching cell...
We have a system with an excel export, but the columns are not in the order we need, nor are they even in the same order each time we perform this export.
Is it possible to redefine the columns in Excel with some VBA? I would want this done based on the contents of A1 through CY1. These...
Hi all, kindly require to provide me a VBA code so that to insert rows below and place exactly the same contents (e.g. numbers, dates, descriptions e.t.c.) as from above rows cells, except the contents in col. "E" and "J". Thank you all in advance
Hoping all you wonderful folks out there can help me, I am trying to find a vba script to open a word document and copy the contents and create a new email message and use the document contents as the email body, is this possible using vba?
i have this code that I found in the web works great just want to know how to modify it so when I click hyperlink
unhide the sheets and when I click back contents hide the sheet again, thanks.
'PURPOSE: Add a Table of Contents worksheets to easily navigate to...
I've been asked if I can create a macro that loops through a number of email folders within Outlook and saves the contents to a location on a network (ideally it would then clear the contents of those folders within Outlook). I was just wondering if anyone knew, initially, if this was...
I have been trying to clean up my spread sheet by removing helper columns and can't figure out how o do it.
I have a main log with all of my data and another sheet as a request. I am trying to populate the request based on the contents in a specific cell matching the same contents on...