office 2007

  1. T

    Excel 2007 in windows 10 doesn't ask for password box fail

    Hi I've just upgraded to Windows 10 and I'm now trying to open password protected files that were created with 2007 but when I open the file Excel pops up but the password box doesn't so I can't get into it. It's a file created by head office so I have to leave the password in place. Do you...
  2. C

    VBA Purchasing Ordering userform

    Hi all, Firstly i would like to say hello, I've been using basic excel for around 1,2 years now but haven't used in quite a while, and happy to join this community. I've attached a excel sheet which requires fixing as I've struggled to resume work on, and looking for some support/ guidance to...
  3. S

    Need help fellers

    Hey guys, So this what i want to do. I created a button and when i press the button I want the macro to insert today's date on Cell A2 Then on cell B3 I want the Macro to insert a text box from Cel B3 to cell Cell G8 This box needs to be a scrollable box. Then, Once the file is closed and...
  4. D

    Macro to save to PDF and retain 11x17 landscape

    Hello all, I need to save an Excel worksheet to PDF and retain it's paper size of 11 x 17 landscape. Below is the macro I currently have and it runs but saves the pdf in 11 x 8.5. Any help is greatly appreciated. Sub CreatePDF() 'Creates an individual workbook for each worksheet in the active...
  5. U

    Offset() problems

    Hi guys, Been using offset to create dynamic range names for inclusion in validation. Having an issue with the following formula: OFFSET(cell ref,,columns,height) which I've used as a name, but then in the drop down list, it returns both the offset cell reference and the values I'm after...
  6. J

    Excel VBA 7x slower on one computer vs another, new Office 2007 installation

    All, Our company recently updated all computers to Office 2007. I had written an Excel/VBA application in 2003 which ran very fast. After updating to 2007 the application runs about 7x slower than before. I think it may be an Office 2007 setting (outside of Excel) since the application still...
  7. D

    2007 Conversion

    I just converted my 2003 workbook application to 2007 (I think). The file is now in .xlsm format. However, when I launch this (.xlsm) workbook in 2003, it goes thru a file conversion process and comes back with following error: "The file was created in a newer version of Microsoft Excel...
  8. R

    Will Office 2007 live concurrently with 2002?

    We are moving from Office 2002 to Office 2007 (big leap of faith!), and I have been chosen as the guinea pig. For compatibility with my colleagues, I would still like to use 2002 (specially Excel) while I am testing 2007 and porting our template files across. Can Office 2007 be installed so...
  9. PetLahev

    EnableFormatConditionsCalculation

    Hello I've just found this property in Excel 2007 object model and have tested it. But it seems doesn't works. Does anybody experience with that? I wrote this code for testing Sub TestEnableFormatConditionsCalculation() ' Does it work? Dim wks As Worksheet Set wks = ActiveSheet...
  10. A

    Office Button is disabled in 2007

    We have upgraded several machines where I work from Office 2003 to Office 2007. When opening Word or Excel in a few of all the installs done, clicking on the Office Button does not produce a drop down menu. Has this happened to anyone else? And, if so, how did you correct it? Everything I am...
  11. PetLahev

    Too long text on Chart Axes - Office 2007

    Hello Does anybody know how I can solve problem with too long text on chart axes? I create charts via VBA and sometimes user writes too long text and Excel doesn't show it in full lenght. Excel truncates it and shows 2 or 3 dots at end of the text. Look at the picture. I could not figure...
  12. S

    How to open Excel & Word from an access database

    Hi, I'm using Access 2007 - I have a Main menu and I want to have is a series of buttons that when clicked will open Excel, another button will open word etc. Is there a simple and straightforward way of doing this? For now I don't want to open any specific documents, just open a blank document...
  13. S

    if i open normal.xltm he names itself normal1.xltm, a problem with code?

    Hello, I have a problem:if i open normal.xltm he names itself normal1.xltm, a problem with code? Code: Application.Run "normal.xltm!Filename" Application.CutCopyMode = False ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _ ActiveWorkbook.FullName, TextToDisplay:= _...
  14. A

    Extract data from website directory

    Hi, I need to extract data from csv files from a website. The files are created daily and are listed on webpages split by category and then by year (i.e. /website address/category1/category2/filenamedate.csv) There is a login page for the website and I need to download the data from multiple...
  15. B

    MS Office 2007-Changing Default # of Worksheets

    in 2003, you could change the default # of sheets from 3 to 1 (as an example) with the Tools-Options-General command...any ideas on what the equivalent is in office 2007?

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top