I have created simple buttons on my spreadsheet to do most everything that is needed, except to display a "Help" file. The "Help" file can be a pdf document or any other document format that will work. I don't think I need any user forms or ActiveX controls. But, then again, I am a relative newbie to VB. Is there a simple way to have a button control on an Excel spreadsheet open and display a pdf file or other document? Or is there a better way to do what I'd like?
I have created a large process map workbook in excel that links to various areas within the document using command buttons.
However, one of the things I need users to be able to see s in a PowerPoint presentation.
All I need to do is create a command button that links to, and opens this .ppt file.
The .xsl and .ppt files will be distributed in a folder to other members of the team so I need the link to not be specific to my computer. Is it possible to avoid using the full path and just use a short path such as .../desktop/tools/process.xls so that as long as they store the folder on their own desktop the link works?
I'm running on Ubuntu 13.04 and have a problem with libreoffice and openoffice alike. With libreoffice the problem occured, then I removed libreoffice and installed openoffice, on which the same problem occured.
Sometimes, when I open a writer document, it doesn't open. When I look into 'system-monitor' I do see the process is started, but it won't open. It doesn't do anything. No error message, nothing!
And when I try to 'end' or 'kill' the process in system monitor, it just doesn't. Then I log out and log in again, and then when I open a document, it brings my to the recovery window.
Then everything is fine, till it happens again. The same problem occurs on another pc with 13.04 also.
Side notes Memory: 3.9 GiB Processor: Intel® Pentium(R) CPU G630 @ 2.70GHz × 2 Graphics: Gallium 0.4 on NVA8 OS type: 32-bit Disk: 487.9 GB Used pre-installed libreoffice Installed openoffice from .deb package openoffice.org
I'm trying to write an Excel VBA macro that opens a .csv file, selects a range of cells, opens a new, blank Word document, and then pastes the cells into the Word document.
I can open .csv file.
I can open MS Word.
I can select and copy the cells in the .csv file.
I cannot figure out how to paste those cells into Word.
I have five worksheets among eight total in my workbook that I use as a report. I would like to have a button that copies those five particular worksheets into a new workbook and pastes all numbers as un-linked values. This would save me a TREMENDOUS amount of time generating my reports every month.
I am experiencing odd behavior with Excel (v. 14). When a spreadsheet is opened, format setting of almost all cells in the workbook have changed to a custom code that reads "[$-409]0%". AFAIK the first part is not even a valid tag.
Because the underlying data is not changed, I can just select cells and reset formatting to "Number" or "General" and everything's fine. However, I'd like to get to to the root of the problem.
The problem occurs with only some workbooks. I should mention that the workbooks are circulated in different language versions of Excel, which may contribute to the problem.
I want to set up a one step button in an Excel workbook to open up a Word Mailmerge Document that I have already set up complete with Excel data source. I have used this code so far but it's not working. What else do I have to do?
Sub OpenWordMailmergeMasterB() Set appWD = CreateObject("Word.Application") appWD.Visible = True appWD.Documents.Open Filename:="X:Detention filesMail MergeLesley's MailmergeMASTER Interim Report.doc"
'To Run the Mail Merge 'Data source is a range name in Excel workbook called "MailmergeReport":.....................
I have a tool file which contains Excel VBA codes. When I click button it asks to select a file. I want that anytime I click the button the dialogue box should open in the folder containg the tool.,
how to put together a macro for a command button that deletes rows with certain text in a docyment - which worked fine a week or so ago - but now the macro will not work.
I made changes to the document - but made sure i also made changes to the code.
I currently have this code that allows me to print a word document on one of my drives with the click of a button in excel. I need to modify it because one of the files I want to print as well is a pdf file. how to modify it so I can do that?
Set appWrd = CreateObject("Word.Application") Set docOpen = appWrd.Documents.Open("F:groupsdeptservCDTISA.doc") docOpen.PrintOut docOpen.Close appWrd.Quit
Ok I have a form where our employees enter in some info and press the add button. I want this add button to take the data entered and transfer it to a database. Each time the button is pressed it needs to drop a row and add the new information entered.
I have a column ("R") which contains prices. What I'm looking to do is have a form control button that either hides that column, or better still just turn the font white (invisible)on the press of the button, then with another press turn the font back to black (visible) or do I require 2 buttons to carry out this function. I don't wish to have the column formatted in anyway after the changes, simply 1 press turns the font white and either another press (or another button) turns the column back to the exact same state (no formulas present) as it was.
I want to convert the excel file into text document with out changing it file type
for example
in the wordpad i have the text document in this type "Candy","1253563"
I want this to be open in excel and i can open in the excel using delimited option but i want only to change the number "1253563" and i can use autoofilter to filter and i want to change the number "1253693" in the excel and i want that excel should open in the format of text document without any change as i mentioned before
it should open in this format
"Candy","1253693" only the number should change and this action is repeated for many numbers
I have several files with form control buttons that automate functions but, on occasion, they get smaller relative to the worksheet they're in. At some point, they become unuasable unless they're manually resized.
I have a rather large sheet with lots of embedded form control buttons, each one with a document link. Is there a function (no VBA) to search for a specific form control button in excel? for example: i want to find the form control button which is linked to the "application" document.
I have added a button to asign a macro to but for the life of me cant see how to "activate" the button. I am trying to click the button to make the macro run but it keeps selecting the button like it wont come out of design view.
I have made an excel sheet for multiple choice questions, in which person needs to click on submit button after completing with the test & pop up will say "Your score is__". Now, I want to want to add one more button named "Reset". I want below :
results:
1. Person should not be able to make any changes after clicking on "Submit" button.
2. If one tries to click on "Reset" button, it should ask for password.
3. After keying password for "Reset" button, all questions should be reset so that next person can give test.
I have attached an example excel sheet for reference : DoM1.xlsm
I have created several macros where i use an active-X control button. This button is pressed and the macro begins...........but every now and again this button changes size for no apparent reason.
I have read countless articles/posts about what "may" be causing the problem but i have never read anything which clearly identifies the soln to this problem and the problem has been out there for years. To make matters worse the problem can not be duplicated on any regular frequency that i am aware of............so its not like i can post a file that will show the problem.............
