document

Good Day Gentleman, I am hoping someone could help me out with the problem I am currently having - believe me that it would be beyond appreciated if anyone is willing to offer some of their time to help me with this. Currently I have a very large spreadsheet(Approx 3080 Rows and with approx...

I have a form i created that is protected so that the supplier can only fill out certain areas that i want them to. when i send it out to the suppliers they are reporting that the single page document opens in 4 pages. how can i stop this so that everyone can open it the same way?

What is the code I would use in a command button to copy the excel page, so it can be posted to a Word Document and others?

As the above title suggests I'm tring to open an Excel document that is embedded in a Word document from within my Excel document using VBA. This is the first time I couldn't find a pre-existing answer to my problem. The reason I'm trying to do this, in case someone has a better solution, is...

Hi, erveryone.. I am creating a project with MS Word VBA consisting of an active document and a userform. I want the ducument and userform to stand aside from each other. The problem is, If I set the modal userform property = true, then the document cannot be edited. And if the modal property...

Dear Sir, I have copied some code from your site. And now I want to change little bit thing in code. Sub DoMailMerge() 'Nodte: A VBA Reference to the Word Object Model is required, via Tools|References Dim wdApp As New Word.Application, wdDoc As Word.Document Dim strWorkbookName As String...

Hello, Not sure if this is possible, but what I am trying to do is set up a template, that when a new workbook is created from this template, that workbook is shared. My employees open a new document each day to record a lot of data but I would like to be making changes on that document at the...

Hello How can I write an MSWord document based on Excel cells from specifically named sheet? Also, how can I format the content of each cell in the MSWord document? Thanks!

Hi Everyone, I have a document thats going to go out to over 200 people. I have set it up with loads of macros stopping anyone from editing, changing and playing around with it, however there is still the possability that someone might think they know what they are doing and change things as...

I have a spreadsheet that has a button to create a new document for a new financial year. There is a text box where the new financial year will be entered in. I did have it so the new document could be created but only for the following financial year to the current one. Then my supervisor...

Want to run a macro which can do mail merge and save that document in PDF Format with the First name and second name combination in a specific location

I am creating a list of all assigned document numbers for the company. The document numbers are assigned sequentially based on the components of the numbering system (Region-Dept-Document Type-XX). I want to automatically assign the document number to all new documents added to the list to...

I have a document that is intended to be a living document and contain a large volume of data entries. For the sake of stability and protection I want to create VBA script to look at each entry. If the values in column "D" for said entries are all value "X" they are to be copied to a separate...

Hi Everyone, Not sure if this is posible, but creating a new document with about 90 sheets, every sheet has a picture or two in it, many of which are the same but i'm finding the pictures are not maintining there sizes as i copy paste move design ect. I've done "Do not move or size with picture...

Sorry i am very new, thank you for your time.

Hi all, I'm trying to use a stadard form called "Master Cleandeskform.xls", and I would like to save it in the same folder as the original document, under differend name. Cell F3 contains the date, which is used to complete the file name. Example: "Cleandeskform 17-02-2019.xls" Everything is...

Hello All, I don't know if this is something that is practical ... hoping perhaps someone can help. I have a large workbook that is a financial analysis application. Lots of macros. I have users that have asked if there is way to create a routine that would populate a Word document with data...

Hi All, I'm trying to replace some ugly grey buttons in a document with ActiveX buttons. If I add a button, put some code behind it, exit Design mode and click on the button, rather than executing code a smaller copy of the button appears above and to the left of the button. If I then save the...

hi, i googled a way to open a word doc via Excel VBA 'Open an existing Word Document from Excel Dim objWord As Object Set objWord = CreateObject("Word.Application") objWord.Visible = True 'Change the directory path and file name to the location 'of the document you want to open from Excel...

Hi Everyone, I have a button and i need help your assistance in 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...