Recent questions tagged vba

0 votes

684 views

0 answers

WHO GET JOB HERE ME NEEEDS

I NEED A JOB. GIVE MEE NOW OR ME WILL GET SADS...

asked May 27, 2022 in Jobs[工作] by 与恶龙缠斗过久,自身亦成为 (100 points)

0 votes

708 views

1 answer

vba - Issue looping through worksheets in a workbook

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

697 views

1 answer

vba - Tweak code to copy sheet1 of a excel file to sheet1 new excel file

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

744 views

1 answer

vba - How to retrieve range.address which is longer than 255 character?

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

681 views

1 answer

vba - Exclude some columns while copying one row to other

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

653 views

1 answer

vba - Getting Error 3048: Cannot open any more databases

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

1.1k views

1 answer

vba - Paste Special error 1004 PasteSpecial method of Range class failed

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

752 views

1 answer

vba - Why clone an MS-Access recordset?

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.0k views

1 answer

vba - "Run-time error '287': Application-defined or object-defined error" while using CurrentItem.Saveas or CurrentItem.HTMLBody in Outlook 2016

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

659 views

1 answer

vba - Compare and copy data between worksheets

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

615 views

1 answer

vba - copying worksheets from one Excel document to another

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

837 views

1 answer

vba - Getting cell Interior Color Fails when range passed from Worksheet function

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

974 views

1 answer

vba - MailItem.SaveAs when referencing with EntryID

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

680 views

1 answer

vba - Convert UTC time to local

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

1.6k views

1 answer

vba - Using Chrome browser instead of InternetExplorer.Application

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

701 views

1 answer

vba - How can I copy one section of text from Word to Excel using an Excel macro?

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

604 views

1 answer

vba - Extract numbers from chemical formula

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

889 views

1 answer

vba - Delete all shapes in excel worksheet except form controls

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

696 views

1 answer

vba - Change Cell Reference between Absolute and Relative

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

723 views

1 answer

vba - Compile error: End If without block If

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

686 views

1 answer

vba - Loop through to copy multiple outlook attachments type mismatch error

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

704 views

1 answer

vba - Checking if a MailItem is a reply

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

847 views

1 answer

vba - Find/replace macro that properly formats a date cell

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

867 views

1 answer

vba - Match Not working Excel: Error 1004 Unable to get the Match Property

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

697 views

1 answer

vba - Operation must use an updatable query. (Error 3073)

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

820 views

1 answer

vba - Skip first three lines of CSV file (using DoCmd?) in MS Access

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

711 views

1 answer

vba - Save attachment from an email in to a folder that changes every month

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

908 views

1 answer

vba - Exporting multiple pages to PDF in a specific order

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)

Categories

Just Browsing Browsing

Most popular tags