Vista Home Premium - 2007 Office
Feb 15, 2009
I have an older laptop with XP and 2007 Office / Excel this works, with the new laptop doesn't work?
basically - I open a new spreadsheet - blank - just basic
I used to be able to click the data tab, then click From Access, then enter my URL to an access database on my website and BAM my data would populate in cell A1
with VISTA - I get the same error over and over again, tried a different XP machine, no problem? What gives?
error box states: Microsoft Office Excel cannot access the file [url]
there are several possible reasons.
the file name or path does not exist
the file is being used
workbook has the same name
I'm starting to really hate VISTA after about 3hrs with this new laptop!
View 9 Replies
ADVERTISEMENT
Mar 15, 2014
In Australia we calculate Insurance Premiums usually being a Base Premium, Plus Stamp Duty, Plus Fire Service Levy (FSL) Plus Goods & Services Tax (GST) - there is no GST on Stamp Duty, however Stamp Duty is calculated on the total of Base Premium (+ GST) Plus FSL (+ GST).
See below:
NET TO GROSS i.e. Base plus FSL, plus GST, plus Stamp Duty.
Base PremiumUnderwriter provides
Key in blue box onlyBase785.68
StateSA
TypeMotor
FSL0% 0
GST10% 78.57
Stamp11% 95.07
The total premiums is Total Premium959.32
We want the following formula/calculation to be able to just load a Gross/Total Premium figure and have excel calculate the base premium i.e. Total premium - Stamp Duty - GST - FSL
GROSS TO net
Total Premium
Key in Total Premium00
Stamp duty $- 11%
GST $- 10%
FSL $- 0%
The base premium isBase0.00.0.00
Formulae must allow for changes in % rates above (i.e. 11% stamp duty and 0% FSL may be different in each state and a potential change in the GSTrate) as these differ from each state and we need to show the actual amount of each component i.e. Stamp Duty, GST and FSL in the calculation.
Fire Services Levy (FSL) is calculated on a Base Premium plus GST (10%) - FSL varies from State to State, so we need to be able to input the relevant State % rate, GST is calculated on Base Premium (ex GST) plus FSL (ex GST), Stamp Duty is calculated upon Base Premium (plus GST), FSL (plus GST),
provide the respective formulae so that we can do this calculation ourselves using different rates and Total Premium figures.
View 2 Replies
View Related
Sep 10, 2008
I have a fairly simple macro that takes a few seconds on my XP-computer with Excel 2003 but takes several minutes on my Vista-computer with Excel 2007.
The XP-PC has 2GB memory, the Vista-PC only 1GB, but it's hard to believe it's only that.
Is Excel 2007 so much slower than 2003?
The macro makes quite extensive use of the .rows(Rownr).Delete method. Is the fact that 2007 has 1 million rows against the 65536 of 2003 the culprit? It has to shift much more data up when deleting a row, no?
View 9 Replies
View Related
Jul 31, 2009
Does anyone know the equivalent of CTRL (Home) to move the cursor to the a1 position in VBA? I have tried Range(cells(1,1),cells(1,1)).select but with no success
View 3 Replies
View Related
May 5, 2009
I'm having a bit of an issue with OWC in 2007. I know they have been deprecated but I was under the impression, form many places including MS themself, that you could install them. I downloaded this file
http://www.microsoft.com/downloads/d...DisplayLang=en
and then the SP1 2007 file here
http://www.microsoft.com/downloads/d...displaylang=en
All seems to go well and there seems to be a appropriate .dll in c:Program FilesCommon FilesMicrosoft SharedWeb Components111033 by the name of OWCI11.DLL. However when I attempt to add a reference to that file in a VBA project in Excel (it's one that has an old broken reference to 2003 OWC) by browsing to that file it tells me
"Can't add a reference to the specified file"
What have I done wrong? Is what I am attempting, getting 2007 to use OWC, even possible? Note I did not write any of the code for this Excel Add-in so have very little idea about what OWC are for.
View 6 Replies
View Related
Apr 10, 2007
I got a copy of Office 2007 and I am having some trouble running an Excel macro. It gives a 405 Error message. This macro runs fine on my Office 2003. Is there any extra setting that I need to do in the Excel 2007?
View 9 Replies
View Related
Nov 7, 2008
I have several spread sheets I sort daily, now suddenly today when I hit Ctrl / home it wont go home and I can not sort the sheet.
View 7 Replies
View Related
Jan 14, 2008
I'm opening an Excel file that automatically attempts to update links when I open it, but I am not prompted with the choice to cancel, or update links, when I open the file, like I was in Office 2003.
I have checked the Excel Options, Advanced, General, 'Ask to update automatic links' box, but I still don't get the dialog box when I open the file.
The file is just riddled with VALUE errors. A colleague of mine who opens the file in Office 2003 can see all the data fine.
View 9 Replies
View Related
Jun 20, 2007
In the following thread, richphillips wonders about Application.Filesearch
Application.filesearch In Office 2007
Is there a replacement for this? I have several macros that use Application.Filesearch and I would like it to work not only with Excel 2003 but also with Excel 2007. This is the function
Function CreateFileList(FileFilter As String, _
IncludeSubFolder As Boolean) As Variant
' returns the full filename for files matching
' the filter criteria in the current folder
Dim FileList() As String, FileCount As Long
CreateFileList = ""
Erase FileList
If FileFilter = "" Then FileFilter = "*.*" ' all files
Debug.Print CurDir
strFolder = BrowseForFolderShell(, , , 0)
If strFolder = "" Then
MsgBox "You Cancelled"
Exit Function
End If............
View 9 Replies
View Related
Jan 20, 2008
I have been using code to save a collection of my reports in html format that has work very well until I was forced into using Vista and office 2007. Here is a snippet of the code that no longer works - at least I suspect this is the main problem.
View 4 Replies
View Related
Aug 5, 2008
I need a macro that switches the Ribbon to the "Home" tab.
View 2 Replies
View Related
Apr 30, 2009
I have a very large and complicated database spreadsheet that has extensive VBA, cusom toolbars and menus
I know if I want to move it to another PC where to copy the files as long as they are both XP.
I cant seem to see a simple way of doing it from XP to Vista.
View 9 Replies
View Related
May 31, 2008
I used to run a macro on Win XP - where in I open a Web browser and then Send keystroke to Open new ones - Which was working fine. But now when i use the same macro in Vista it gives me a "Error - 70 : Permission Denied" @ sendkeys.
Option Explicit
Public myIE As Object
Sub OpenIE()
Set myIE = CreateObject("InternetExplorer.Application")
myIE.Navigate "www.ozgrid.com"
myIE.Visible = True
Application.Wait (Now + TimeSerial(0, 0, 5))
SendKeys "^N" ' to Open New Window
End Sub
What i require now is I need to Open IE - 7 - Which i am able to do and then open several Tabs with different URL's
View 5 Replies
View Related
Jan 25, 2010
I have a workbook that I transfer back and forth from my desktop to my laptop, that uses Sendkeys to add code to the active pane in VBA. It doesn't work on my laptop, but works fine on my desktop.
Both computers have Vista. Is there a switch somewhere to make Sendkeys work?
View 7 Replies
View Related
Oct 29, 2009
I am writing a sports schedule or fixture list. The home teams are in column B and the away teams are in column C.
I want to prevent any team having 3 consecutive home matches. Is there any way a formula can be used to alert me if there are 3 consecutive home matches.
View 9 Replies
View Related
Mar 26, 2009
I have been searching Excel Help for a code that will allow me to program the Ctrl + Home function.
Specifically, I have a macro that leaves the selected cell too far down on the spreadsheet. Instead of making the user scroll up or press the Ctrl + Home keys, I want to write a code at the end of my existing macro.
View 14 Replies
View Related
Jan 8, 2007
I have used the PMT function but this gives me the total to pay per month.
I want to know what the repayments would be and also allow me to add in each one of the periods and extra repayment option.
So if in the year I wanted to pay an extra $100 per month, I would put $100 next to each period as in a particular period(s) I might not have to put in there but want to predict what the amount owing on the house is.
Is this possible or is this too complicated.
View 3 Replies
View Related
Mar 10, 2007
On the computers in my office they have a My Documents folder that is in the directory C:Data. There is also a My Documents folder in the usual windows location C:Documents and Settings etc. Is there a function that will give me the path of the folder that is on the desktop? The macro will be run on computers with the folder in different locations which is why I need to look it up.
View 5 Replies
View Related
Mar 15, 2014
Doing a search function where the cursor is on a row some where (unknown).
I would like to move the cursor to the first column of the spreadsheet.
View 2 Replies
View Related
Jul 3, 2014
I am working on a budget spreadsheet and want to find a formula that will automatically tell me what my take home pay is depending on the yearly salary and see if covers my expenses (linked to another spreadsheet). It will be easier to budget my expenses depending on my salary. My attempts to create IF and = haven't worked.
View 2 Replies
View Related
Jul 15, 2014
I created a custom tab withthe UI editor into my personal sheet which is set as startup and I want to have this tab automaticly shown when it is opened.
So when the workbook is opened I would like the show the tab Andre rather than the home tab.
View 4 Replies
View Related
Jun 6, 2006
Found the wonderful code here at Ozgrid and would like to change the return to home selection.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Application.Intersect(Range("d4:Ad104"), Target) Is Nothing Then
Int_color = Target.Interior.ColorIndex
Select Case Int_color
Case xlNone
'Question, what does "xlNone" do?
Target.Interior.ColorIndex = 3
Target.Font.ColorIndex = 3
Target.Value = "true"
'Range("A1").Select - would like to change this to move the selection to
'the present row clicked, column c. If I click on G9 the selection returns
'to C9.
Case Else
Target.Interior.ColorIndex = xlNone
Target.Value = "false"
End Select
End If
End Sub
View 2 Replies
View Related
Aug 25, 2014
I have a category field, and a money spent field in a table.
Category Money spent
1 $12
2 $19
2 $122
1 $5
4 $65
5 $34
5 $12
3 $26
Category 1: $17
Category 2: $$$
and so on..
So I'm looking for a formula that returns information to one cell. A formula that looks if in 'this' column you see the category code '1' for example, then return to me the money spent for ALL the 1's. It should return $17...
The table above is small just for demo purpose, my table has 8 category codes at the moment and the number of rows can be between 15 and 50 I guess... it's a monthly break down.
I would like to see how much is spent in total for each category...
In addition if possible, can this be done for two separate tables... We are two people, and I have two table recording expenditure.
So the formula would need to, from these tables:
Person A Person B
Category Money spent Category Money spent
1 $12 2 $14
2 $192 4 $25
2 $122 4 $65
1 $5 1 $32
4 $65 3 $75
5 $34 3 $85
5 $12 2 $12
3 $26 2 $11
Category 1: $49
Category 2: $$$
and so on...
Look up in both tables, search the two category columns for category '1' for example, then return all the $'s added together... So for Category 1 now it would show $49...
View 8 Replies
View Related
Oct 14, 2013
When using 2013 Excel in the Home tab, line 1 is not visible. Using the File tab will show line one, but the Home title bar is unavailable. Toggling back and forth is not efficient. No one in this office has ever seen an Excel program not display a full page under the title bar in the Home tab.
View 1 Replies
View Related
Jun 27, 2013
I recently moved to Central America and now am working on models that are either in $ or in the local currency (Q). I do not want to change my default currency value in the regional settings of the control panel because it is more convenient for me to stay in $ but it is a pain everytime I want to set a worksheet in Q and not in $.
So, I am wondering how I can change the default values in the currency drop-down list on the Home toolbar under Numbers in Excel 2010.
Currently, it gives me the change to apply the following currencies:
- $ English (US)
- £ English (UK)
- € Euro (€ 123)
- ¥ Chinese (PRC)
- fr. French (Switzerland)
Instead of either the £, ¥ or fr., I would like to have listed the Q, my other frequently used currency.
View 3 Replies
View Related
Nov 23, 2008
ive got my highly expensive office enterprise 2007 disk
what is the best way of installing this so i can still use 97 and 2007. any tips?
i wont bother with outlook but i'd like to try the rest ,mind you onenote,infopath and groove are a complete mystery!
View 11 Replies
View Related
Apr 24, 2013
how to change language of MS office.English language is not showing in options.Do I need to purchase language pack?I am using english language other than office.
View 1 Replies
View Related
Jan 26, 2007
I have recently updated to Office 2007. I have about 50 forms with VBA in them (all excel) and I was careful to save them all back to 2003 office files. When one of my users opens the files and uses on of the internal userforms it errors out saying it is missing a reference.
View 9 Replies
View Related
Jun 26, 2006
I create a vb script file using SAS that will open excel and create pivot tables. It works in XP but not in office 97. I am not a vb expert. Here is the code.
Set XL = CreateObject("Excel.Application")
XL.Visible=True
XL.Workbooks.OpenText "D:JDTEMPXLWORKBOOK.TXT", 437, 1, 1, -4142, _
False, False, False, False, False, True, "|", _
array( _
array(1, 2), _
array(2, 2), _
array(3, 1), _
array(4, 1), _
array(5, 2), _
array(6, 2), _
array(7, 2), _
array(8, 2), _
array(9, 2) _ ............................
View 2 Replies
View Related
Feb 17, 2007
My organisation has ten small offices within a ten mile radius.
Most of the items to order are office supplies, along with order forms, catalogues, brochures and pro-formas.
Each office does not order the same items.
I would like to make a ‘generic’ supplies order in excel.
Column A = ‘in house’ code
Column B = Description
Columns C to G are size, colour, pack size etc.
Column H = quantity held
Column I = quantity required to hold
Column J = amount to re-order.
I would like Excel to calculate
Amount to bring stock to hold - “=I4-h4” (in J4)
If Current Stock is more than Stock to Hold then ‘0’ is in J4, “=IF(H4<I4, I14-H14,0)” (in J4) I think.
If H4 is left blank then J4 to show “0” or ‘Blank’. (experiments have given J4 a figure of 25)
I have tried putting two formulas together, but Excel tells me I have ‘too many arguments’.
View 9 Replies
View Related
