Search Results

Search found 175 results on 7 pages for 'workbooks'.

Page 4/7 | < Previous Page | 1 2 3 4 5 6 7  | Next Page >

• Excel pivot refresh, save and close in Access VBA code

  - by schneidm

  I am using the following code to refresh Excel pivot tables from an Access application. What is the best way to save and close the Excel app after the pivots refresh? In my last attempt the code was trying to save and close before the pivots had refreshed. Private Sub Command161_Click() Dim objXL As Object, x On Error Resume Next Set…

  Read the article

• vbsript and excel delete all worksheets except last one

  - by matthew moore

  I am trying to delete all worksheet in excel exept last one and save it then move its location. I can not get it took work as it deletes all other worksheets but errors out with and out of range error. Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True objExcel.DisplayAlerts = False Set objWorkbook =…

  Read the article

• Exploring the Excel Services REST API

  - by jamiet

  Over the last few years Analysis Services guru Chris Webb and I have been on something of a crusade to enable better access to data that is locked up in countless Excel workbooks that litter the hard drives of enterprise PCs. The most prominent manifestation of that crusade up to now has been a forum thread that Chris began…

  Read the article

• Exploring the Excel Services REST API

  - by jamiet

  Over the last few years Analysis Services guru Chris Webb and I have been on something of a crusade to enable better access to data that is locked up in countless Excel workbooks that litter the hard drives of enterprise PCs. The most prominent manifestation of that crusade up to now has been a forum thread that Chris began…

  Read the article

• How to require a cell input if another cell has a value

  - by Connor

  I'm trying to edit the VBA for one of my workbooks so that If there is a value in column A, then a value for column C is required or else the file won't save, but i'm having some trouble with this. I can get excel to check a cell for any input and require it have input, but I need it to check if a different cell has an…

  Read the article

• Copying Data from another Excel Workbook based on a matching id

  - by Kyle Begeman

  I have 2 workbooks I am working with. One workbook has an id and a category name. The other workbook shows a name and category section that has an id number (but not the actual description). Basically I want to copy the full category text to my current workbook from the old one based on the id number into a new…

  Read the article

• How can i lock images to a cell in excel 2010

  - by Jamie

  Ok, so i am using microsoft excel 2010 and have a set up currently where i have 2 views expanded and deflated using the Group or +/- function. My problem is that ui have images on the workbook too. The images are over the cells which are to be "hidden" when the - button is pressed and i would like the images to…

  Read the article

• Moving to the next line to populate an excel file from VBA

  - by edmon

  I have the below code that takes certain fields from my MS Access (A small Hotel Reservation Database)form and populates defined cells in the said Excel file. Dim objXLApp As Object Dim objXLBook As Object Set objXLApp = CreateObject("Excel.Application") Set objXLBook =…

  Read the article

