Welcome to OverStack Developer Community-Open, Learning,Share
Welcome To Ask or Share your Answers For Others

Categories

Recent questions tagged vba

0 votes
437 views
0 answers
    I NEED A JOB. GIVE MEE NOW OR ME WILL GET SADS...
asked May 27 in Jobs[工作] by 与恶龙缠斗过久,自身亦成为 (100 points)
0 votes
513 views
1 answer
    I have a debugging problem for homework in class and I made the changes I saw that were necessary but I am ... End If Next shtCurrent End Sub See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
506 views
1 answer
    I have the code to copy all the sheets from one excel file to another, but I only have one sheet ... Application.EnableEvents = True End Sub See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
601 views
1 answer
    I am having hard time with retrieving range.address which is longer than 255 characters. My range consists of multiple ... string, so...yeah. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
514 views
1 answer
    I want to copy contents of one row in Excel to other row. Currently, I am using following code for copying ... 14 of Target row are preserved. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
497 views
1 answer
    I recently split my database. My form is a calendar with a Tab for Month View, Week View, and Day View ... more information. Thanks in advance! See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
904 views
1 answer
    I have looked thoroughly at the current answers for this problem and none of them have fixed mine. The ... False, Transpose:=False Thanks, See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
591 views
1 answer
    I'm a newbie at VBA and attempting to understand someone else's code. Set rstClone = Me.RecordsetClone ... code be Me.Recordset.MoveFirst? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
796 views
1 answer
    We have an Access database running under Office 2010. We have to change to Office 365 and get Run-time ... strProcesso & ".Msg", olMSGUnicode See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
494 views
1 answer
    Here's what I would like to do: IF cell H of worksheet A = cell E of worksheet B (contain words) and cell J of ... ") End If j = j + 4 Next See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
457 views
1 answer
    Consider 2 Excel documents: Excel file A and Excel file B. These Excel files have worksheets inside them (file A has ... in sheet 3, and so on. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
696 views
1 answer
    I am trying to get write a simple function one can call from a cell that would return if the background of a given cell ... , 255, 0, 0) End Sub See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
765 views
1 answer
    I'm developing a drag and drop of a MailItem from Outlook (I know it's a MailItem and not any other type) ... Dmitry's code below, same error. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
489 views
1 answer
    I have an MS Access app which is used in two different time zones. The difference is 7 hours. I needed to ... Then DoCmd.Quit End If End Sub See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.3k views
1 answer
    I know how to work with Excel VBA and IE, but I would like to know if it's possible to work with ... that will launch Chrome instead of IE? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
592 views
1 answer
    I need to copy a specific item of text (one or a few words) from Word (2007) to Excel (2007) using ... copy the clipboard to an Excel variable. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
443 views
1 answer
    Apologies if this has already been asked and answered but I couldn't find a satisfactory answer. I have a list of ... or VBA that can do this? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
705 views
1 answer
    I have an excel worksheet where a macro tied to a button draws dynamic shapes based on the user input parameters ... Shp.Delete Next Shp End Sub See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
556 views
1 answer
    I want to write a macro which goes through all cell references in a selection's cells formula and changes them to ... does) but as a macro. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
564 views
1 answer
    I am currently running the below loop to pull out information from another spreadsheet, but keep getting the following ... If End If Next r See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
523 views
1 answer
    I trying to loop through the message to copy multiple attachments, but no success, i'm getting 13 - ... .Description Resume ProgramExit End Sub See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
532 views
1 answer
    Given a MailItem, how do I tell if it's a reply to another email? Alice sends an email to Bob. Bob replies ... How can I do that, if possible? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
683 views
1 answer
    I'm using an app that exports certain data to a CSV format. The date column, however, is not properly format in ... 2017 г. 26 февруари 2017 г. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
704 views
1 answer
    Sub Sales_Summary_Macro() Dim strMake, strModel, strCount As String Dim makeLoc, modelLoc, countLoc As Integer strMake ... neither seem to work. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
568 views
1 answer
    I have written this query: UPDATE tbl_stock1 SET tbl_stock1.weight1 = ( select (b.weight1 - c.weight_in_gram) ... be executed. Thanks, dinesh See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
636 views
1 answer
    I need to skip the first three lines of a CSV file when loading into MS Access. The default CSV import does ... first x lines. Any thoughts? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
535 views
1 answer
    i 'm trying to get a VBA macro in Outlook that will save an email's attachment to a specific folder (that ... 't need to create another folder See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
720 views
1 answer
    I am trying to export pages from two different sheets of a workbook as 1 PDF. However, I want the pages to be ... one PDF in the order I want? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
Ask a question:
Welcome to OverStack Developer Community-Open, Learning and Share
...