Sorry Geoff,
Tony and your help has been greatly appreciated. I have been able to implement much of the formatting with the exception of the zoom feature for each tab. I think each sheet needs to become active in order for the excel's worksheet zoom to be modified.
I got the margins to...
Tony,
I know this code works ... I don't know how to implement the page setup formatting from within this code. Do you know how to include any formatting for the page setup of each worksheet within the module I have included?
Tony,
I am having a tough time with the objects and assigning them to make your code work or the code I have already tried. Here is my existing code:
Dim frmtpath As String
frmtpath = "D:\Documents and Settings\stl1cjl\My Documents\dbExtracts\300001.XLS"
Dim objexcelapp As New...
I have several workbooks with several worksheets and each workbook contains a different number of worksheets. I am having a tough time getting the code to format for each sheet within the workbook. I am trying to change margins, make orientation to landscape, repeat top row, and either fit to...
I cannot get the formatting to work for more than one worksheet. I have several workbooks with several worksheets and each workbook contains a different number of worksheets.
I see the code either running away (only formatting the first sheet) or giving me errors with object definition ...
This worked great ... the New Excel.Application object does sound somewhat familiar when I put it in use. Thank you very much ... it has been a great help. The only finishing touches I have is trying to format the pages for each sheet within each workbook.
Do you have a simple procedure for...
xlbo,
I will dim the objExcelApp As New Excel.Application tommorrow. I have not tried this yet.
I cannot format first because the workbooks and worksheets are generated through an access module and created tables that get transferred to excel with filenames created by records within tables...
I am having the toughest time opening existing workbooks in excel from within an access module. I can open a new workbook but I cannot open an existing workbook.
I am trying to apply formatting to several worksheets within several workbooks. My original vba code to transfer data to multiple...
My original vba code to transfer data to multiple sheets is a loop (transferspreadsheet procedure within Access module).
Do I need to write code in my Access module to open each excel workbook and apply this formatting to each worksheet? ... Or can this formatting occur without me opening...
Hello,
I have some existing excel files that are generated from Access. How would I go about formatting the worksheets of these workbooks based on a string that appears in a row?
For example, I would like to have the range of cells (A:G) for each worksheet in each workbook, highlighted in...
What is the VB code for retrieving and looping records from an existing table. I have a table with 25 records and I have some VB code already set up to export my data to excel by a string (I have dim'd) I manually enter into my module. I would like the string to retrieve each record in an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.