Welcome to Jonic Developer Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

Recent questions tagged vba

0 votes
1.5k views
0 answers
    I NEED A JOB. GIVE MEE NOW OR ME WILL GET SADS...
asked May 27, 2022 in Jobs[工作] by 与恶龙缠斗过久,自身亦成为 (100 points)
0 votes
1.5k 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 getting an error. It says ... print shtCurrent.PrintPreview End If Next shtCurrent End Sub See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k views
1 answer
    I have the code to copy all the sheets from one excel file to another, but I only have one sheet and when it copies it paste the original as ... Set WB = Nothing Application.EnableEvents = True End Sub See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.6k views
1 answer
    I am having hard time with retrieving range.address which is longer than 255 characters. My range consists of multiple fragmented ranges, its address looks like ... not about returning string, so...yeah. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k views
1 answer
    I want to copy contents of one row in Excel to other row. Currently, I am using following code for copying data from previous row. rngCurrent.Offset(-1) ... in column 4 and 14 of Target row are preserved. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k views
1 answer
    I recently split my database. My form is a calendar with a Tab for Month View, Week View, and Day View with 42, 7, and 7 subforms, respectively ... me know if you need more information. Thanks in advance! See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
2.1k views
1 answer
    I have looked thoroughly at the current answers for this problem and none of them have fixed mine. The operation is simply copying a selection of a ... , SkipBlanks _ :=False, Transpose:=False Thanks, See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.6k views
1 answer
    I'm a newbie at VBA and attempting to understand someone else's code. Set rstClone = Me.RecordsetClone rstClone.MoveFirst Why does the recordset have to ... Why can't the code be Me.Recordset.MoveFirst? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.9k views
1 answer
    We have an Access database running under Office 2010. We have to change to Office 365 and get Run-time error '287': Application-defined or object- ... "CTEstes" & strProcesso & ".Msg", olMSGUnicode See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.4k 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 worksheet A = cell H of worksheet B (contain ... sh2.Cells(j, "L") End If j = j + 4 Next See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.4k views
1 answer
    Consider 2 Excel documents: Excel file A and Excel file B. These Excel files have worksheets inside them (file A has a,b,c worksheets and file B has d,e,f ... in sheet b, is copied in sheet 3, and so on. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.6k 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 has a specific background color. ... Debug.Print IsColor(Rng, 255, 0, 0) End Sub See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.9k 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) into an Access memo field. Trying to call ... , same error. Tried Dmitry's code below, same error. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.6k 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 find a time when the both of the offices are off ... ("00:00:00") 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
2.4k 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 Google Chrome, since I find it faster than ... this with something 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
1.5k views
1 answer
    I need to copy a specific item of text (one or a few words) from Word (2007) to Excel (2007) using an Excel macro, for multiple documents. So far ... t know how to 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
1.5k 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 chemical formulas including, in this order: ... an excel formula or VBA that can do this? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.7k views
1 answer
    I have an excel worksheet where a macro tied to a button draws dynamic shapes based on the user input parameters in the worksheet. I am trying to ... Shp In ActiveSheet.Shapes Shp.Delete Next Shp End Sub See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k 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 absolute or relative. Is there a formatting ... to what pressing F4 does) but as a macro. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k views
1 answer
    I am currently running the below loop to pull out information from another spreadsheet, but keep getting the following error message Compile error: End If without ... Physical" Else: End If End If Next r See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k views
1 answer
    I trying to loop through the message to copy multiple attachments, but no success, i'm getting 13 - type mismatch error!!! Any suggestions will be ... " - " & Err.Description Resume ProgramExit End Sub See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k 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 to Alice. When Bob replies, I want to BCC ... a new chain). 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
1.7k 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 the raw data and contains unnecessary ... г. 26 февруари 2017 г. 26 февруари 2017 г. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.7k views
1 answer
    Sub Sales_Summary_Macro() Dim strMake, strModel, strCount As String Dim makeLoc, modelLoc, countLoc As Integer strMake = Application.InputBox("Make") strModel = ... () alone and neither seem to work. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.6k views
1 answer
    I have written this query: UPDATE tbl_stock1 SET tbl_stock1.weight1 = ( select (b.weight1 - c.weight_in_gram) as temp from tbl_stock1 as b, tbl_sales_item ... Server it will be executed. Thanks, dinesh See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.7k 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 not drop the first three lines. I am ... not cater to drop the first x lines. Any thoughts? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k 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 changes every month) and add the YYYYMM of ... the email so we don't need to create another folder See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.8k 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 in this order: 1 page from Sheet1, 5 pages ... them to print as 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 Jonic Developer Community for programmer and developer-Open, Learning and Share
...