1
vote
1answer
85 views

Need to pull data from website after every 5 seconds using Vba [closed]

I need to pull data from www.dsebd.org after ever 5 seconds. this Vba code pull data but does not run automatically. Please help me. Sub ButtonCode() ' execute macros Call GetCotton ' ...
1
vote
0answers
53 views

Weird Excel 2010 VBA Window Behaviour

If I open Excel and then open the VBA window then close it, every time I RDP to my computer, the VBA window is open again, even if I closed it before disconnecting. The next time I am sat locally to ...
0
votes
0answers
58 views

Convert OO4 ODS to XLSX using Excel 2010 VBA

I am trying to bulk convert OpenOffice documents to Microsoft Office. Using built-in VBA, I use the following code (ODS to XLSX is shown, but same code is being used for ODT and ODP with some ...
1
vote
1answer
1k views

How to avoid references in VBA (Early Binding vs. Late Binding)

I found a VBA macro that prints Outlook attachments automatically. A rule triggers the macro. But the macro needs a reference to Microsoft Scripting Runtime to work. I saved the code in ...
0
votes
1answer
341 views

Rows in Excel VBA Macros

I need help in being able to do the following: In Worksheet A I have raw data. In Worksheet B I have a template with formulas. The data on Worksheet A change on a weekly basis. I need to find a ...
0
votes
3answers
846 views

Java is not recognized as an internal or external command in vba inside shell in a batch

Every time I try to call the java function from the shell function in vba or from the batch file from the shell function in vba it says that Java is not a recognized command. Though I can do this ...
1
vote
1answer
6k views

Windows 7 (64-bit) compatibility of VBA/Excel and Access applications

I am currently investigating the possible issues when migrating from Windows XP 32bit to Windows 7 64-bit. The scope is MS Excel (32-bit), MS Access (32-bit) using VBA/Macros addins, ODBC and all ...