VBA and command line
powershell -command "& 'D:\Scripts\WTV-MetaRenamer\wtv-metarenamer.ps1' "
I can figure out how to get this done in vba. I have search everything and tried shell and stuff, but I cant figure out how to run one line then the next
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Here's description. Windows (from XP onward I think) include one brilliant little command line app reg.exe which enables tons of tricky operations with Registry in very simple manner. For example, I need to copy a key with subkeys and values to new location (from HKLM to HKCU).
This little app does it in a single line command! and can of course be used from VBA through Shell command.
However, same line run from command prompt and through Shell function copies different keys. The one through command prompt copies asked key, the one through Shell function copies redirected key (from Wow6432Node, instead from HKLM\Software).
Of course, I don't want that! I know everything will be fine on x32 Windows, but on x64 Windows it simply reads wrongkey.
And that's exactly what I tried to avoid by this approach! Is there a way to run reg.exe from VBA as if it's run from command prompt, or force it not to redirect?
What I need to do is do the following
If "a certain condition is fullfilled" then
However when I write this in VBA editor in MS access, I get an error, it seems that the code dose not understand that "do this, and this, and this" should be executed if the condition is fullfilled, the code understands each line as a seperate command and it only executes the first line "do this" if the condition is met and not the other 2 lines "and this, and this" and I get other errors regarding Else and End if "that there is no if command"
how do you solve this so that VBA understands that the lines are "together
I have a command line program that I need to call (with parameters) in access. The program prints a line out to the command line and then quits - I need to somehow get the data it prints into access.
Anybody got any ideas/experience in this
probably 100 lines with each line being a separate shell command, but that doesn't work and neither does
Shell(" all lines")Is it possible to essentially shell many lines at the same time thereby making it possible to take say 100 lines resident in a batch file and just placing them all in the VBA module with shell command(s) instead of calling out the batch file that resides outside of the ms access file? It seems that I can only do single line shell commands?
I want to create a command button that when I click on it, a Query or Report will be created after selecting "Agency" and "Week", and writing a name for the Query/Report, showing the following:
Temps who work for the agency
Hours worked that week.
I know almost nothing of VBA, if someone would be able to give me some "general" code from which I can start figure out
I need to create a line graph and, using VBA, would like to:
* set line colour
* set line thickness
Bearing in mind that the graph will have numerous lines
For example field GCC in Line 9 should = (26/46)*100 to give me the % I require, however, to date I have singularly failed to work out either how to do this in VBA using the data source (its the same for both lines 1 and 7 in this case) or by doing an update query which keeps on giving me aggregate errors.
Doing this by VBA would be much easier for me - I'm dealing with 000s of potential lines across the tables I want to calculate, and having to write 3/4 queries to get to each line's result is going to be extremely onerous.