Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Macro to copy multiple Excel ranges and paste on same slide in PowerPoint

    I have a number of ranges in Excel that I'd like to copy and be able to paste into the same slide in an already created PPT presentation. With the below code that I've put together, for some reason...
  2. Calculate Confidence Interval for Binary Data Set

    Hi -

    I have a data set that is organized by date in column A and then in column B it is binary data of 0's and 1's where 1 means the customer was declined and 0 means it was not. Each week I...
  3. Replies
    0
    Views
    693

    Save As PowerPoint File from Excel VBA

    Hi -

    I have a macro that opens a powerpoint presentation and updates linked graphs. I was able to figure out how to get the VBA to save and close the presentation, but because this is a weekly...
  4. Re: From Excel 2013 VBA Open PowerPoint 2013 and Update Links

    Thank you! Your code worked perfectly. I didn't realize I'd need an error statement to keep the query going and prevent the macro from stopping, but your explanation makes perfect sense. Thanks...
  5. From Excel 2013 VBA Open PowerPoint 2013 and Update Links

    Hi. I have an excel workbook that is automatically updated with new data that then changes charts embedded into the workbook on a weekly basis. I also have a powerpoint deck that has those charts as...
  6. Re: VBA Macro to compare 2 sheets for only specified rows

    Hi JLGWhiz,

    Thank you so much. This worked. The unique ID is in Column A for both sheets. Sorry for not clearly outlining that in the original post. Thanks again! You saved me a lot of time...
  7. VBA Macro to compare 2 sheets for only specified rows

    Hi - I have found a number of great posts that show how to compare 2 spreadsheets and highlight the differences. I would like to be able to do something a bit different, because my 2 spreadsheets are...
  8. Replies
    5
    Views
    3,779

    Re: VBA Check if Partial File Name Exists

    I was able to figure it out. Needed to add the pSTR to the beginning of the DIR(pSTR & dirFile). Thanks again for your help!



    Sub BusinessObjectsRetrieve()


    Dim pSTR As String
    Dim strFile...
  9. Replies
    5
    Views
    3,779

    Re: VBA Check if Partial File Name Exists

    Thanks for your reply, Joe. I am still getting an error on that one. I tried a couple message boxes to see what was being captured in those variables and it looks like it is identifying the correct...
  10. Replies
    5
    Views
    3,779

    VBA Check if Partial File Name Exists

    Hi - I am trying to write a macro that will open a workbook if it exists. The workbook that will be opening always starts with the same characters, but the end of the file name varies based on date....
  11. Replies
    4
    Views
    4,995

    Re: CopyFromRecordset Limit? Alternative?

    Hi Norie - thanks for your help. It actually turned out not to be a problem with the code, but rather in one of the fields in the database, there was an entry that exceeded the character limit which...
  12. Replies
    4
    Views
    4,995

    Re: CopyFromRecordset Limit? Alternative?

    Hi Norie -

    Thanks for your fast response. I am getting an error that says "Method 'copyfromrecordset' of object 'Range' failed. The records are coming from an Access database and being pasted...
  13. Replies
    4
    Views
    4,995

    CopyFromRecordset Limit? Alternative?

    Hi Forum -

    I have a bit of an emergency with a workbook that I have built. I have buttons in a workbook that when pressed, they are supposed to connect to an Access database via an ADO connection...
  14. Excel Error: System Error &H80040111(-2147221231). Class Factory cannot supply requested Class

    Hi Forum -

    I have built an Excel add-in and distributed it across our team. The add-in was built in a Windows 7 machine running Office 2007. Since being distributed there have been folks trying...
  15. VBA Excel 2007 to Run Macro in Password Protected Access 2007 DB

    Hello Forum -

    I am trying to write a module in Excel so that when it is run, it opens up an Access Database saved on my hard drive and runs a macro. The following code works well and runs the...
  16. Replies
    4
    Views
    308

    Re: Loop to check if fields are filled in

    Thanks, TJ. This works well!

    I don't see a like button anywhere for your answer but you definitely solved my problem! Thanks! :)
  17. Replies
    4
    Views
    308

    Re: Loop to check if fields are filled in

    Hi TJ - thanks for your response. I am getting a syntax error when I remove the last "_" on the last then. Any idea why or how to fix it?

    Thanks again.
  18. Replies
    4
    Views
    308

    Loop to check if fields are filled in

    Hello Mr.Excel forum -

    I have a function in my workbook that when selected, the data on the worksheet saves to a connected database. All of that functionality works well. I am now trying to...
  19. Re: Help with Nested If Statements for Access Form

    The code is being triggered by a search button that is on the form. So all of the code resides under a module called button_lookup_click(). That part I know is working because when the form just had...
  20. Re: Help with Nested If Statements for Access Form

    Hi Terry -

    Sorry, I should have explained a little better. Basically the userform gives the user the choice to search by 3 different numbers. So there are three different input boxes where the...
  21. Help with Nested If Statements for Access Form

    Hello Access Wizards...

    I have a userform stored in Access that is supposed to perform a lookup using a number inputted by the user and it pulls in stored data that corresponds to that number....
  22. Re: Run Time Error 3706 - Excel 2007/Access 2007

    I was able to figure it out. It was in the connection string. Should have been:


    cnn.Open "Provider=Microsoft.Ace.OLEDB.120.0;" & _
    "Data Source=" & strFilePath & ";"


    However I am...
  23. Run Time Error 3706 - Excel 2007/Access 2007

    I would like to be able to open a connection between an Excel 2007 file and an Access 2007 file to bring in a table from an already established Access database. I know that to do so, you need certain...
  24. Re: If Statements to Prevent Form From Inputting w/ Missing Fields

    Thank you so much! You solved my problem!
  25. Re: If Statements to Prevent Form From Inputting w/ Missing Fields

    Ok. So the solution that Brian recommended didn't work for me. I assume I am doing something wrong in the implementation of it? I tried one more thing which works for me somewhat. I have an if...
Results 1 to 25 of 76
Page 1 of 4 1 2 3 4