Tagged Questions
1
vote
2answers
20 views
Microsoft Visual basic 6.5 Ignore case
I am using
platform: microsoft visual basic 6.5 and excel
TxtMMM is a String prompt keyyed in by user. In this case i hardcode it as an e.g
but it(TxtMMM) could be Jan, JAN, jAn or jan
My problem ...
0
votes
1answer
25 views
Need help for coding in excel with VBA macros
I have kid of a big problem, or at least for me it's a big problem.
I am new at VBA and I wanted to do somehting that's possibly easy but I don't know how to.
So, for you it may be quite easy but it ...
1
vote
1answer
15 views
Clear Text boxes within a Multipage Control on Userform
I am working on a school project while learning vba for the first time. The project is built around a wedding planning worksheet. I plan to lockdown the worksheet so that formulas and formatting don't ...
1
vote
0answers
23 views
VBA Excel - UPDATE record in ACCESS
I got a problem.
I want to update an existing record in table in Access Database using VBA in EXCEL.
My code:
sqlik = "UPDATE query which works in access"
Set ZAP_QUERY2 = ...
0
votes
1answer
24 views
Comment vba code from another VBA CODE
I would like to comment the lines who contains Msg Box from another code VBA. I'm trying this with the Library VBA EXTENSIBILITY but i doesn't found the solution.
Any help is welcome.
This is my ...
0
votes
0answers
17 views
.send is randomly not working
I am crawling some informations out of the web with this function but sometimes it says "access denied". But WHY? I dont get it :(
Function getPage(URLStr As String) As MSHTML.HTMLDocument
Dim ...
1
vote
2answers
57 views
Excel - VBA : loop as long as content of a cell equals specific value
I am trying to modify my code to allow more factors to be taken into account when running a loop. Here is what I have so far, it's a loop running for i = 2 to 605 (because between 2 and 605, my G ...
0
votes
1answer
29 views
Is there a way to call nonstandard shapes in VBA; using application.caller does not work
I want to assign a macro to shapes in my workbook where the macro assigns a relative hyperlink to the shape that called it. I tried using application.caller to get the name of the shape to assign the ...
1
vote
2answers
38 views
Group, count, and copy by multiple field values in excel programatically
Hi I have a spreadsheet that I need to count and group based on multiple values. Using the example below I need it to count a row only if Shipper - Shipper city, Recipient, and Recipient city are all ...
1
vote
1answer
11 views
Issue while publishing chart from excel to HTML using the xlHTML properties
I am trying to publish chart from excel to HTML file which I wish to further use in automated outlook mail.
below is the code:
Sub SaveChartWeb()
Dim wb As Workbook
Dim ws As Worksheet
Set wb = ...
0
votes
1answer
47 views
Excel VBA - check if function/sub is present in another workbook
How can I check with VBA that a sub/function exists in a workbook?
I am writing a macro includes a call on sub in a different workbook. I can get the sub in the other workbook to run ok using code in ...
0
votes
3answers
38 views
Excel - VBA : set the standard format for all the cells of my Sheet once and for all
I am having a very annoying problem with excel : I have some VBA macros whose purpose is to fill in some other cells with some contents. My problem is that excel keeps changing the format of some cell ...
-1
votes
2answers
28 views
Auto open macro fails after renaming file
I have a file that has an auto_open macro that launches another macro called OpenFIles. I had to save the file under another name because the file only opened in read-only mode when I was working ...
0
votes
0answers
34 views
Connect Userform of Excel to access database table
I have created a userform in Excel VBA which collects data and makes a record in the same excel sheet that i am using.
I would like to take it further by connection it to a Microsoft access database ...
4
votes
2answers
100 views
Unprotect VBProject from VB code
How can i unprotect my VB project from a vb macro ?
i have found this code:
Sub UnprotectVBProject(ByRef WB As Workbook, ByVal Password As String)
Dim VBProj As Object
Set VBProj = ...
