Welcome To Ask or Share your Answers For Others

Recent questions tagged Vba

0 votes

2.4k 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

2.3k 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 ... End If Next shtCurrent End Sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.1k 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 ... Application.EnableEvents = True End Sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.2k 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 ... string, so...yeah. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.2k 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 ... 14 of Target row are preserved. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.1k 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 ... more information. Thanks in advance! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.6k 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 ... False, Transpose:=False Thanks, See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.2k 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 ... code be Me.Recordset.MoveFirst? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.4k 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 ... strProcesso & ".Msg", olMSGUnicode See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.0k 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 ... ") End If j = j + 4 Next See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.1k 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 ... in sheet 3, and so on. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.2k 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 ... , 255, 0, 0) End Sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.5k 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) ... Dmitry's code below, same error. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.2k 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 ... 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

3.1k 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 ... 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

2.1k 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 ... 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

2.2k 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 ... or VBA that can do this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.3k 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 ... Shp.Delete Next Shp End Sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.1k 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 ... does) but as a macro. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.2k 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 ... If End If Next r See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.3k 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 - ... .Description Resume ProgramExit End Sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.1k 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 ... 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

2.3k 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 ... 2017 г. 26 февруари 2017 г. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.3k 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 ... neither seem to work. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.2k 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) ... be executed. Thanks, dinesh See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.3k 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 ... first x lines. Any thoughts? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.1k 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 ... 't need to create another folder See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.5k 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 ... one PDF in the order I want? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Page:

1
2
3
4
5
6
...
31
next »

...