In an Excel macro, inside a loop I issue the following,
where the names are unique each time:
Workbooks.Open Filename:=openFYL$
With Worksheets(1)
' .Copy''do not need; saves BOOKn space
.SaveAs svWK$
End With
' NOTE: Related metadata folders are created on the fly
This routine USED to work.
I added two lines of comment to indicate the problem.
...
vNam = Cells(2, 7).Text + "V" 'board voltage
pPath = "D:\ANALOG\HVREG\Boards\TITANTWO\TT_C\Jumpers\"
ActiveSheet.Shapes(1).Select
' ERROR: Method of 'Active Printer' of object '_Application' faile
data at the end, and give options at the start for "what
is next".
Now,it would be useful to be able to position that input box, as well as
change the font of the text in the box.
And, i think lastly, have the app automatically run when the XLS program
is launched.
Thanks,
Robert B
ell.FormulaR1C1
> ' check alfa?
> Wend
>
> End Sub
>
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Tue, Oct 21, 2014 at 12:39 AM, Robert Baer > wrote:
>
>>
>>
>> On Monday, October 20,
On Monday, October 20, 2014 12:48:25 AM UTC-7, Vabz wrote:
>
> Hi can you share sample files...
>
> +
>
>
Here is what i have so far..present question imbedded
Dim Avar As String, Nvar As Integer
Dim Frow As Integer, Fcol As Integer
' Start row data entry
Frow = 9: Fcol = 1 ' aka "A"
On Saturday, October 18, 2014 8:16:05 PM UTC-7, Robert Baer wrote:
>
> Assume one has a spreadsheet with some titles and column headings, along
> with a row of data already filled out by an automated copy from a previous
> "journal".
> Pardon this is long; thin
Assume one has a spreadsheet with some titles and column headings, along
with a row of data already filled out by an automated copy from a previous
"journal".
Pardon this is long; think i have given all what i want out of this Excel
"program".
Assume previous journal (sheet) had a number,
