VBA Macro to pull data from secure website to excel

I have code to pull general data from a website into Excel using a macro, e.g. yahoo finance quotes. But, is it a possibility to pull data from a secure website (one that requires login) to automate a report? The link provided was close, but I don't understand how to pass the parameters in. Also,...

SandeepKommineni70 pointsBadges:

Recover password for Excel VBA macro

About a month ago, I set a password for an Excel VBA macro but now I forgot it. I can't download the Hex Editor. What should I do? How can I get my password?

ITKE1,068,100 pointsBadges:

VBA Do While Loop

Dim iJob As Integer Dim strJob As String iJob = 5 Do While ThisWorkbook.Sheets("Defaults").Cells(iJob, 21).Value <> "" And iJob <> 4 If ThisWorkbook.Sheets("Defaults").Cells(iJob, 21).Value = strJob Then Select Case ThisWorkbook.Sheets("Defaults").Cells(iJob, 21).Value Case strJob...

Wolfehound725 pointsBadges:

Needs to pass data from Excel to host on demand

I need to pass data from Excel to Host on demand 3270 mainframe and vice versa using VBA.

Kavithagowda5 pointsBadges:

Microsoft Access menus

How do you setup menus using MS Access?

Danljonessr10 pointsBadges:

Stop Excel VBA code manually

For VBA, does there happen to be a way to manually stop/pause an Excel VBA code? I know this is possible in Visual Studio. Thank you.

ITKE1,068,100 pointsBadges:

VBA: Find file name when downloading

I'm currently trying to download a file from Internet Explorer and save it through VBA. But when it's downloading, I need to figure out the file name too. How can I do that?

ITKE1,068,100 pointsBadges:

Tree view related bug in VBA

One of my colleage getting this error after upgradation of Office 365: Can't exit design mode because control tree view 1 can't be created in VBA. Please help me on this. Thanks in advance!

swapnaserudla5 pointsBadges:

Using VBA (in Excel) how to find attachment size for an email in Lotus Notes?

I am creating an Excel macro to automatically send some information including a few zip files. We use Lotus Notes 6.5 as email client. I want to make sure though that the total email size does not exceed the maximum for our server. How can I do this in VBA? Can I find what is the maximum size on...

Unknown12345 pointsBadges:

Rename Microsoft Access table using VBA

I'm sorry for the short question but does anyone know how I can rename a Microsoft Access table through VBA from Microsoft Excel? Appreciate the help.

ITKE1,068,100 pointsBadges:

How to tell if Microsoft Excel cell is within a given range

How can I tell if a Microsoft Excel cell is within a given range in VBA? What's the best way to do this? Thank you so much.

ITKE1,068,100 pointsBadges:

How to delete empty Microsoft Excel rows using VBA

What's the best way to delete empty rows in Microsoft Excel using VBA? I tried several times but I keep getting this error message: Run time error '1004': No cells were found. Thanks!

ITKE1,068,100 pointsBadges:

Lock data in Microsoft Excel cell using VBA

In Microsoft Excel, can I stop other users from editing the content in a certain cell using VBA? Basically - I need to lock the data.

ITKE1,068,100 pointsBadges:

How to round in Microsoft Access and VBA

By any chance does anyone know how to round in Microsoft Access / VBA? I figured out how to do it in Excel but I don't want to rely on that.

ITKE1,068,100 pointsBadges:

VBA: Set bold on specific text in Microsoft Excel string

In Microsoft Excel / VBA, can I bold specific text in my string that would go into my cell? What formula should I use?

ITKE1,068,100 pointsBadges:

VBA: Call FM SAPWL_STATREC_READ_REMOTE failed

Hi Experts, We monitor the response time of different SAP and Customer programs before and after any release change. We use the workload statistics in transaction STAD and export the data into Excel manually. We would to automate this process by using Excel VBA Script and download the workload...

walidde20 pointsBadges:

What are the basic parameters needed to assist an automation tool?

My concern is what are the basic key parameters to be considered for assisting an automation tool. In my company we are automating database (MySQL - Queries) part using 1st approach: Using stored procedures. 2nd approach: Using Excel VBA Macros.  For that we need to assist some basic parameters...

VijayVardhan5 pointsBadges:

Filtering a Record Selector (Microsoft Access)

I need help figuring out how to filter a combobox that serves as a record selector. I set up a box that provides clients name & need it to filter them by agents assigned to each customer once the filter is set but, i cant get it to filter out customers under other agents. I would prefer a...

mmorrison35 pointsBadges:

Excel has file big size

Hello, I have an .xls files I open with Excel 2007 every day. It is approximately 200 rows x 60 columns. Each day we create a copy of this file, and in the new copy, change the numeric value of 20 cells. No new columns or rows are added, there are no graphics/charts/etc. There is only one sheet. 10...

RossHutton15 pointsBadges:

Compact Microsoft Access database in VBA

My apologizes for the brief question but, in Microsoft Access, can I compact my current database using VBA? Thanks!

ITKE1,068,100 pointsBadges: