office 2007

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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:= _...

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...

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?