• Copy data from Access to the next row in Excel

  - by edmon

  I have a MS Access database for a small Hotel. On the main form I have Guest Information fields...(Name, Address, Phone#, etc). I also have an Excel file that keeps track of bookings for the Hotel. The following code takes the Guest information from my form in Access and…

  Read the article

• Excel: #NAME? apppearing when linking/referencing other spreadsheets/workbook cells

  - by Mike

  I'm updating a spreadsheet that refers to data in another worksheet =NameofWorksheet for some reason I get #NAME? in some of the cells, even when the actual path is correct. The only way to overcome the problem is to open up the source spreadsheet and then recalculate…

  Read the article

• Excel: #NAME? appearing when linking/referencing other spreadsheets/workbook cells

  - by Mike

  I'm updating a spreadsheet that refers to data in another worksheet =NameofWorksheet for some reason I get #NAME? in some of the cells, even when the actual path is correct. The only way to overcome the problem is to open up the source spreadsheet and then recalculate…

  Read the article

• Business Analytics Monthly Index - October 2013

  - by p.anda

  Starting from this post we are providing a monthly summary. This provides a quick look at what has been happening in our Proactive Support Blog over the last month. Welcome to the first Monthly Index posting! …

  Read the article

• SQLAuthority News – Download Whitepaper – Power View Infrastructure Configuration and Installation: Step-by-Step and Scripts

  - by pinaldave

  Power View, a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, is an interactive data exploration, visualization, and presentation experience. It provides intuitive ad-hoc reporting for business users such as…

  Read the article

• Enterprise Manager 12c Grand Tour Customer/Partner Workshop

  - by mseika

  EMEA | Customer/Partner Workshop EMEA Oracle Solution Centre Enterprise Manager 12c Grand Tour Customer/Partner Workshop em.us.oracle.com On…

  Read the article

• Looking to create website that can have custom GUI and database per user

  - by riley3131

  I have developed an MS Access database for a company to track data in regards to production of a certain commodity. It has many many tables, forms, reports, etc. These were all done as the user requested, and resemble the users previously used system, mostly…

  Read the article

• DSOFramer closing Excel doc in another window. If unsaved data in file, dsoframer fails to open with

  - by Steve

  I'm using Microsoft's DSOFramer control to allow me to embed an Excel file in my dialog so the user can choose his sheet, then select his range of cells; it's used with an import button on my dialog. The problem is that when I call the DSOFramer's OPEN…

  Read the article

• Delphi 7 and Excel 2007 Open File Error

  - by Traci

  I am having difficulty opening a EXCEL 2007 in Delphi 7 It works for Office 2003 and below but the wonderful people at microsoft have sent an update or something and the delphi app fell over just earlier this month. oE :=…

  Read the article

• PrintPreview Window in C#

  - by M.Thillai

  Hello Techies, In my windows application in .net, i need to have Print Preview option for an excel file. The followings are my codings. //Excel.Application excelApp = new Excel.Application(); Excel.Workbook wb =…

  Read the article

• Excel Interop: Range.FormatConditions.Add throws MissingMethodException

  - by Zach Johnson

  I am writing an application which uses the Microsoft.Office.Interop.Excel assembly to export/import data from Excel spreadsheets. Everything was going fine (except for 1 based indexing and all those optional parameters!),…

  Read the article

• Adding references from VBA Causing Password Prompt To Appear

  - by ChloeRadshaw

  EDIT: I WILL GIVE A 300 rep BOUNTY FOR THIS:-) I have run out of ideas. I have a very simple macro that adds references. It looks like I have the same problem as this…

  Read the article

• how to open Excel sheet with full access in c#

  - by Lalit

  open Excel sheet with full privileged in c#. it is not allowing me to read. asking for uname and pwd when i deploye my c# application in iis. i have write this code for…

  Read the article

• Creating excel template 2003 in C# on a machine with both 2003 and 2007 installed.

  - by Ragha J

  I have both 2003 and 2007 Excel versions installed on my machine. The current source code uses Office11 (2003) interop assembly Microsoft.Office.Interop.Excel.dll to…

  Read the article

• MS Excel - Macros for consolidating values from multiple sheets into a single sheet

  - by SpikETidE

  Hi everyone... Consider i have 4 workbooks with the following structure... 1. Main.xlsx Name Jan Feb Mar A B C 2. Jan.xlsx …

  Read the article

• MS Excel - Copying columns from multiple worksheets into a single worksheet based on some condition

  - by SpikETidE

  Hi everyone... Consider i have 4 workbooks with the following structure... 1. Main.xlsx Name Jan Feb Mar A B C 2. Jan.xlsx …

  Read the article

• Is it possible to return a list of all ranges from all worksheets in an Excel 2002 workbook?

  - by generalt

  Hello all. I want to extract "special" data from an Excel 2002 (client requirement, cannot change) workbook and worksheets contained therein. I have classified…

  Read the article

< Previous Page | 1 2 3 4 5 6 7  | Next Page >