Search:

Type: Posts; User: sagain2k; Keyword(s):

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Opening/converting Works .wks files into Excel 2002

    I have a large number of .wks files that were apparently created in Microsoft Works. When I tried opening them in Excel 2002 (with Works 2.0 format), I just get garbage (same as in Word). I did...
  2. Re: Inserting a formula that uses variable for range

    Whoops! A couple typos. It should be:

    Dim testrangestr, RStart, REnd, testrange
    RStart = -4
    REnd = -1

    Range("c5").Select 'SELECTS CELL THE FORMULA WILL BE PUT IN

    'METHODS TRIED FOR...
  3. Inserting a formula that uses variable for range

    I'm having trouble having VBA insert a formula that uses a variable to represent the desired range used in the formula. I can get it to work if I use the method of R and C numbers relative to the...
  4. Replies
    0
    Views
    295

    Outlook forum equal to this Excel forum?

    This is a great forum for Excel and Access issues...can anyone suggest one that is equally good for Outlook? Thanks!
  5. Re: How to add a borderline above each Excel Footer?

    I tried this but got the error message "Unable to set the LeftFooter Property of the PageSetup Class" when it tried to do the line:

    ActiveSheet.PageSetup.LeftFooter = strLine & Format(Now, "DDDD,...
  6. Replies
    14
    Views
    867

    Re: Count number of cell in excel

    I forgot to add that you need to declare the variables as Public in order to pass them on to another procecure:

    Public lastcolwithdata As Integer
    Public lastrowwithdata As Integer
  7. Replies
    14
    Views
    867

    Re: Count number of cell in excel

    Here's a procedure I've found VERY valuable that you can use for situations like this. You end up with the last ROW and Column numbers (in variables "lastrowwithdata" and "lastcolwithdata") that...
  8. How to add a borderline above each Excel Footer?

    I can create Excel Footers no problem, and know how to use footer code to force a particular font or font size, and also a macro that can format the footer date to a particular format, like this:
    ...
  9. VBA in Access to close extra instance of Excel running

    I'm asking this in both Excel and Access forums: I have a button on an Access switchboard form that when clicked runs a query that outputs the results into an Excel workbook called Courses.xls,...
  10. VBA to close extra instance of Excel running

    I have a button on an Access switchboard form that when clicked runs a query that outputs the results into an Excel workbook called Courses.xls, replacing the previous file of the same name (saving...
  11. Re: How to get Access VBA to export query into Excel file

    Thanks for the input. I already can use Excel VBA to import data into an Access table via Transfer Spreadsheet no problem. And can create a "new" occurrence of a named Excel file from exporting an...
  12. How to get Access VBA to export query into Excel file

    I have an Access macro that currently exports an Access query into a new Excel workbook with a given path and name. Not getting any response from the Access forum so I'm trying here too. How can you...
  13. Exporting Access Query data into existing Excel Workbook?

    I have a macro that currently exports a query into a new Excel workbook with a given path and name. How can you tell it to export (insert) into an exisitng Excel workbook instead? Here's the...
  14. How to have VBA select only visible results of Adv Filter

    I have a file that contains data with the top rows defined as a Criteria range for an Advanced filter. Here's the code to do the Adv Filter:

    Range(Cells(6, 1), Cells(lastrowwithdata,...
  15. Re: Using Recordset.Find to update Access Table from Excel

    Whoops...Here's what the start of the code was:

    Private Sub UpdateAccessUDR()
    '
    Dim AccTable 'The variable for Access
    Dim dbMain As New ADODB.Connection

    This gave a compile error:...
  16. Using Recordset.Find to update Access Table from Excel

    I'm trying to use this Recordset method to check data in an Excel spreadsheet and update to an Access table, but am having problems:

    'rsRecordset.Find(criteria,skiprows,direction,start)

    I got...
  17. Replies
    5
    Views
    1,046

    Re: Appending Excel data to an Access Table

    Thanks for the suggestion(s)! A couple questions...in the example (e.g.):

    Global Const SW_HIDE = 0
    Global Const SW_SHOWNORMAL = 1
    Global Const SW_SHOWMINIMIZED = 2
    Global Const...
  18. Re: Window position issue when launch Access from Excel VBA

    I noticed a typo that needed correcting (wrong filename variable)--here's the corrected code. FnameTest and FnameTemp were defined as Public:

    Public FnameTest
    Public FnameTemp...
  19. Window pos issue when launch Access from Excel VBA

    Posting this in both the Excel & Access forums just in case:

    I can launch Access from an Excel macro fine like this:
    -----------------------------
    Sub ActivateAccess()
    Dim appAccess As Object...
  20. Window position issue when launch Access from Excel VBA

    I can launch Access from an Excel macro fine like this:
    -----------------------------
    Sub ActivateAccess()
    Dim appAccess As Object
    FnameTest = "Testfile.mdb"
    DocPath = "D:\Data\Dbase"
    ...
  21. Replies
    5
    Views
    1,046

    Re: Appending Excel data to an Access Table

    Bat17...thanks much! I tried this hyperlink method you suggested:

    ActiveWorkbook.FollowHyperlink Address:="C:\db1.mdb", NewWindow:=True

    And it worked! I'm using a Switchboard in Access so...
  22. Replies
    5
    Views
    1,046

    Appending Excel data to an Access Table

    I posted this in the Excel forum just in case....

    If I have an Excel worksheet of data that matches the fields (columns) in an Access table, what's the best VBA code that lets you append the...
  23. How to append Excel data to Access Table w/ VBA

    If I have an Excel worksheet of data that matches the fields (columns) in an Access table, what's the best VBA code that lets you append the entire Excel range of data to the end of the matching...
  24. Replies
    8
    Views
    1,115

    Re: Keeping leading zeros for zipcode values

    Thanks for the responses. Zack: the reason I needed to capture the leading zeros is the source data is all the zip code data looked like this, with some leading zeros and not all the same # digits:...
  25. Re: Switching between applications within an Excel macro

    Colo---thanks very much! This just what I was looking for! I've got most of it working the way I want to, with a few things to still figure out.

    Any suggestions on how best to be sure the Excel...
Results 1 to 25 of 94
Page 1 of 4 1 2 3 4