document

Hi everyone. I have a document that I have links which open up a PDF and I would like a macro to go through and download all of these documents into a file path. Is this possible? Thank you for your help. I have this vba as of now which downloads the pdf but nothing appears in the PDF I think...

Hi Everyone, I have a button and i need help to apply a macro on this button with following output. 1. Motive of this button is to insert document into excel as an icon 2. Document path should be based on A1 (Drive Location) + file name mentioned in code (.pdf) 3. Document caption should be...

Hi Everyone, I have one code which will browse document from provide path: Code: Sub Button1_Click() Worksheets("Sheet1").OLEObjects.Add Filename:="XXX", Link:=False, DisplayAsIcon:=False, Left:=40, Top:=40, Width:=150, Height:=10 End Sub My expectation: 1. Filename should be based on the...

First, I want to say thank you to everyone who contributes to this website. I am new to working with macros and VBA – Self taught by reading and using codes found on this site so bear with me if I use any wrong terminology in describing my problem below. I am running Excel 2016 on a Windows 7...

Greetings, I am a novice at VBA and hoping to get some help. I have created the following subroutine ... Sub Excel_to_Word() Dim appWord As Word.Application Set appWord = New Word.Application appWord.Visible = True With appWord...

Hi New to VBA and trying to find a code that will Open an Word Template document from within Excel (creating a new doc) (The template document is populated with Bookmarks) Remove bookmarks (and related text) depending on cell value So if Excel column A and B has Column A Bookmark1 Bookmark2...

I am trying to open a document with vba. below is the code I have. while no getting a error message, the document no opening. I tried "o:" and \\dfs.com\root\ Dim Open_Aspect_Sheet_Check_Open As String Dim xWb As Workbook On Error Resume Next Set xWb =...

I have a document with 48 sheets of data, and want to copy the same row from each sheet into a new document. Is there a way to do this simultaneously to avoid copying and pasting from each sheet?

Hi, I have an excel document for a performance evaluation. This is an actual evaluation form in excel that can be printed. This document has multiple fields, say Name, ID, Job Code, Job Title, Etc. Every Department within the organization has multiple employees. So, in Dept. 130000 say I have...

Win 7, Access 2007 I am trying to import a word document and store the document as a memo field. Then print the word document. Do not have a clue as how to do this.Suggestions welcome. tia Jack

Hi all. I have a Word document which has been saved as a .txt document and then been imported into one worksheet in Excel as a table. What I would like to do is as follows: From the last row of data on worksheet "Jobs", variable lastrow, find the first row before it containing "London"...

I am trying to convert an 11 page Pdf document to excel and have the formatting work correctly. If anyone knows of an easy way to do this I would appreciate it. Thank you, Beth

Hi Everyone, I have a Document and I need to pull in data from other documents? So I want a macro that when I run it does the following, Opens All xlsx file in the folder my document is saved in that start with the word "Date_" and pull them into my document into one sheet. but there are a...

Hi guys, I am having an issue getting some VBA to work for me. I copy and paste a sheet from one document into mine. My code formats the document slightly before then filtering from 2 columns and having any hidden rows removed. Filtered columns are E ("BP10-AMB", "CY10-B/LINE", "GT10-B/LINE"...

I have the following code that works for the most part, except when there is no "prcIsum" found within the HTML. In these cases, the code fails. I got this to work for the ".viSNotesCnt" column, but am having issues for the others. I want it to show as blank if there is no "prcIsum" or...

I presently have a lengthy document that has titles, in an Index, at the beginning of the document. How can I use command buttons with each subject so that when selected , it brings the reader to a specific row in the document? Person selects the "HR" Command Button - it brings the person to...

Hi All, I have a VBA script running in a doc and it has a password protect function on it. Essentially locks down all the sheets so only the editable cells remain open. I need to make format and other changes to the document, how do I stop the script from running so I can make all my changes...

I have a macro that publishes a file to a Sharepoint folder from within an Excel document. One user out of 5 is having an issue where it gets to the end of the publishing status bar and suddenly it goes bonkers with "1004 document not saved". This person has a slightly later version of Excel...

HI i have this formula =IF(D9=0;1;0)+IF(E9=0;1;0)+IF(F9=0;1;0)+IF(G9=0;1;0)+IF(H9=0;1;0)+IF(I9=0;1;0)+IF(N9=0;1;0)+IF(M9=0;1;0)+IF(L9=0;1;0)+IF(K9=0;1;0)+IF(J9=0;1;0) For counting zeros in a document but i dont want excel to count the empty cells as zero Any suggestions?

I'm creating a tracking document for the real estate team I work with. I'm in way over my head in excel skills (this is news to no one on the team, we just realized it's cheaper for me to spend the hours to make this document and have it as our own rather than pay for the one we've been using...