Search Results

Search found 1188 results on 48 pages for 'vba'.

Page 33/48 | < Previous Page | 29 30 31 32 33 34 35 36 37 38 39 40  | Next Page >

• Merge Mutliple Excel Workbooks

  - by IRHM

  I wonder whether someone may be able to help me please. I'm trying to use the code below to allow the user to select multiple Excel Workbooks, amalgamating the data into one 'Summary' sheet. Sub Merge() Dim DestWB As Workbook, WB As Workbook, WS As Worksheet, SourceSheet As String Set DestWB = ActiveWorkbook SourceSheet…

  Read the article

• access: read CSV file into table

  - by every_answer_gets_a_point

  is it possible to programmatically have access open a certain csv file and read it into a datasheet and set parameters like what time of delimiter, TEXT QUALIFIER etc, including all the steps that one takes to manually import a csv file into a table?

  Read the article

• Export and Import MS Access table defenitions as text files

  - by CodeSlave

  How can I export/import MS Access table definitions as text files (in a human readable format like I can with Forms or Reports)? I know how I can export the whole table out into CSV file; however: I don't need the data to go (actually really rather that it didn't) When I import a CSV file (especially without data) there's no guarantee that the…

  Read the article

• Using Excel To Read Access Without MS Access On Computer

  - by Tom Clark

  I have written code that joins two table in access, using criteria supplied from drop down lists in excel and then returns the data to a specific location on the spreadsheet (titles already on the sheet). This works fine on my box and others with MS Access on the machine, but the purpose of writing this was to give people (associates) that dont…

  Read the article

• How to wrap images into a Excel Add-in 2003

  - by nimo

  hi, I'm having a excel add-in with several menu items. Each menu item embedded with a image. I'm loading picture to menu item using LoadPicture function where I gave the absolute path to image location. In order to make the add-in distributable I need to provide a relative path. Appropriate anyone can suggest me how to do this. Thank you

  Read the article

• Excel 2003 - How to build my own XLA?

  - by Justin

  How can you make the .xla file if you want to create your own xla? I have the code, classes, shapes, etc....what is the process to making an xla file to point to? I know that I have to put it in my program files folder, and then go through the steps to adding an "add-in" in xls...but i mean actually saving an xla file to point to.... can i…

  Read the article

