docs

This is the code:Sub Workbook_Save(Path, Workbook_Name, _ Optional File_Format As XlFileFormat = xlOpenXMLWorkbookMacroEnabled) ' Save the workbook to the indicated file. If Right(Path, 1) <> "\" Then Path = Path & "\" FileName = Path & Workbook_Name...

I am attempting to summarise a large data-set and am having trouble trying to collate the sum total. Hopefully the below example displays correctly on this page. Sample of data-set is below; <colgroup><col><col><col span="2"></colgroup><tbody> Qtrly Modified Date Docs Emails Q1-2018...

HI, ive made a one sheet document that i want to publish on google docs and use as a basic calculator when im on the move. trouble is when i open it in google docs all the spinner buttons do not appear..

I am new to vba. I only use to record. I currently find myself in a situation above my knowledge. I have 6 word docs mailmerged to 6 Excel docs in the same folder. I named the .doc and it's corresponding source Excel doc with the same name. I want to create a form using ActiveX textbox and...

I have a dropdown list of document types in cell A1. Drawings, Word docs, Excel docs, etc… I want to fill cell A1 with a code dependant on the doc type selected from the dropdown list. e.g. select “Drawings” from dropdown. Code to be displayed in cell A1 “DRG”

I am hoping someone can correct my nested if statement belowto work properly. I am sure I am nesting incorrectly with using (AND( in themiddle of my formula. I could use the VLOOKUP but I am hoping to avoid it ifpossible. From what I have searched online it appears the AND or OR statementsseem...

Hi All Note to self, write your post in word and then copy to thiswindow, as I have now written the post 3 times, only for the window to crashand reopen without my text L. Now to my question…. I have created a dash board using Excel and want to be ableto link to PDF docs in another folder...

Hello- I am an administrator for my work's SharePoint site. We have numerous Excel docs in the SharePoint which contain quality data. I am looking to see if anyone knows how (or if) I can add another excel document in the SharePoint, which would automatically populate data from specific cells...

Hello, Happy Friday! I'm trying to figure out a way to expedite my current workflow. I have a report that's generated into a word document. I manually input select pieces of data from this document into an excel template so that I can present to clients. The word document looks something like...