Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: lube8
  • Content: Threads
  • Order by date
  1. lube8

    Formatting Page Setup with Multiple Worksheets and Multiple Workbooks

    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...
  2. lube8

    Open Existing Excel Workbooks from Access module

    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...
  3. lube8

    How to format range of data in Excel workbooks from Access

    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...
  4. lube8

    VB text string = Retrieved records from table within access

    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...

Part and Inventory Search

Back
Top