logo
down
shadow

VBA QUESTIONS

How do I pass a Range to a Sub in Word VBA?
How do I pass a Range to a Sub in Word VBA?
this will help It is not allowed to call a Sub with parenthesis, except if you are using the Call statement.Hence you have to use either:
TAG : vba
Date : November 24 2020, 07:00 PM , By : user3862810
How to create an addin for PowerPoint 2003
How to create an addin for PowerPoint 2003
hop of those help? Create a new module and add the below autoopen function. You would need to save the file as ppa in the addins folder.
TAG : vba
Date : November 23 2020, 07:00 PM , By : user3862523
How to split a string in VBA by more than one character
How to split a string in VBA by more than one character
may help you . In my attempt, I replace all the other characters with space before splitting on space. (So I cheat a little.)
TAG : vba
Date : November 17 2020, 07:01 PM , By : Mishty
BCC in ItemSend event in Outlook 2007 no longer works
BCC in ItemSend event in Outlook 2007 no longer works
wish of those help I inserted code in ItemSend and saved the ThisOutlookSession module. It worked once and no longer works. It was saved as VBAproject.OTM and is still there when I open the module after restarting Outlook. , use and if statement on t
TAG : vba
Date : November 12 2020, 07:00 PM , By : Adam Goldsmith
ArcObjects - enumerating feature classes and datasets within a geodatabase
ArcObjects - enumerating feature classes and datasets within a geodatabase
I wish this helpful for you It is much faster to enumerate the names contained in a geodatabase instead of the things that the names can open. The tricky part is looping through names in a featuredataset. While IFeatureWorkspace.Open can be used to o
TAG : vba
Date : November 10 2020, 07:00 PM , By : Fairy-Wilbury
Hidden pitfalls of VBA
Hidden pitfalls of VBA
help you fix your problem This question is meant to augment the Hidden Features question at Hidden features of VBA , The whole language?Eh, I'll be concrete: the fact that:
TAG : vba
Date : November 08 2020, 07:01 PM , By : user3857669
VBA How to get all enum
VBA How to get all enum
should help you out This article Pearson Software Consulting:Enum Variable Type would have you use the underscore to define hidden Enumeration values to used in a loop like this:
TAG : vba
Date : November 05 2020, 07:01 PM , By : Enosh Zerahia
Auto accept outlook VBA
Auto accept outlook VBA
I hope this helps . I have used this in the past add this sub into VBA page and the wire up your rule so that it fires when you receive it from certian senders and ita meeting invite or update.
TAG : vba
Date : November 04 2020, 07:01 PM , By : user3856283
Searching a document for multiple terms in VBA?
Searching a document for multiple terms in VBA?
With these it helps I'm trying to create a macro to be used in Microsoft Word 2007 that will search a document for multiple keywords (string variables) located in an external Excel file (the reason for having it in an external file is that the terms
TAG : vba
Date : November 03 2020, 07:01 PM , By : CodingDork
Passing argument(s) to a module private function/sub
Passing argument(s) to a module private function/sub
Any of those help It is not a good idea to call private functions from outside their scope, because they are private for a reason, and the reason is not to be called from anywhere, but from the specific module in which they reside.Anyway, for any oth
TAG : vba
Date : October 14 2020, 04:00 AM , By : Dario Barrotta
How to get inner text under span id
How to get inner text under span id
it helps some times I am working on a vba web automation project . I have come to a point where I have to get the message displayed on the web form in excel sheet. The HTML codes of the relevent section are as follows.
TAG : vba
Date : October 13 2020, 10:00 PM , By : Tanvir Hasan
How to prevent UiPath from getting stuck in Call Macro Stage?
How to prevent UiPath from getting stuck in Call Macro Stage?
seems to work fine There is a way to do this, let me try to present it to you:You will need 3 variables for your solution as per below:
TAG : vba
Date : October 13 2020, 04:00 PM , By : Varun Chalamgari
How do I speed up a double for loop with if in the inner loop in vba?
How do I speed up a double for loop with if in the inner loop in vba?
wish of those help I've written this code to search a match in a column of sheet "q1" with the elements of another column in sheet "Complete Car". Since I have 3000 rows to check in Complete Car and 1500 in q1 (inner loop), is there any suggestion on
TAG : vba
Date : October 13 2020, 04:00 PM , By : Hamam
MS Access Temp tables
MS Access Temp tables
Any of those help You can use a compact and repair after you're finished. That clears all temporary tables.In my experience, performance tends to increase, not decrease, after a compact and repair. The process itself, however, can take a little time
TAG : vba
Date : October 13 2020, 09:00 AM , By : user6025424
why msg box is not working when i try to run a loop with VBA
why msg box is not working when i try to run a loop with VBA
will be helpful for those in need Please see below your corrected code, checking column "A" though. See comments for further details:
TAG : vba
Date : October 13 2020, 12:00 AM , By : Charan Srikakulapu
VBA code for giving slides a constant name
VBA code for giving slides a constant name
Any of those help @Asger's suggestion would work but a more consistent approach (IMO) would be to use tags. Any presentation, slide, or shape on a slide can have one or more bits of text attached in the form of a tag.For example:
TAG : vba
Date : October 12 2020, 10:00 PM , By : Barry
Mergefield for objectname of PDF using Access and VBA
Mergefield for objectname of PDF using Access and VBA
fixed the issue. Will look into that further Accomplish this by concatenating static text with variable input.Can reference controls on form that have values input/selected by user. If you want project name as well as month/year:
TAG : vba
Date : October 12 2020, 01:00 PM , By : ranga ravindra srira
How do I properly use if/then for a bolean value in order to make an object visible?
How do I properly use if/then for a bolean value in order to make an object visible?
I think the issue was by ths following , Handle the control's Change event, and then you can assign to its value:
TAG : vba
Date : October 12 2020, 11:00 AM , By : Karina Kirby
Is it possible to display a userform and executes a code bellow the .show method?
Is it possible to display a userform and executes a code bellow the .show method?
Does that help I want to display Userform2 from Userform1 then continue executing some code in Userform1 WITHOUT unloading Userform1 , Not sure that's what you want, but this would do what you describe:
TAG : vba
Date : October 12 2020, 08:00 AM , By : dtjr
Nested dictionary object not found
Nested dictionary object not found
I hope this helps . Not a complete answer -- I set up an example without the MS Access-specific parts and the logic in your code seems to run fine. As near as I can tell, there's no real difference in the logic below and your code above. Does this ex
TAG : vba
Date : October 11 2020, 07:00 AM , By : ParanoiaComplex
The code in this project must be updated for use on 64-bit systems
The code in this project must be updated for use on 64-bit systems
it should still fix some issue Upgrading companies software without extensive test is amateurish!But if that error message is the only problem you are lucky. You need to convert the api arguments declaration to x64, what usually means change allLongd
TAG : vba
Date : October 11 2020, 03:00 AM , By : Ravindra Jain
Access error 2683 - There is no object in this control
Access error 2683 - There is no object in this control
I hope this helps you . I've read that the new versions of Office don't support this anymore and I should use the native datepicker.
TAG : vba
Date : October 10 2020, 11:00 PM , By : Dries De Witte
How do I replace one variable with another for an entire column
How do I replace one variable with another for an entire column
Any of those help Single is a data type used for describing "single-precision floating-point numbers".You want String.
TAG : vba
Date : October 10 2020, 10:00 PM , By : Segio
Access VBA: Shell command broken in one particular database
Access VBA: Shell command broken in one particular database
fixed the issue. Will look into that further The culprit was our anti-virus software! UGH!Why did it work in one database and not the other then? I'm told that years ago, anti-virus exceptions were made for my computer for the one database but not th
TAG : vba
Date : October 10 2020, 07:00 PM , By : Scott
Replacing text with StoryRange on Word VBA makes it briefly unresponsive
Replacing text with StoryRange on Word VBA makes it briefly unresponsive
fixed the issue. Will look into that further Your code is lacking context - specifically regarding footerfindreplace.Item(i).FND and footerfindreplace.Item(i).replc. You're code is also processing all storyranges (which includes headers footers), th
TAG : vba
Date : October 10 2020, 01:00 PM , By : S. Yong
Turn off "The record source specified on this form does not exist" warning
Turn off "The record source specified on this form does not exist" warning
To fix this issue You could leave the RecordSource empty or assign it some (empty) dummy record.When you set the RecordSource to its actual value, the subform will automatically requery.
TAG : vba
Date : October 10 2020, 10:00 AM , By : Madhusara Maheshka
How to programmatically access "message bar" in Outlook?
How to programmatically access "message bar" in Outlook?
it fixes the issue The area you are referring to is used to implement Mail Tips. Although you can create custom ones through the Exchange Admin Center , they cannot be interacted with via code.Manipulating Ribbon controls to show states or user messa
TAG : vba
Date : October 10 2020, 05:00 AM , By : Mohammad nasim
In Access VBA how does one keep a textbox active and select all its contents after Enter key
In Access VBA how does one keep a textbox active and select all its contents after Enter key
it helps some times The solution I came up with is to intercept the Enter key press. It is important to cancel the event, otherwise the Enter key will remove the selection.
TAG : vba
Date : October 09 2020, 03:00 PM , By : Mario
Why do I need Int function
Why do I need Int function
it should still fix some issue The reason for the Int() function is that Range.Count * Rnd can return a decimal value over 0.50. When this happens the value will be rounded up, which will give you an upper bounds 1 high than intended.
TAG : vba
Date : October 09 2020, 05:00 AM , By : Linguere
How to get "Instance name" of the selected parts in tree
How to get "Instance name" of the selected parts in tree
help you fix your problem I'm writing macro that will make BOM list from the selected parts in assembly. , You need to select Products if you want instance-ness. So...
TAG : vba
Date : October 09 2020, 12:00 AM , By : Patrick
Unable to show my images in PowerPoint Ribbon
Unable to show my images in PowerPoint Ribbon
I wish this helpful for you The Ribbon XML code looks good. I don't see anything strange in your code.I'd suggest checking the following points:
TAG : vba
Date : October 08 2020, 01:00 PM , By : djse
Why does this vba code works different depending on whether I'm debugging or running it?
Why does this vba code works different depending on whether I'm debugging or running it?
this will help I'm trying to code a macro to copy specific values from a worksheet to another. When I run the code it works just fine, but if I run it, it doesn't. , In a standard code module:
TAG : vba
Date : October 08 2020, 08:00 AM , By : Ken Huang
Shell command does not return the correct result
Shell command does not return the correct result
I hope this helps . Not all commands passed to the Shell function will work as it does in the Command Prompt window. The Shell function is meant to run an executable file, not execute commands:
TAG : vba
Date : October 08 2020, 08:00 AM , By : Arturo
Table field defined as CHAR has values with trailing spaces
Table field defined as CHAR has values with trailing spaces
Hope that helps In Access DDL, a CHAR column is fixed-length, 255 characters. Values inserted into that column will be padded with spaces to the full 255 characters.If you want a variable-length column use TEXT instead. The default maximum length is
TAG : vba
Date : October 08 2020, 04:00 AM , By : LinYun Xie
What is the quickest way to split a powerpoint file multiple slides into multiple files of 1 slide?
What is the quickest way to split a powerpoint file multiple slides into multiple files of 1 slide?
seems to work fine Assuming you meant "create 50 presentations", this will work. Create the destination folder before running the code:
TAG : vba
Date : October 08 2020, 12:00 AM , By : knetsov
What exactly is the VBA/VB6 Collection?
What exactly is the VBA/VB6 Collection?
Hope this helps I doubt you'll find much of anything regarding the implementation details of VBA.Collection. (Official usage reference at https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/collection-object)The general
TAG : vba
Date : October 07 2020, 10:00 PM , By : Shaan AIIT Noida
Why declare a New Type within a VBA Class Module?
Why declare a New Type within a VBA Class Module?
it should still fix some issue Most properties need a backing field. Typically it would look like this:
TAG : vba
Date : October 07 2020, 02:00 PM , By : MarieFrance Est Dans
Copying records in Access VBA
Copying records in Access VBA
I think the issue was by ths following , Could be something like this in your Click event of the EndOfDay button on the main form:
TAG : vba
Date : October 07 2020, 01:00 PM , By : cscastro
MSXML2.XMLHTTP method data extraction issue
MSXML2.XMLHTTP method data extraction issue
I wish did fix the issue. The following will print out all. You can sort where to write the values to
TAG : vba
Date : October 06 2020, 04:00 PM , By : Bambam Bracken
VBA Runtime Error 5941 on Copying Multiple Tables from one document to other one by one in MS Word
VBA Runtime Error 5941 on Copying Multiple Tables from one document to other one by one in MS Word
help you fix your problem As mentioned in a comment, the problem is due to the use of Selection and ActiveDocument. For this reason, it's preferable to work with specific objects, rather than generalizations. If an object for each document is declare
TAG : vba
Date : October 05 2020, 11:00 PM , By : Ian Dor
Problem with Mkdir Runtime Error 76 path not found
Problem with Mkdir Runtime Error 76 path not found
I wish this helpful for you Cause of issue MS Word table cell text ends with two invisible characters to indicate end of cell:
TAG : vba
Date : October 05 2020, 07:00 PM , By : sunil pai
Fastest way to pull getTable() Recipient Email Addresses in Outlook VBA
Fastest way to pull getTable() Recipient Email Addresses in Outlook VBA
I hope this helps you . Recipient information cannot be pulled from a MAPI table. The best you can do is PR_DISPLAY_TO / PR_DISPLAY_CC / PR_DISPLAY_BCC, but these message properties do not (in general) contain email addresses or entry ids.You can cre
TAG : vba
Date : October 05 2020, 10:00 AM , By : Neil
How to use a message box to open a new set of code and run it?
How to use a message box to open a new set of code and run it?
wish helps you So what I have been doing is running my first set of code which will open new workbooks with specific data and then pasting different code into the new workbooks made and running it. , You can do this:
TAG : vba
Date : October 05 2020, 10:00 AM , By : Richard
How to set decimal separator in MS Access using VBA?
How to set decimal separator in MS Access using VBA?
fixed the issue. Will look into that further My software creates PAIN001.XML files directly from an Access financial database. The decimal separator must always be a dot. The numbers are formatted with: , The decimal separator must always be a dot.
TAG : vba
Date : October 04 2020, 08:00 PM , By : Incipient Dani
Rename a field in access vba
Rename a field in access vba
will be helpful for those in need I need to rename a field name in VBA access code to automate things so it works faster. I am using a button to move some data around and need to change the column names, as a result, to clean things up. I am working
TAG : vba
Date : October 04 2020, 05:00 PM , By : Nishant
Ms Access VBA: How do I run a Sub Procedure that is stored in one DB on another DB?
Ms Access VBA: How do I run a Sub Procedure that is stored in one DB on another DB?
Does that help The problem is that (most likely) you are trying to run a procedure that isnt there. If i were you I would either:
TAG : vba
Date : October 04 2020, 12:00 AM , By : vikas garg
How to handle missing MAPI properties?
How to handle missing MAPI properties?
I wish this helpful for you That exception is by design - you must handle it. It is no doubt easier in languages other than VBA that support structured exception handling. In VBA the best you can do is call On Error Resume Next / Err.Clear / call cod
TAG : vba
Date : October 03 2020, 09:00 AM , By : DYC
How to check efficient whether a recordset value isnull before passing it to a called function?
How to check efficient whether a recordset value isnull before passing it to a called function?
will be helpful for those in need You could loop through the fields of your Recordset instead of hard coding for every field. Using your code as a starting point, it could look something like this:
TAG : vba
Date : October 03 2020, 03:00 AM , By : Paresh Vadhvani
Does the order that column names, from an ADO recordset, are referenced in VB6 or VBA code impact execution speed?
Does the order that column names, from an ADO recordset, are referenced in VB6 or VBA code impact execution speed?
wish helps you Without knowing the implementation details, it's hard to say for sure. However, I'd be gobsmacked if merely reordering the columns had effect on the speed. The reason is that I typically expect that to read a column, you have to first
TAG : vba
Date : October 02 2020, 06:00 PM , By : Bas Hania
VBA - How to get elements by src or alt at internet explorer
VBA - How to get elements by src or alt at internet explorer
Hope that helps I'm not too familiar with CSS selectors (so am sure someone else can/will give you a better answer), but this seems to work for me if I add a reference for Microsoft HTML Object Library:
TAG : vba
Date : October 02 2020, 05:00 PM , By : Essam Mansour
My macro prints invoices automatically but when multiple attachments are named the same, it prints only the first one mu
My macro prints invoices automatically but when multiple attachments are named the same, it prints only the first one mu
Hope that helps As you stated, created a naming convention to force unique file names among the attachments. This is done here with variable i
TAG : vba
Date : October 02 2020, 08:00 AM , By : Barnama Kdl
SolidWorks Macro "Copy with Mates"
SolidWorks Macro "Copy with Mates"
Hope this helps Not all soldiworks operations can be recorded as a macro. More complicated ones usually can't. If you want to automate it you'll have to do bulk of the work yourself. I'd suggest first to use API to figure out what kind of mates you'l
TAG : vba
Date : October 01 2020, 08:00 PM , By : HyunminKo
Powerpoint Visual Basic Save as Picture
Powerpoint Visual Basic Save as Picture
I hope this helps you . You're looking for Slide.Export.
TAG : vba
Date : September 30 2020, 02:00 PM , By : Michael Nip
Text with different styles in one paragraph Word VBA
Text with different styles in one paragraph Word VBA
I hope this helps you . While working with the Selection object feels "intuitive", it's not as accurate for writing code to manipulate Word as using Range objects. You can think about a Range as being an invisible selection, with the important differ
TAG : vba
Date : September 30 2020, 10:00 AM , By : Igor Martsenyuk
issue with concatenated subs
issue with concatenated subs
help you fix your problem It is best if you don't chain the macros, but instead call them from another sub. This way you will have a clear way of understanding what you are doing, in what order.
TAG : vba
Date : September 30 2020, 08:00 AM , By : DisplayName=
Cannot create files in while loop with Visual Basic 7
Cannot create files in while loop with Visual Basic 7
I wish did fix the issue. ofileSip is a TextStream and if you put it into a loop like you do then you try to access an "open" textstream when looping the second time. You need to close it first like that
TAG : vba
Date : September 30 2020, 04:00 AM , By : Michelle Wang
What is the function of the "#" in this string?
What is the function of the "#" in this string?
I wish this help you The is the delimiter for date/time literals in Access-SQL, or, as HansUp pointed out in the comments, in VBA code.
TAG : vba
Date : September 30 2020, 01:00 AM , By : Dj21
QueryDefs Field Count not counting correctly
QueryDefs Field Count not counting correctly
I wish did fix the issue. Access doesn't attempt to determine Fields.Count for a cross-tab QueryDef which includes a PARAMETERS declaration. For example, the WHERE clause in this query gives me 4 distinct values for q.Options_Value ...
TAG : vba
Date : September 29 2020, 09:00 AM , By : Ara Arakelyan
Compile Error on ExportAsFixedFormat - with PpFixedFormatIntent parameter (saving PowerPoint as PDF)
Compile Error on ExportAsFixedFormat - with PpFixedFormatIntent parameter (saving PowerPoint as PDF)
will help you The parameter name is Intent rather than ppFixedFormatIntent. I'm not seeing any issues with the following code:
TAG : vba
Date : September 29 2020, 09:00 AM , By : user6072140
VBA Global/Public variable scope
VBA Global/Public variable scope
I hope this helps . Your code works as is.But I'd advise against using Public variables unless necessary, and pass variables between subs, as follows:
TAG : vba
Date : September 28 2020, 07:00 PM , By : Andhika

shadow
Privacy Policy - Terms - Contact Us © 35dp-dentalpractice.co.uk