document

I have a spreadsheet with an embedded .PDF file in it. I put that document there when I was using Adobe products and the formula for the document shows a formula as =EMBED("Acrobat Document",""). New documents I embed show up like this: =EMBED("PDF",""). And if I double-click the Acrobat...

I'm looking for a solution that would use the Get Data function in excel to query and combine all files that reside in a Sharepoint document library. I'm able to connect to specific files but the number of files in the document library may change over time (expected to increase). Is there a...

Hi, I have a document of someone else's that I check daily and it was made aware to me that the individual whose document it is, knew that I was doing this. And I wasn't sure how this was possible. As far as I know, there's no way to log when an Excel or Microsoft document has been opened...

I am creating a standard operating procedures manual for my employees. Needless to say there is a lot of text, and Word would be a more appropriate tool for this project. However, Word has a critical shortcoming as it does not allow freeze frames like Excel (I do not want to use Split View)...

Good day, I am new to this and this is my first post. I have limited excel experience and to be honest have not ran a single VBA yet. They seem a little intimidating to me to say the least. I created an excel document (well call it Document 1) that has the (now) time at the top that updates...

Is there a way to convert a Microsoft Word document that is formatted in rows and columns like an excel spreadsheet in Excel?

Hi Everyone, I am looking for ideas getting an HTML document into Excel. I've tried the standard "Get Data" but I end up with a 4MB file and have 30-35 tables daily. If its possible to import the entire HTML document to one worksheet with a one click solution that would be great. Any...

Hi, I work for a charity near Liverpool (UK) and need some help please. When we send our template introduction letter to our beneficiaries we have to include a selection of 5-10 (out of around 50) standard paragraphs of text to insert into a letter. Currently we use Word 2016, and set up a...

I am researching my Great Great Grandfathers time during the Civil War. What started to be a simple Excel file has grown to a large file, 25000+ rows. Not what I planned for but the further I got in the research the more I expanded to included all members of his units. I am new to VBA and...

Hi guys Not strictly an Excel Q and I'm sure this is really simple but I am seriously losing the will to live right now!! I need a macro that will: 1. Save the already open word document to a text file with the same name but me the option to choose the file path 2. Re-save the Word document...

Hello All, I have a perplexing problem hoping someone can help. This may not be an Excel problem, but it is definitely a MS Office problem. I have Office 2016 on a Win 7 PC. I have created a Word document where I have pasted a link to an Excel workbook chart. What I am trying to do is...

hi all, i'm currently in the processes of updating an existing spreadsheet that we insert and track customer demands on. Previously, we had created a copy of the Word document in Excel and filled the fields with the corresponding data using VLOOKUP to manually match the order number input...

Good morning! This may be a really silly question, but is there an easy way to make Word always open a document where it was when last saved? I save documents while at the bottom of my document but when I open it later I am at the top. Not a huge deal, just an annoyance when crafting a long...

Hi All, I need a bit of help with a calculating spreadsheet. I can seem to get the formula to work in cell AD9 because it is using the result of another formula in its calculations. I have posted a link to the document below. Can someone help me please? Chris :confused...

I have this VBA to auto generate an email upon completion of a form and a submit button, however, due to consistent issues with their information I need to add the ability to not create the email and attach the form if the text boxes are not filled out. Does anyone know of a means to do that by...

Hello All, I have a macro in Excel which creates a Word document and then copies and pastes several ranges from Excel to Word. When pasting to Word, the result is a table ... which is what I want. The macro works as I wish. Sub CompDetails_to_Word() Dim wdApp As New Word.Application...

Hi Everyone, OK So heres what I need, I need two macros, 1 when the document is opened it creates a new document in the same folder called "Used" When the document is closed it deletes the docment called "Used" how can I do this. Thanks Tony

Hey all. I'll try to make this brief and simple. :) I have 40 or so boilerplate word documents with a series of fields (Name, address, etc) that need to be filled in. This is historically done manually, but it's repetitive and cumbersome. A workbook where a user has filled a huge set of...

My question has two parts to it, but I would be happy if I could just get the first part answered. The second part is mostly aesthetics. 1) Is it possible to create a link that will jump back to a previous point in an Excel document? I have a rather large document that I'm creating, and I'm...

So somebody at my company has told me they would like a macro enabled Excel workbook that can connect to a certain Fortune 100 Electronics company's database system via API and extract customer requested information. A customer would be able to enter a quote # or some other UID and it will...