Search Result

hd95 · May 16 '12, 09:25 PM

I know how to select 1 sheet or all sheets for an export command, but how would I for example, select "sheet1" and "sheet3" while ignoring "sheet2"?

BeachBummin · Feb 9 '12, 11:18 PM

Hello,

I have a listbox populated with a series of queries. I am trying to write code so the user selects the query from the list and clicks and export command button.

Code:

Private Sub cmdExport_Click()
Dim strQuerySelect As String
Dim lstQueryBox As ListBox

strQuerySelect = lstQueryList.Value

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, strQuerySelect, "C:\Documents

...

OASys1 · Feb 4 '12, 05:26 AM

Hello ...

I have an Access 2007 app, and I need a routine to export all table data, and then import this table data into a new version of my compiled stand alone executable Access app.

I came across a situation that halted using spreadsheets as an intermediary. My customer table contains a field called "attachment s" which holds.... yeah you guessed it.... attachments ! : - )
.
I lose the attachments...

harry2012 · Jan 24 '12, 08:41 AM

Hello,

I do have an access form called T4, which is exported to an excel file, where i do have complex formulas and calculations.

I would some assistance in exporting the table to excel. I cannot re-write the excel file every time the form is edited. When i execute the macro to export them to excel, it gives an error.

Here is the code:

Code:

Option Compare Database
 
Function MacroT4()

...

jbrumbau · Oct 31 '11, 03:10 PM

Hello,

I had a database user click on the "Export to Excel" button in the ribbon to try and export a report to excel when I already have a button on a report selector that runs VBA code I created to copy data into an excel templated report.

My question is how can I reroute the ribbon button to my code that works correctly? Or if that can't be done, how do I hide the button from all users?

Thanks...

hsriat · Sep 7 '11, 09:43 AM

I have a module from which I am importing a couple of methods. Here is the code:

Code:

package MyEncoder;
use strict;
use Exporter qw(import)
use vars qw(@EXPORT);
@EXPORT = qw(encode decode);

sub encode { ... }
sub decode { ... }

1;

Now what I want is, if I use this in some module ,say MyBase, encode & decode methods should be availabe to all the child classes of My...

havanna · Jun 7 '11, 05:36 PM

I have some russian strings in Access (2000 Version and no way to upgrade, sorry, and VBA isn't my biggest strength)
Exporting those tables to excel works fine, but I can't manage to export in a script to a flat text file, instead I get the dreaded ??????????.

Is there a way to do it?

Arne Vanhoof · Apr 27 '11, 11:17 AM

Hi all,

First of all I will try to explain what I want to achieve.

In my Access database I will export some queries to serveral worksheets within the same workbook.
However I want the different worksheets immediately in a table format.

This is the solution I have at the moment:

With regard to the export I use:

Code:

 .TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "Queryname",

...

Jinzuku · Feb 17 '11, 03:25 PM

Hi,

I'm trying to map an export function to a command button to my Access form (called Results). However, I would like it so that the "Save As" window appears when I try to export the table so that the user can select where they want to save the spreadsheet.

The VBA code forces you to extract to a certain place, which isn't practical for my data's intended use. I've tried using a macro but that automatically...

tdlr · Jan 12 '11, 02:24 PM

Hello,

I've just created a blender animation with 5000 frames. Now I need to export it so that it fits the following requirements:
- It needs to be fluent at a transfer rate of only 1000kbit/s
- Flash would be highly appreciated

These requirements are not my own but they are just there.
So now because blender has no way of exporting to flash, there's no easy way for me out.
Also, which resolution...

Ivan Stefanov · Dec 3 '10, 11:12 AM

Hello, I have the following problem:
I created a website project and I want in that website to be make a button, which will export some data in an excel file. This is the code that I have:

Code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Excel = Microsoft.Office.Interop.Excel;

...

RajeshPune · Sep 22 '10, 11:52 AM

We are deveopingawebis te in asp.net. There are tempelates of each aspx page made in the form of excel sheet. Upon completion of the online calculation, the user is to be allowed to export the results to excel and save them. There would be obviously no formulae in such sheet
I do not want to install Excel on theserver and instead want to utilize the Excel installed on the user's computer for this purpose as every user's computer is expected...

andrern2000 · Sep 1 '10, 07:36 AM

VB 6 with bundled Crystal Reports 4.6.10.

So I have created a .rpt with built-in Report Designer. I'm able to print to window by Crystalreport1. printReport method.
But the when the Export button inside the window is clicked, nothing happens. Then I changed to PrintToFile and specify the filetype to Text, set filename. No working.

Then I go into Report Designer itself, click the Export button and voila!.. The Export...

Rebecca McCallan · Aug 25 '10, 08:47 AM

I have exported some data from Access to Excel (2010) and once exported to access the data is in a different order from when it was in the query. The data is all under the correct headers but each column is randomly ordered. The query is in the following order (by fieldnames) CompanyName, CompanyAddress, TownCity, Postcode, ContactNumber1, WebsiteAddress, VATNumber, CompanyContact and CompanyType. The export comes out in this order (by header names)...

dsatino · Aug 5 '10, 06:28 PM

Ok, I admit there's info on this out there already but it's kind of scattered and usually specific to a problem, so stick with me for a second. I'm not looking for any specifics, just generally how to go about the following:

From Access VBA I need to:

Launch Excel
Create a new workbook
Create worksheets
Move around the worksheet cells
Edit cells

If anyone can give me any library...

Search Result

How do I select multiple SPECIFIC sheets from an Excel Workbook?

Referencing listbox value in export code

Automated Export and Import routines from within Access via command button

How can i re-write the excel file when exporting an access table

How to Disable or Reroute Export to Excel Button in Ribbon?

methods imported once should be available to all child classes

exporting unicode strings from Access with VBA

VBA: Export query to Excel and format as table

How do I open the "Save As" window when I export my data from Access to Excel?

Best way to export blender animation for the web?

How to make a website that is able to export an excel file?

How to export results in aspx sheet to Excel without installing Excel on server?

Cannot export from CrptWindow, but can from Report Designer?

Export details coming up in random order

Output Access Data to Excel