• How can I iterate through table styles only?

  - by Vitali Climenco

  I have a procedure that iterates through the styles available to a document: Sub EnumerateStyles() For Each Style in ActiveDocument.Styles `some custom code Next End Sub I do not need all the styles, and just those that are applicable to tables only. How can I programmatically filter the styles? Thank you

  Read the article

• Extract the vb code associated with a macro attached to an Action button in PowerPoint

  - by Patricker

  I have about 25 PowerPoint presentations, each with at least 45 slides. On each slide is a question with four possible answers and a help button which provides a hint relevant to the question. Each of the answers and the help button is a PowerPoint Action button that launches a macro. I am attempting to migrate all the…

  Read the article

• Subscript out of range error

  - by Edmond

  Private Sub sendemail(esubj) ROW_BEGIN = 1 ROW_END = 72 Sheets("Input").Select Range("A" & ROW_BEGIN & ":S" & ROW_END).Select Range("A" & ROW_BEGIN).Select fileL = "\\fire\school\FINANCE\Report\FY10\Key Indicator\" fileL = fileL & (Left(Range("I7"), 3)) &…

  Read the article

• In Microsoft Access 03. Creating 2 critera for one report

  - by Edmond

  In Microsoft access 03.I am creating a database and want the user to have the option of two critera. Critera 1, the output on the report is filtered by accounts that have a varinace of =10% or <=-10%. Or, Critera 2, allow the user to be able to input a specific variance on a form, that will only output on…

  Read the article

• multi-thread in MS Access, async processing

  - by LanguaFlash

  I know that title sounds crazy but here is my situation. After a certain user event I need to update a couple tables that are "unrelated" to what the user is currently doing. Currently this takes a couple seconds to execute and causes the user a certain amount of frustration. Is there a way to perform my…

  Read the article

• Only allow users on my network domain to open an Excel workbook

  - by k.robinson

  Rather than distribute a password to employees, I would like to protect an excel workbook so that only users on the company domain can open the workbook. Is there a feasible way to do this?

  Read the article

• Visual Studio 2008 Macro for Building does not block thread

  - by Climber104

  Hello, I am trying to write a macro for Building my application, kicking off an external tool, and ataching the debugger to that external tool. Everything is working except for the building. It builds, but it is not blocking the thread so the external tool gets kicked off before it can finish. Is there…

  Read the article

• In an MS Access Maketable query, how to create an Autonumber field?

  - by PowerUser

  I have a Maketable query in an Access db that could use an Autonumber field. I can't find a built-in function for my purpose. Do i need to write my own? Ideally, I'd just like to create a field in the Access designer as "Autonum: CreateAutoNumber()" Edit: If it can't be done in the query itself, I can…

  Read the article

• Trouble Avoiding Microsoft Outlook's Email Warning

  - by talbright

  I have a set of records in Microsoft Access that I am trying to send in an Email. The email feature works great. Except a warning message pops up every time a message is ready to send, and the user has to click "Allow" or "Deny" for every email sent. I looked up a workaround, and have been following…

  Read the article

• about option buttons in User form

  - by Mars

  I have a question: I need to create a user form that contain that usual OK and Cancel Buttons. It also should contain two sets of Options buttons, each set placed inside a frame. The captions on the first set should be basketball, baseball, football, the captions on the second set should be watch on…

  Read the article

• ms-access: changing the link to a database

  - by every_answer_gets_a_point

  i have an ms-access database front end that connects to an access backend. i have changed the location of the backend and i need to be able to update the link to it. how do i do this? when i open the front end and try to see data, it says "the microsoft office access database engine cannot open or…

  Read the article

• In MS Access form, how to color background of selected record?

  - by PowerUser

  I have a somewhat complicated looking Access Form with a continuous display (meaning multiple records are shown at once). I'd like to change the background color of the selected record only so the end-user can easily tell which record they are on. I'm thinking of perhaps a conditional format or…

  Read the article

• how can i program this ui box

  - by silverkid

  in what way can this be programmed. a UI box that displays random number between min and max value for 2 seconds then shows blank for 2 seconds then shows another random numer for 2 seconds then shows blank for 10 seonds and then repeats the cycle infitely until form closed. Font of the text to…

  Read the article

• How to access the relative directory of a ASP.NET website?

  - by Michael Schilling

  I need to access a folder that will contain various text files for my web site. I'm using Visual Web Developer 2010 Express. I made a web site using visual basic. Here is the failing code: Dim fileName As String fileName = CurDir.ToString + fileName.Text + ".txt" FileOpen(1, fileName,…

  Read the article

• How to pass a word macro a String parameter

  - by Holograham

  I would like to call a word macro from a java program and pass the macro a search string. Is there anyway to do this?

  Read the article

• Make Excel Defined Names within a worksheet to be global

  - by idazuwaika

  Hi, I wrote Powershell script to copy a worksheet from a workbook A to another workbook B. The worksheet contains define names for ranges within that sheet. Originally, the defined names are global in workbook A, ie. can be referenced from any worksheets within workbook A. But now, after…

  Read the article

• Update access table rst with named cell values from excel

  - by uZI

  I have got a table in access that I loop through using a DAO recordset. For every recordset I take a bunch of data to an excel spreadsheet and run it through a model in excel. This produces a bunch of results in excel which are calculated in named cells. I want to be able to update the…

  Read the article

• How to ensure sequence of functions calling in a Excel sheet

  - by nimo

  Hi, Is there anyway to control the sequence of function calls in a excel sheet when it is re-opened ? Excel automatically re-evaluate the functions when it restarts, where I need to ensure one of my function set is called before another set of function calls. Thank You

  Read the article

• Putting together CSV Cells in Excel with a macro

  - by Eric Kinch

  So, I have a macro to export data into CSV format and it's working great (Code at the bottom). The problem is the data I am putting into it. When I put the data in question in it comes out Firstname,Lastname,username,password,description I'd like to change it so I get …

  Read the article

< Previous Page | 29 30 31 32 33 34 35 36 37 38 39 40  | Next Page >